Datagrid dump to a dataset

Question

Hi I ned to dump data from a grid to a dataset to update a new DB I have created the dataset The problem I am having is getting the data from the grid Can anyone explain how I can dump the grid into my dataset? Thanks George

Bechir Bejaoui · Answer

Because if you want that you datagrid be unbound and that from it you transimt data to the data set then you have to create a data table in the data set to recieve data datatable dt = ds.tables.add(...) then you have to dimension the data grid for(int i =0;i { datagridview1.columns.add(column + i.tostring()column + i.tostring()); } for(int i =0;i { datagridview1.Rows.add(); } once the datagridview is dimensioned then you create double boucle that assign each value entred in the datagridview to the data table dt[index][index]

George Laing · Answer

Hi The datagrid does have a datsoource but the member field is empty. Thanks

Bechir Bejaoui · Answer

Ok then you want that the datagridview is not bound am I wrong? you do use an unbound datagrid to fill a data table

George Laing · Answer

Hi In this case the datagrid was filled by a xml file I want to put the changes from the grid to a new dataset. I can't seem to get the grid to load a new dataset. Thanks

Bechir Bejaoui · Answer

if you put datagridVew.datasource = yourdataset; datagridview.datamember = dataset.tables[0].TableName; Normally the datagridview and your data set are tied am I miss understand you?

George Laing · Answer

Windows

Bechir Bejaoui · Answer

Is it a web or windows grid view