I am facing problems while updating through DataGridView.

There is a table with fields srno, sname, saddr, scity, sstate. All the fields should be updated based on srno.

I tried a lot. the contents in the datagridview are updated but those changes are not reflected in the actual database.

Please tell me how to update as well as delete the rows.

I am not using any wizard. and connecting controls on runtime.

I am using C# 2005.