c# winform 修改，update语句,CRUD

/// <summary>
   /// 更新车中商品
   /// </summary>
   /// <param name="charid"></param>
   /// <param name="bookid"></param>
   /// <param name="num"></param>
   /// <returns></returns>
   public static int updatecar(string charid,string bookid,int num)
   {
    int i=0;
    try
    {
     con = Driver.dricon();

     com = new SqlCommand("bookup",con);

     com.Parameters.Add("@CardID",charid);
     com.Parameters.Add("@bookid",bookid);
     com.Parameters.Add("@Quantity",num);
     com.CommandType = CommandType.StoredProcedure;


     i=com.ExecuteNonQuery();
    }
    catch(Exception ce)
    {
     ce.ToString();
    }
    finally
    {
     com.Dispose();
     con.Close();
    }
    return i;
   }

 

黑色头发  http://heisetoufa.iteye.com