(SELECT * FROM table)
I have added mysqlCommandBuilder in design mode to mysqlDataAdapter. Do I have to add commands for updating to mysqlCommandBuilder ??
How can i use mySqlDataAdapter1.Fill(dataSetDB); without my own command ??
I am obtaining data from data base and put it into data grid like this.
(works fine)
Code: Select all
DataSet dataSetDB=new DataSet();
mySqlConnection1.Open();
mySqlDataAdapter1.Fill(dataSetDB);
dataGrid1.DataSource = dataSetDB.Tables[0];
mySqlConnection1.Close();
Code: Select all
mySqlConnection1.Open();
dt = (DataTable)dataGrid1.DataSource;
mySqlDataAdapter1.Update(dt); //<--this line generates InvalidOperationException
mySqlConnection1.Close();