populate a dataset with datagridview content

[dennysimon]

hello all

suppose I have fill a datagridview (named it mydgv)
,Can I populate a dataset with the data from the content of mydgv ?
if yes how

thank you

denny

[shridharmaster]

Just tell me how would you want to populate the dataset( means do you want to populate the dataset row by row of datagridview or do you want to populate the whole dataset from the datagridview at single time)?

[dennysimon]

hi Shridarmaster

Don't care about row by row or whole in a time
both will be usefull to me

thank you
denny

[Mitja Bonca]

1st you need to create columns, then you fill the row (by looping through rows of dgv):

DataSet ds = new DataSet();
DataTable table = new DataTable("DataFromDGV");
//if you have only one table, it pointless to create a dataSet
//dataSet is used as a collection of more-then-one dataTable
//so you can do:
ds.Tables.Add(table);
//create columns:
foreach(DataGridViewColumn col in dgv.Columns)
     table.Columns.Add(col.HeaderText, typof(string));
//fill the rows of table:
foreach (DataGridViewRow row in dataGridView1.Rows)
{
     foreach (DataGridViewCell cell in row.Cells)
     {
          table.Rows[row.Index][cell.ColumnIndex] = cell.Value;   
     }          
}

[dennysimon]

Hi Mitja Bonca

Thank you

denny