返回首页

如何在C#中使用MySQL的存储过程时,通过where条件的id

存储过程:

drop procedure if exists Update_MT_data;
{C}类别:

public int UpdateMTdata(string Accountname, string Transfilename, string Filename, DateTime dateofdictation, string Lastname, string Firstname, string Middlename, string Dateofservice, string dateofadmission, string MRNO, string Physician, string Remarks, string PatientID, string RPhysician, string dateofbirth, string worktype, string ccphy, string ccphyinvalid, string dictateddatesdifferent)

       {

           MySqlConnection con = new MySqlConnection("SERVER=192.168.0.10;DATABASE=anju2;UID=heman;PASSWORD=harjeet;");

           AddEditor aedit = new AddEditor();

 

           try

           {

 

               con.Open();

 

               MySqlCommand command = new MySqlCommand("Update_MT_data", con);

               command.CommandType = CommandType.StoredProcedure;

               command.Parameters.Add(new MySqlParameter("?Accountname", MySql.Data.MySqlClient.MySqlDbType.VarChar, 200));

               command.Parameters.Add(new MySqlParameter("?Transfilename", MySql.Data.MySqlClient.MySqlDbType.VarChar, 200));

               command.Parameters.Add(new MySqlParameter("?Filename", MySql.Data.MySqlClient.MySqlDbType.VarChar, 200));

                                        

               command.Parameters.Add(new MySqlParameter("?dateofdictation", MySql.Data.MySqlClient.MySqlDbType.Date));

               

               command.Parameters.Add(new MySqlParameter("?Lastname", MySql.Data.MySqlClient.MySqlDbType.VarChar, 200));

               command.Parameters.Add(new MySqlParameter("?Firstname", MySql.Data.MySqlClient.MySqlDbType.VarChar, 200));

               command.Parameters.Add(new MySqlParameter("?Middlename", MySql.Data.MySqlClient.MySqlDbType.VarChar, 250));

               command.Parameters.Add(new MySqlParameter("?Dateofservice", MySql.Data.MySqlClient.MySqlDbType.VarChar, 200));

               command.Parameters.Add(new MySqlParameter("?dateofadmission", MySql.Data.MySqlClient.MySqlDbType.VarChar, 200));

               

              

               command.Parameters.Add(new MySqlParameter("?MRNO", MySql.Data.MySqlClient.MySqlDbType.VarChar, 200));

                            

               command.Parameters.Add(new MySqlParameter("?Physician", MySql.Data.MySqlClient.MySqlDbType.VarChar, 250));

               command.Parameters.Add(new MySqlParameter("?Remarks", MySql.Data.MySqlClient.MySqlDbType.VarChar, 250));

               command.Parameters.Add(new MySqlParameter("?PatientID", MySql.Data.MySqlClient.MySqlDbType.VarChar, 250));

             

               command.Parameters.Add(new MySqlParameter("?RPhysician", MySql.Data.MySqlClient.MySqlDbType.VarChar, 250));

               command.Parameters.Add(new MySqlParameter("?dateofbirth", MySql.Data.MySqlClient.MySqlDbType.VarChar, 255));

               command.Parameters.Add(new MySqlParameter("?worktype", MySql.Data.MySqlClient.MySqlDbType.VarChar, 250));

               

               command.Parameters.Add(new MySqlParameter("?ccphy", MySql.Data.MySqlClient.MySqlDbType.VarChar, 1000));

               command.Parameters.Add(new MySqlParameter("?ccphyinvalid", MySql.Data.MySqlClient.MySqlDbType.VarChar, 1000));

              

               command.Parameters.Add(new MySqlParameter("?dictateddatesdifferent", MySql.Data.MySqlClient.MySqlDbType.VarChar, 200));

               

               

 



 

               command.Parameters[0].Value = Accountname;

               command.Parameters[1].Value = Transfilename;

               command.Parameters[2].Value = Filename;

               command.Parameters[3].Value = dateofdictation;

               command.Parameters[4].Value = Lastname;

               command.Parameters[5].Value = Firstname;

               command.Parameters[6].Value = Middlename;

               command.Parameters[7].Value = Dateofservice;

               command.Parameters[8].Value = dateofadmission;

               command.Parameters[9].Value = MRNO;

               command.Parameters[10].Value = Physician;

               command.Parameters[11].Value = Remarks;

               command.Parameters[12].Value = PatientID;

               command.Parameters[13].Value = RPhysician;

               command.Parameters[14].Value = dateofbirth;

               command.Parameters[15].Value = worktype;

               command.Parameters[16].Value = ccphy;

               command.Parameters[17].Value = ccphyinvalid;

               command.Parameters[18].Value = dictateddatesdifferent;

              

 



               //command.ExecuteNonQuery(); 



               int updatestr = (Int32)command.ExecuteScalar();

 

               con.Close();

               return updatestr;

 



           }

           catch (Exception ex)

           {

               string str = ex.ToString();

               return 0;

               

           }

           finally

           {

               con.Close();

           }

       }

 

后面的代码:
{体C3}
编辑:代码格式化 :

回答

评论会员: 时间:2