update database through datagridview

Written by


Hello Friends,
I am getting a problem to update the database from datagridview row.
I am using the following code

private void showButton_Click(object sender, EventArgs e)
{
con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\MoneyData.mdb");
String query = "SELECT * FROM Categories";
da = new OleDbDataAdapter(query, con);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];

con.Close();

}

private void UpdateButton_Click(object sender, EventArgs e)
{
da.Update(ds);
}

if i run the code
i am getting the following error
"Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."
Please help me…
thank you

The rest is here:
update database through datagridview

Related posts:

  1. Cannot update values to multiple rows i dataGridView Hi, I am using Visual Studio 2010 RC, but...
  2. Update datagridview in runtime Hi! I have a project with widnow forms. On...
  3. Update datagridview in runtime Hi! I have a project with widnow forms. ...
  4. Update datagridview in runtime Hi! I have a project with widnow forms. On...
  5. Update datagridview in runtime Hi! I have a project with widnow forms. On...

Related posts brought to you by Yet Another Related Posts Plugin.

Jul
10

Leave a Reply