开发者

How I update my Access table through textbox interface and show result into grid view?

开发者 https://www.devze.com 2023-03-28 13:47 出处:网络
String conn=\"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\\\\Data.accdb\"; string query = \"Insert Into Ve开发者_如何转开发nue values(@venueID,@vanueName)\";
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

0

精彩评论

暂无评论...
验证码 换一张
取 消