Question

c#根据textbox里的值从数据库中取出匹配结果放到gridview中怎么没反映？代码如下：

SqlConnection conn = new SqlConnection(constr);
string sqlstr = "select * from 报表307_313 where 班级名称='"+this.TextBox1 .Text .ToString ()+"' ";
SqlDataAdapter sda = new SqlDataAdapter(sqlstr, conn);
DataSet ds = new DataSet();
conn.Open();
sda.Fill(ds, "报表307_313");
GridView1.DataSource = ds;
GridView1.DataBind();
conn.Close();

Answer 1

1。如果是nvarchar字段，需要前面加N，即N'XXX'
2。先下断点确定ds的表“报表307_313”是否有数据
3。GridView1.DataSource = ds["报表307_313"];不是ds，绑定的是datatable对象

Answer 2

你确定textbox的属性都正确吗？

Answer 3

怎么不设置个参数进行传值。而且textbox最后应该this.txtStartDate.Text.Trim()吧

Answer 4

string sqlstr = "select * from 报表307_313 where 班级名称='"+this.TextBox1 .Text .ToString ()+"' ";
改为 string sqlstr = "select * from 报表307_313 where 班级名称='"+this.TextBox1 .Text .trime()+"'";
GridView1.DataSource = ds.table["报表307_313"];