我使用以下代碼DataGridView從 Access 數據庫中填充 a 。如果更新了數據網格,則單擊“保存”按鈕后,數據庫將保存數據。奇怪的是,這適用于 3 個數據表中的 2 個。對于最后一個它拋出異常:INSERT INTO 語句中的語法錯誤public Tables(string tabName){ InitializeComponent(); this.Text = tabName; this.query = string.Format("SELECT *" + " FROM [{0}]", tabName); conn.Open(); detailTable = new DataTable(); string tableName = tabName; string query = string.Format("SELECT * FROM [{0}]", tableName); OleDbDataAdapter detailAdapter = new OleDbDataAdapter(query, conn); if (detailAdapter != null) { detailAdapter.Fill(detailTable); } DataGridView.DataSource = detailTable; conn.Close();}private void BtnSave_Click(object sender, EventArgs e){ OleDbCommand comm = new OleDbCommand(query, conn); OleDbDataAdapter adapter = new OleDbDataAdapter(comm); OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter); adapter.Update(detailTable);}即使這些詞是保留關鍵字(盡管我搜索了它們),也沒有辦法解決這個問題。更多信息 tabName 可以是“Partners”、“Salaries”、“Descriptions”和“Accounts”。它不僅適用于“合作伙伴”。
添加回答
舉報
0/150
提交
取消