C# Commit changes in DataGridView to DataTable

Question

I need an example of code or project with one DataGridView Form and one DataTable so I can edit DataGridView cells and then all the changes are automatically commited into the DataTable. Also how can I create DataTable with the same columns with DataGridView other way that manually?

I tried to create DataGridView and DataTable with the same columns manually and then set the DataGridView.DataSource = DataTable, but data saved into the table are null (anyway number of new rows is correct, but values are invalid).

Tried to google it - all the samples and questions are about savind into DataBase, but I don't need a DB, I just need a simple DataTable and DataGridView binding.

Thanks!

Thorsten Dittmar · Accepted Answer · 2012-05-09 11:42:50Z

There's no way to create a table automatically from the DataGridView columns (EDIT To refine this: There are ways to automatically create database structures - ORM would be a good keyword here - but I guess that's not what you need). The other way round works well: Create the table and assign it to the DataGridView as its data source. Then the grid should show the respective columns.

"Storing" the values in the data table works only if you have "told" the columns, which field of the underlying table they relate to. That is: You need to create the table columns (it has a name), and when you create the DataGridView column, you need to assign the column name to the DataPropertyName property of the column.

Easiest way for you: Create a typed dataset (use the "Add to project" dialog to add a new "DataSet"), manually create a table in the dataset's designer, drag an instance of your dataset to the form and assign this as the data source to your DataGridView. Everything else should appear automatically.

Pratik · Accepted Answer · 2012-05-09 11:43:45Z

1

I hope you this links from codeproject might help:

http://www.codeproject.com/Questions/80935/save-datagrid-data-to-database

http://www.codeproject.com/Articles/12846/Auto-Saving-DataGridView-Rows-to-a-SQL-Server-Data

answered May 9, 2012 at 11:43

Pratik

1,5027 gold badges21 silver badges36 bronze badges

Comments

ALUM22 · Accepted Answer · 2013-01-10 16:07:18Z

1

If your DataTable is set as the DataSource for the dataGridView, the contents in the dataGridView will reflect the data in the DataTable and vice versa. Therefore, if you make changes to the dataGridView, those changes are already in the DataTable.

answered Jan 10, 2013 at 16:07

ALUM22

1091 silver badge10 bronze badges

Comments

timrau · Accepted Answer · 2012-08-19 08:02:29Z

0

Convert DatagridView To DataTable.
In C#.NET:

DataTable dt = ((DataView)this.dataGridView1.DataSource).Table;

VB.NET:

Dim dt As DataTable = CType(Me.dataGridView1.DataSource,DataView).Table

edited Aug 19, 2012 at 8:02

timrau

23.1k4 gold badges55 silver badges67 bronze badges

answered Aug 19, 2012 at 6:26

Keyur Harshwal

21

1 Comment

technonaut Over a year ago

This generated a Unable to cast object of type 'System.Data.DataTable' to type 'System.Data.DataView'. exception. It is an interesting idea though, so I changed it to Dim dt As DataTable = CType(Me.DataGridView1.DataSource, DataTable) to see what happens. It actually did a conversion (sort of) without error, but there were no rows in the table - the resulting table didn't actually contain the data from the datagridview.

Collectives™ on Stack Overflow

C# Commit changes in DataGridView to DataTable

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related