Help bind the database in the GridView and update it?

水蓝的牧师

The database that I bind in the GridView has 3 tables, and the relationship between the 3 tables is as follows:
的 The fields in student include student number, name, class number, and professional number;
The fields in the table class include class and class number;
The fields in the table zhuanye have professional, professional number;
However, the columns I bind in the GridView are: student number name class professional
Now I want to update records in the GridView, how should I write the update statement?

bigwolf

Will it be updated after rebinding?

plow0083

Re-execute the query and bind it to the control. In fact, it is the repeated execution of this piece of code

nickylsy041

Update three tables at the same time

littlelyz

If the data has changed, refresh the page again, that is, rebind

readmanhjn

Update three tables, or write a stored procedure

haohaizi

You can re-bind after updating the three tables at the same time

ysangel

Then you can first create a view on the three tables in the database, and then use this newly created view as a table.