how to get data from a datagridview and insert into database?

Question

hi guys

i ve a datagrid and wen a button s clicked i want the values from the datadrid to the database..

thanx in advance

Answer 1

The question is how do you populate that datagridview with data in the first place.

If you use data-binding to a DataSet/DataTable - the framework will automatically "remember" all the changes that you've made. After that, you use DataAdapter and CommandBuilder to generate INSERT, UPDATE & DELETE statements - and commit changes through Update method on DataAdapter.

Search the Internet a little bit on this, there are tons of tutorials and other resources.