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 :'(
Jump to PostSteps:
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.
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.
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.