There are generally two methods of calling:
First, the Add method
SqlParameter sp = new SqlParameter ("@name", "pudding"); cmd. Parameters.Add (sp); sp = new SqlParameter ("@ID", "1"); cmd. Parameters.Add (SP);
This method can only add one SqlParameter at a time. The function of the above code is to update the field name with the ID value equal to 1 to pudding (person name).
Second, AddRange method
Sqlparameter[] paras = new sqlparameter[] {new SqlParameter ("@name", "pudding"), New SqlParameter ("@ID", "1")};cmd. Parameters.addrange (paras);
using(SqlConnection connection =NewSqlConnection (frmmain.strconnection)) { if(TxtModel.Text.Trim () = =NULL) {MessageBox.Show ("model cannot be empty, please re-fill"); } Else{connection. Open (); SqlCommand Command=NewSqlCommand (strcmd, connection); Sqlparameter[] Spara=Newsqlparameter[] {NewSqlParameter ("@Model", TxtModel.Text.Trim ()),NewSqlParameter ("@GsmTest", Intgsmflag.tostring ()),NewSqlParameter ("@TdTest", Inttdflag.tostring ()),NewSqlParameter ("@WcdmaTest", Intwcdmaflag.tostring ()),NewSqlParameter ("@LteTest", Intlteflag.tostring ()),NewSqlParameter ("@LteFddTest", Intltefddflag.tostring ()),NewSqlParameter ("@CdmaTest", Intcdmaflag.tostring ()),NewSqlParameter ("@count", Intcount.tostring ())}; Command. Parameters.addrange (Spara); if(command.) ExecuteNonQuery () >0) {MessageBox.Show ("The data has been updated! "); } Else{MessageBox.Show ("Data update failed! "); return ; } } }
Use of SqlParameter