Perform multiple operations on the database using C # Transaction Processing

There are three database operation statements a B C, and multiple operations are performed using C # transaction processing. If any statement has a problem, all statements are not executed.

 

 

C # code

Sqlcommand sqlcmd = new sqlcommand ();
Sqlcmd. Connection = sqlcnn;
Sqlcmd. Transaction = sqlcnn. begintransaction (); // complete the preparatory work for transaction processing.

try
{
// write user-registered data to the database
string sqlcmd1 = "insert into user_login (user_id, user_pwd) values ('"+ user_id +"', '"+ user_pwd +"') ";
string sqlcmd2 =" insert into user_data_basic values ('"+ user_id + "', '"+ user_name +"', '"+ user_sex +"', "+ user_age_year +", "+ user_age_month +", "+ user_age_day + ",'','', '','', '')";
string sqlcmd3 = "insert into user_data_comunication (user_id) values ('" + user_id + "')";
string sql1_4 = "insert into user_data_like (user_id) values ('" + user_id + "')";
string sql1_5 = "insert into user_data_schooldata (user_id) values ('"+ user_id +"') ";
// string sql1_6 =" insert into user_data_status (user_id, user_status_date) values ('"+ user_id + "', '"+ system. datetime. now + "')";

string [] sqlstringlist = {sqlcmd1, sqlcmd2, sqlcmd3, sql1_4, sql1_5};
for (INT I = 0; I {< br> string sqlstr = sqlstringlist [I]. tostring ();
If (sqlstr. trim (). length> 1)
{< br> sqlcmd. commandtext = sqlstr;
sqlcmd. executenonquery ();
}< BR >}< br> sqlcmd. transaction. commit ();
}< br> catch (exception exe)
{< br> sqlcmd. transaction. rollback ();
flag = false;
// This. finalcheck. TEXT = exe. message. tostring ();
}< br> finally
{< br> // close the database
sqlcnn. close ();
}