存储过程 两种方法的实例

   1: protected void btnSend_Click(object sender, EventArgs e)

   2: {

   3:     int temp = -1;

   4:     int exhibitionID = int.Parse(Request.QueryString["ConList"]);

   5:     int exhibitorType = 0;

   6:     

   7:     int mCustomerID = 0;

   8:     if (Session["UserID"] != null)

   9:     {

  10:         ViewState["CID"] = myShare.GetAObject(true, 1, "CustomerID", "Customers", "UserID=‘" + Session["UserID"].ToString() + "‘").ToString();

  11:         if (!string.IsNullOrEmpty(ViewState["CID"].ToString()))

  12:         {

  13:             mCustomerID = Convert.ToInt32(ViewState["CID"].ToString());

  14:         }

  15:     }

  16:     string company = this.txtCompay.Text.Trim();

  17:     string name = this.txtName.Text;

  18:     string tel = this.txtTel.Text;

  19:     string email = this.txtEmail.Text;

  20:  

  21:     SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);

  22:  

  23:     SqlCommand com = new SqlCommand("ExpoApply", con);

  24:     com.CommandType = CommandType.StoredProcedure;

  25:  

  26:     SqlParameter parCustomerID = new SqlParameter("@CustomerID", SqlDbType.Int);

  27:     parCustomerID.Value = mCustomerID;

  28:     com.Parameters.Add(parCustomerID);

  29:  

  30:     SqlParameter parCompanyName = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 100);

  31:     parCompanyName.Value = company;

  32:     com.Parameters.Add(parCompanyName);

  33:  

  34:     SqlParameter parContact = new SqlParameter("@Contact", SqlDbType.VarChar, 50);

  35:     parContact.Value = name;

  36:     com.Parameters.Add(parContact);

  37:  

  38:     SqlParameter parEmail = new SqlParameter("@Email", SqlDbType.VarChar, 50);

  39:     parEmail.Value = email;

  40:     com.Parameters.Add(parEmail);

  41:  

  42:  

  43:     SqlParameter parReturnValue = new SqlParameter("@ReturnValue", SqlDbType.Int);

  44:     parReturnValue.Direction = ParameterDirection.Output;

  45:     com.Parameters.Add(parReturnValue);

  46:  

  47:     try

  48:     {

  49:         con.Open();

  50:         com.ExecuteNonQuery();

  51:  

  52:         temp = int.Parse(com.Parameters["@ReturnValue"].Value.ToString());

  53:  

  54:         if (temp == -1)

  55:         {

  56:             myShare.WebMessageBox(this.Page, "信息发布时出错，请重试！");

  57:         }

  58:         else if (temp == 0)

  59:         {

  60:             myShare.WebMessageBox(this.Page, "信息发布失败，请重试！");

  61:         }

  62:         else

  63:         {

  64:             ClientScript.RegisterStartupScript(ClientScript.GetType(), "提示", "<script>alert(‘信息发布成功！‘);window.location=‘DiscountExpoList.aspx‘</script>");

  65:         }

  66:  

  67:     }

  68:     catch (Exception ex)

  69:     {

  70:         Response.Write(ex.Message);

  71:     }

  72:  

  73: }

  74:  

   1: SqlConnection con = null;

   2: try

   3: {

   4:     con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);

   5:     SqlCommand com = new SqlCommand();

   6:     com.Connection = con;

   7:     com.CommandType = CommandType.StoredProcedure;

   8:     com.CommandText = "ExpoApply";

   9:     con.Open();

  10:     SqlParameter[] sp = 

  11:      {

  12:          new SqlParameter("@CustomerID",SqlDbType.Int)

  13:          ,new SqlParameter("@CompanyName",SqlDbType.NVarChar,100)

  14:          ,new SqlParameter("@Contact",SqlDbType.VarChar,50)

  15:          ,new SqlParameter("@Email",SqlDbType.VarChar,50)

  16:          //...   

  17:          ,new SqlParameter("@ReturnValue",SqlDbType.Int)

  18:  

  19:       };

  20:     sp[0].Value = mCustomerID;

  21:     sp[1].Value = company;

  22:     sp[2].Value = name;

  23:     sp[3].Value = email;

  24:     //  ...

  25:     sp[16].Direction = ParameterDirection.Output;

  26:     com.Parameters.AddRange(sp);

  27:     com.ExecuteNonQuery();

  28:     temp = Convert.ToInt32(com.Parameters["@ReturnValue"].Value);

  29:     con.Close();

  30: }

  31:  

  32: catch (SqlException se)

  33: {

  34: }

  35: finally

  36: {

  37:     con.Close();

  38: }

  39:  

  40: if (temp == -1)

  41: {

  42:     myShare.WebMessageBox(this.Page, "信息发布时出错，请重试！");

  43: }

  44: else if (temp == 0)

  45: {

  46:     myShare.WebMessageBox(this.Page, "信息发布失败，请重试！");

  47: }

  48: else

  49: {

  50:     ClientScript.RegisterStartupScript(ClientScript.GetType(), "提示", "<script>alert(‘信息发布成功！‘);window.location=‘DiscountExpoList.aspx‘</script>");

  51: }