How I update my Access table through textbox interface and show result into grid view?
<pre><code>String conn="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\\Data.accdb";
string query = "Insert Into Venue 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 ;
</code></pre>
