这样的数据库查询语句为什么执行一次查询工作后就不能再查询了?
void SubmitBtn_Click(Object Sender, EventArgs e)
{
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath("myweb.mdb");
OleDbConnection MyConn = new OleDbConnection(MyConnString);
DataSet ds = new DataSet();;
OleDbDataAdapter MyAdapter = new OleDbDataAdapter();
OleDbCommand cmd = new OleDbCommand("select * from Members where UserName like '%'+'"+TextBox1.Text+"'+'%' ",MyConn);
MyAdapter.SelectCommand = cmd;
MyAdapter.Fill(ds,"Members");
MyDataGrid.DataSource = ds;
MyDataGrid.DataMember = "Members";
MyDataGrid.DataBind();
}
我在输入框中输入一个陈字,可以找出名字里有'陈'这个字的全部同学,可是当我执行一次后第二次就不能再查了,还望高手赐教!谢!!