第一次写WINDOWS应用程序(C#)札记2(不能用的数据库表名)时间:2021-07-26 09:12:14ACCESS数据库的表名不应命名成"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"); }