string conn = "server = localhost;integrated security=sspi;database=LMS";
string commandString = "SELECT * FROM Borrow_info WHERE 借阅证号='" + TextBox1.Text.ToString() + "'";
SqlDataAdapter DataAdapter = new SqlDataAdapter(commandString, strconn);
DataSet myDataSet = new DataSet();

//填充DataSet对象
DataAdapter.Fill(myDataSet);
GridView1.DataSource = myDataSet;
GridView1.DataBind();

要是我把第二句换成string commandString = "SELECT * FROM Borrow_info ";就会所有记录都显示
现在就什么记录都不显示了.应该是第二句错了,请帮帮忙啊!

我按上面的所有方法都试过了还是不行啊.
我现在已经把数据库字段改成了英文.
string commandString = "select * from Borrow_info where ITID='"+ TextBox1 .Text .ToString () +"'";
还是不行啊!没有后面的where 语句就可以全面显示出来.
ITID不是表的主键没关系吧.

好奇怪啊,现在又好了,我写的是下面的代码.
string commandString = "SELECT * FROM Borrow_info WHERE ITID='" +TextBox1.Text +"'";
给各位添麻烦了.