Ask for help about database update `` ''

水蓝的牧师

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?

shenmue024

Do you want to update three tables?

4319231

Two update statements, written in a transaction

4319231

I'm still writing programs during the holidays

水蓝的牧师

Yes
Otherwise it will have type conversion errors

shenmue024

Update three tables, can only write three sql. Put in the transaction.

Note that the associated fields must be retrieved.

水蓝的牧师

Can you write it for me?
I haven't written 3 in one transaction.

疾风劲草

// establish a connection
            SqlConnection con = new SqlConnection ("server = .; database = student; uid = sa; pwd = 0421");
            // define a transaction
            SqlTransaction transaction = null;

            try
            {
                // Open the database connection
                con.Open ();
                // start transaction
                transaction = con.BeginTransaction ();
                // Insert command
                SqlCommand cmd1 = new SqlCommand ("insert into student values ​​('111', 'liujia')", con);
                SqlCommand cmd2 = new SqlCommand ("insert into class values ​​('111', 'liujia')", con);
                //carried out
                cmd1.ExecuteNonQuery ();
                cmd2.ExecuteNonQuery ();

                // Other operations, such as update
                // ........

                // All operations are completed, submit
                transaction.Commit ();
            }
            catch (Exception ex)
            {
                // roll back first
                transaction.Rollback ();
                // Exception handling below
                // ...
            }
            finally
            {
                // Close the database connection
                con.Close ();
            }
           
        }

水蓝的牧师

I am updating the database
The Update statement is used, so how to deal with the same fields of several tables?