insert into datagrid to database

[papershop]

Dear All

i need help how to insert data into sql database form a datagrid...

this is the example....

i have view data from tabel sales in a data grid

product name sales jan sales feb sales mar

MILK 10 15 20
Biscuit 7 6 9
Tea 5 15 30

from that kind of data i wouldlike to input it to table target..so i will edit some of
the data then i will save it to tabel target...

i want to just klik one button and will save all data in that datagrid to tabel target

please help me :'(

[kvprajapati]

Steps:

1. Read Items collection of DataGrid.

foreach (DataGridItem  row in DataGrid1.Items)
   {
        
   }

2. Use ADO.NET data provider to insert each row into a table.

[pritesh2010]

hi
see the below link which tell you how to save the data from datagridview to datatable.
http://geekswithblogs.net/dotNETvinz/archive/2009/08/02/save-dynamic-textbox-values-from-gridview-to-database.aspx