ACCESS数据库的表名不应命名成"Exception"。本以为它放在SQL语句中,应该没事的,但是在执行到这里时老是出错。把表名改掉就好了。
出错图:
![](/images/cnblogs_com/manio/erreerer.jpg)
出错代码:
private void SaveData()
{
OleDbConnection thisConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Manio\My Documents\PrintManager\program\PrintManageV1\DataBase\PrintDB.mdb");
thisConnection.Open();
OleDbDataAdapter thisAdapter = new OleDbDataAdapter("SELECT * FROM Exception ", thisConnection);
MessageBox.Show("SELECT * FROM Exception WHERE D_StuNum = " + this.fTxtStuNum.Text);
OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);
![](/Images/OutliningIndicators/InBlock.gif)
DataSet thisDataSet2 = new DataSet();
![](/Images/OutliningIndicators/InBlock.gif)
thisAdapter.Fill(thisDataSet2, "Exception");
MessageBox.Show("OK");
}
出错图:
![](/images/cnblogs_com/manio/erreerer.jpg)
出错代码:
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](/Images/OutliningIndicators/None.gif)