SqlConnection oSQLConn = new SqlConnection();

oSQLConn.ConnectionString = "Connection string "

SqlDataAdapter sqlDa = new SqlDataAdapter("select * from table1", oSQLConn);

//create dataset instance

DataSet dSet = new DataSet();

//fill the dataset

sqlDa.Fill(dSet, "table1");

//bind the data grid with the data set

dataGridView1.DataSource = dSet.Tables["table1"];

Hi,

Yes, you've gotta specify the COmmands needed to send your updates to the database.

SqlDataAdapter sqlDa = new SqlDataAdapter("select * from table1", oSQLConn);
sqlDa.InsertCommand = new SqlCommand("INSERT INTO table1 WHERE myId = @id", oSQLConn);
//Also specify the parameters...
sqlDa.InsertCommand.Parameters.Add("@id",.....);
//also same with the update command
sqlDa.UpdateCommand = new SqlCommand("UPDATE table1 SET ...", oSQLConn);

Just search the docs for more details...

cheers,

Paul June A. Domag

Hi,

You'll have to implement the UpdateCommand and DeleteCommand properties of your dataadapter. and call the dataAdapter.Update(dataTable) to send the changes to the database...

cheers,

Paul June A. Domag

SqlDataAdapter sqlDa = new SqlDataAdapter("select * from table1", oSQLConn);

Should I do something differant from the above statement
Thanks
DossT

Hi,

Yes, you've gotta specify the COmmands needed to send your updates to the database.

SqlDataAdapter sqlDa = new SqlDataAdapter("select * from table1", oSQLConn);
sqlDa.InsertCommand = new SqlCommand("INSERT INTO table1 WHERE myId = @id", oSQLConn);
//Also specify the parameters...
sqlDa.InsertCommand.Parameters.Add("@id",.....);
//also same with the update command
sqlDa.UpdateCommand = new SqlCommand("UPDATE table1 SET ...", oSQLConn);

Just search the docs for more details...

cheers,

Paul June A. Domag

Hello,

I have a similar problem with a form having a datagridview bound to a SqlExpress table, by dragging a datasource to a form.

The datagridview allows me to enter new rows without any problem. However, when I close the application and start again, the added rows have disappeared, i.e the underlying database is not being updated !!

I have searched the forum and tried different solutions without success. It seems like dragging and dropping a datasource to a form is not enough to produce a form with datagridview for data entry ??!!!

I would be very much grateful if you could point me to a such an example project working properly.

Thank you.

Hi there,

when editing tables, you are only modifying locally, you need to hit the save button on the top of the grid before closing.

Cheers