我想根据条件,自己创建一个 DataTable和BindingSource。但出现了这样的错误提示:“未处理SqlException”,并且没有排错提示。我看了整整一天了,不知道怎么改错啊?msdn上的示例就是这样子写的。
SqlDataAdapter selectTableAdpter = new SqlDataAdapter("SELECT * FROM Stu_Info", connectStr);
DataTable absentstuTable = new DataTable();
selectTableAdpter.Fill(absentstuTable);
BindingSource myBindingSource = new BindingSource();
myBindingSource.DataSource = absentstuTable;
comboBox1.DataSource = abs;
请大侠们一定指导哦!很很着急!
SqlDataAdapter selectTableAdpter = new SqlDataAdapter("SELECT * FROM Stu_Info", connectStr);
DataTable absentstuTable = new DataTable();
selectTableAdpter.Fill(absentstuTable);
BindingSource myBindingSource = new BindingSource();
myBindingSource.DataSource = absentstuTable;
comboBox1.DataSource = abs;
请大侠们一定指导哦!很很着急!
2.表Stu_Info是否确实存在于指定的数据库中?
{
//查询数据
}
catch
{}
connectStr是否正确
{
using(SqlConnection myConnection=new SqlConnection(""))
{
string sql="";
SqlDataAdapter adapterA=new SqlDataAdapter(sql,myConnection);
DataTable dt=new DataTable();
adapterA.Fill(dt);
}
}
catch(Exception ex)
{
throw ex;
}