How to modify the records in the dataset

wxmzhht

I want to modify several columns in the dataset. For example, one column in the dataset is schoolID, but the datagrid bound to it requires the schoolName to be displayed. There is a school table in the library, and the schoolName can be obtained through schoolID.
Thank you all in advance!

arbuliyerlu

It is best to write a view and query from the view.

忧伤蓝调

the first method:
Add a column to the DataSet, traverse, use the ID to retrieve the Name from the database, assign a value to the Name column of all rows, bind the Name column in the DataGrid, and hide the ID column.
The second method:
Make a view of the database, try two tables, and then retrieve the data (including Name) at a time, and then bind it as above.

摩羯可乐

You'd better combine the data in the database, and then display it in the DataGrid, and then hide the ID, that's it, the operations that can be done in the database are best done in the database

bjpapaya

Agree to combine in the database before taking it out

wxmzhht

Can views be used for two tables that are not in the same library? ? ? ?