|

楼主 |
发表于 2020-5-9 08:30:01
|
显示全部楼层
能帮忙看看以下这段话哪里错了?在ds.fill的地方报错
OleDbConnection con = new OleDbConnection("server=lo;uid=sa;pwd=sa;database=test;Provider=SQLOLEDB");
string sql = "select * from members where userName=@userName";
con.Open();
OleDbDataAdapter da = new OleDbDataAdapter(sql,con);
da.SelectCommand.Parameters.Add("@userName", this.TextBox1.Text.Trim());
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
this.DataGrid2.DataSource=ds.Tables[0];
this.DataGrid2.DataBind(); |
|