Vb.net – Using DataGridView to Update Multiple Tables

databasedatasettableadaptervb.net

On a VB.NET 2008 form I have a DataGridView, BindingSource and TableAdapter.

The BindingSource DataSource is a dataset.

In the dataset I have a Fill command that joins three tables and this is displayed without a problem in the DataGridView.

However, I am unable to Update the dataGridView because it has multiple tables from a single TableAdapter?

Does anyone know a simple way I can update. The tables has over 200 columns and I only want to update the columns that are changed. If I use a single table I can edit data in the DataGridView and the database is updated ok.

Any help would be appreciated?

Thank you.

Best Answer

Unfortunately, the Windows.Forms BindingSource, does not support complex properties (which I assume you are after).

You would have to craft your own custom BindingSource (and it will likely be bespoke to you) to handle complex property values and assignments.

Related Solutions

Sql – How to list the tables in a SQLite database file that was opened with ATTACH

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

R – VB.NET: Getting DataGridView to Populate from Stored Procedure

Maby you did something like:

datagridview.datasource = ds

(That will show you an empty grid)

Try

datagridview.datasource = ds.tables(0)

Best Answer

Related Solutions

Sql – How to list the tables in a SQLite database file that was opened with ATTACH

R – VB.NET: Getting DataGridView to Populate from Stored Procedure

Related Topic