SqlParameter Transactional Bulk Data insertion

Yes, good. Batch transaction submission at the rear although it's a bit of a hassle, it won't be a problem.

1 SqlCommand cmd;2Helpsqlserver helps =Newhelpsqlserver ();3         //Defining SqlParameter Arrays4sqlparameter[] param =Newsqlparameter[4];5 6 7         protected voidPage_Load (Objectsender, EventArgs e)8         {9             varstrSQL ="";Ten              for(inti =0; I <4; i++) One             { AstrSQL + ="INSERT INTO Questions (PID) Values"; -strSQL + ="(@PID"+ i +");"; -  theParam[i] =NewSqlParameter ("@PID"+ i +"", sqldbtype.uniqueidentifier); -Param[i]. Value =Guid.NewGuid (); -  -             } +  -             using(SqlConnection conn =NewSqlConnection (helpsqlserver.connectionstring)) +             { Acmd =NewSqlCommand (strSQL, conn); at  -  - Conn. Open (); -SqlTransaction transaction =Conn. BeginTransaction (); -  -Cmd. Transaction =transaction; in                 foreach(SqlParameter parainchparam) -                 { to cmd. Parameters.Add (para); +                 } -  the                 Try *                 { $ cmd. ExecuteNonQuery ();Panax Notoginseng transaction.commit (); -                 } the                 Catch +                 { A transaction. Rollback (); the                 } +             } -  $}

View Code

SqlParameter Transactional Bulk Data insertion