How I update my Access table through textbox interface and show result into grid view?
String conn="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\\Data.accdb";
string query = "Insert Into Ve开发者_如何转开发nue values(@venueID,@vanueName)";
OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, conn);
OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(dAdapter);
DataTable dTable = new DataTable();
dTable.Rows.Add("@vanueName", textBox1.Text);
dAdapter .Fill (dTable );
dataGridView1 .DataSource =dTable ;
I am not quite sure the Fill method is updating your DB
精彩评论