ACCESS数据库的表名不应命名成"Exception"。本以为它放在SQL语句中,应该没事的,但是在执行到这里时老是出错。把表名改掉就好了。
出错图:
![]()
出错代码:
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);
![]()
DataSet thisDataSet2 = new DataSet();
![]()
thisAdapter.Fill(thisDataSet2, "Exception");
MessageBox.Show("OK");
}
出错图:

出错代码:
















