[2005] Multiple DGV Rows

[Alexandru_mbm]

Hello to all again,

I have a problem and i have to ask you my friends about it...

How can i INSERT the HOLE DataGridView to my Access DataBase ?

For a single position from a textbox i know it but i don't know how can i do it for a hole DGV!

Thanks in advice!

[jmcilhinney]

Create a DataTable with the appropriate schema and bind it to the grid. After the user has added the desired data to the grid you simply call Update on a DataAdapter or TableAdapter and pass the bound DataTable as a parameter.

Note that your controls have NOTHING to do with data access. Controls are just a way of displaying data to the user and accepting input. Data access is what it is whether you're using controls to interact with the user or not. For some ADO.NET code examples follow the Data Access link in my signature.