Question

C# 程序走到da.Fill(ds);就抛异常，求大神指点！！！！！

string connstr, StrSQL;

StrSQL = "SELECT * FROM table1 WHERE companylast ='" + this.comboBox1.Text.Trim() +"'and Names = '" + this.comboBox2.Text.Trim() + "'";
// elect id from bbs_admin where UserName='" + uName + "' AND UserPassword = '" + uPwd + "'"
connstr = "provider=Microsoft.jet.oledb.4.0;data source=" + Application.StartupPath + "\\ykzdkhcj.mdb";
OleDbConnection conn1 = new OleDbConnection(connstr);
conn1.Open();

OleDbDataAdapter da = new OleDbDataAdapter(StrSQL, conn1);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable mytable = new DataTable();
mytable = ds.Tables[0];

Answer 1

能把你的异常贴一下吗？顺便说一下你打开了数据库连接就要在获取数据集之后把数据连接关上

Answer 2

and前掉了一个空格。。。。