我要在DataSet中填充两张表,第一张表填充成功,第二张表填充失败,有未处理的异常,代码如下:OleDbConnection conn = new OleDbConnection(strConn)
OleDbDataAdapter adpt = new OleDbDataAdapter("select * from STUDENT.DBF", conn);
DataSet ds = new DataSet();
adpt.Fill(ds, "STUDENT");
adpt = new OleDbDataAdapter("select from TEACHER.DBF", conn);
adpt.Fill(ds, "TEACHER");
conn.Close();倒数第二行代码抛出未处理异常,看不懂是什么原因
OleDbException was unhandled
SQL: Statement is invalid.并不是第二张表有问题,我试了下先查teacher再查student仍然是倒数第二行代码抛出同样的未处理异常,第一张表正常。谢谢~
OleDbDataAdapter adpt = new OleDbDataAdapter("select * from STUDENT.DBF", conn);
DataSet ds = new DataSet();
adpt.Fill(ds, "STUDENT");
adpt = new OleDbDataAdapter("select from TEACHER.DBF", conn);
adpt.Fill(ds, "TEACHER");
conn.Close();倒数第二行代码抛出未处理异常,看不懂是什么原因
OleDbException was unhandled
SQL: Statement is invalid.并不是第二张表有问题,我试了下先查teacher再查student仍然是倒数第二行代码抛出同样的未处理异常,第一张表正常。谢谢~
解决方案 »
- 函数表达式 CheckTime(string Operate)
- FlowLayoutPanel中控件的更新问题
- 匿名怎么传参数如ToDataTable<T>(IEnumerable<T> varlist)
- C# 串口通讯接收255(FF),有时却接收到(127).用串口助手打开端口后,又收到到255(FF)
- 我在程序中做了一个远程备份,但备份到了我连接服务器的机子上了,我如何将这个.bak文件复制到我本地呢??然后再把服务器的文件删除,这次加高分,谢了?
- 从excel单元格里读取日期为字符,再将该字符转换为DateTime,报错
- Graphics 闪烁问题
- 昨天那个问题还没解决,先结贴,再开一贴
- 女朋友从北京来上海看我,高兴!散分!
- WPF 窗口与窗口之间的显示优先级
- 点击保存按钮将文本框的值添加到Hashtable中
- C#中用sql server插入数据并立马查出自增长id
比如:adpts = new OleDbDataAdapter("select from TEACHER.DBF", conn);
adpts.Fill(ds, "TEACHER");这个 应该跟OleDbDataAdapter具体实现机制有关系吧 暂时还不懂 坐等高手解释.
TEACHER.DBF 是Visual Foxpro数据库的一张表,从表中取出所有内容难道不是这么说吗?
试了一下一楼的方法,改为:
OleDbDataAdapter adpt1 = new OleDbDataAdapter("select * from STUDENT.DBF", conn);
DataSet ds = new DataSet();
adpt1.Fill(ds, "STUDENT");
OleDbDataAdapter adpt2 = new OleDbDataAdapter("select from TEACHER.DBF", conn);
adpt2.Fill(ds, "TEACHER");仍然在相同的地方报相同的错误
OleDbDataAdapter adpt = new OleDbDataAdapter("select * from STUDENT.DBF", conn);
DataSet ds = new DataSet();
adpt.Fill(ds, "STUDENT");
adpt.SelectCommand.CommandText="select from TEACHER.DBF";
adpt.Fill(ds, "TEACHER");
cmd.CommandText ="select * from STUDENT.DBF";
cmd.Connection = strConn;
obj = cmd.ExecuteScalar();
DataSet ds = new DataSet();
adpt.Fill(ds, "STUDENT");
cmd.CommandText = ="select * from TEACHER.DBF";
cmd.ExecuteNonQuery();
adpt.Fill(ds, "TEACHER");
SQL 有问题
SqlDataAdapter adpt = new SqlDataAdapter("select * from tb_Student", conn);
DataSet ds = new DataSet();
adpt.Fill(ds, "tb_Student");
adpt = new SqlDataAdapter("select * from tb_Teacher", conn);
adpt.Fill(ds, "tb_Teacher");
各位高手能解释下吗?谢谢