Insert from DataGridView

[shers]

Hi,

Could anybody give me some example code to insert rows of datagridview into a sql express database table? Also, how do I manage concurrency as it is a multi user application?

Thanks

[Phil Weber]

http://social.msdn.microsoft.com/For...-5cda2ed6025b/
http://www.codeproject.com/KB/databa...idView2Db.aspx

[shers]

Sorry, that didn't help.

Thanks

[Phil Weber]

Can you be more specific? Why didn't it help? What problem are you having?

[shers]

I have 3 database tables, of which two contains data and one named 'Details' is exclusively for data entry by the user. In the GUI created by VB.NET, I have a datagridview control and a couple of text boxes and comboboxs. The user fills in these controls including the datagridview. After data entry, the user clicks on a button to submit these records to the Details table. I would like to know how to code in the submit button.

Thanks

[Hack]

Couldn't you simply UPDATE the existing record in the database based on the textboxes and combo boxes, then clear and reload your grid so those changes would be reflected for display.

[shers]

The records in the datagridview contains more fields than the other existing tables. So I have created a table only for storing user data. The other two tables are only for retrieving certain values like Unit Cost and Project No.

Thanks