Question

I m using Visual Studio C# 2008
I ve created (visually) a dataset that points to a mdb file (Access 2007)
This DataSet is called "EstacionarDataSet"

EstacionarDataSet ed = new EstacionarDataSet();
DataRow newRow = ed.Tables[0].NewRow();
newRow["patente"] = tb_Patente.Text;
newRow["numerobox"] = tb_Box.Text;
newRow["fechahora_ingreso"] = DateTime.Now;
ed.Tables[0].Rows.Add(newRow);

This code is executed in a Form2 (not mainform), where I m trying to insert a new record into the only table mdb file has (this code doesn t work, but doesn t give any exception).
The mainform contains a System.Windows.Forms.DataGridView component, attached to this mdb file, which works fine, it shows the records correctly, etc. (PS: I added some sample records using Access)
I m needing some code samples for adding a new row, updating, and deleting... Thanks

Answer 1

You need to understand how DataAdapter works:

read this article

DataAdapter

or many other in the web.

Then All you need is a connection object to the MDB, A configured dataadapter with select insert and update commands (can be easily done with the wizard).

and fill a table or dataset with the data, binding it to the gridview.

友情链接