刚学这方便的……想GridView和SqlDataSource绑定之后,想用实现SqlDataSource动态查询然后返回值给Gridview显示。不知道是不是代码错了……string firstname = TextBox1.Text;
string lastname = DropDownList1.Text; DataTable dt = new DataTable ();
string connstr = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connstr))
{
string sql = "select * from [persons] where [firstname] = @firstname and [lastname] = @lastname";
using (SqlCommand comm = new SqlCommand (sql ,conn))
{
conn.Open(); comm.CommandType = CommandType.Text;
comm.Parameters.Add(new SqlParameter("@firstname", firstname));
comm.Parameters.Add(new SqlParameter("@lastname", lastname)); using (SqlDataReader dr = comm.ExecuteReader())
{
dt.Load(dr);
}
SqlDataSource1.DataBind();
GridView1.DataBind(); }
}
}
string lastname = DropDownList1.Text; DataTable dt = new DataTable ();
string connstr = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connstr))
{
string sql = "select * from [persons] where [firstname] = @firstname and [lastname] = @lastname";
using (SqlCommand comm = new SqlCommand (sql ,conn))
{
conn.Open(); comm.CommandType = CommandType.Text;
comm.Parameters.Add(new SqlParameter("@firstname", firstname));
comm.Parameters.Add(new SqlParameter("@lastname", lastname)); using (SqlDataReader dr = comm.ExecuteReader())
{
dt.Load(dr);
}
SqlDataSource1.DataBind();
GridView1.DataBind(); }
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货