asp.net（存储过程）使用三种方法存取数据库记录（20070510）

**********asp.net中存储过程的应用***************
后台代码：
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace softweb.employee
{
 /// <summary>
 /// employee_add 的摘要说明。
 /// </summary>
 public class employee_add : System.Web.UI.Page
 {
  protected WFNetCtrl.Calendar Calendar1;
  protected System.Web.UI.WebControls.TextBox txtName;
  protected System.Web.UI.WebControls.RadioButton rdobtnNv;
  protected System.Web.UI.WebControls.TextBox txtUsername;
  protected System.Web.UI.WebControls.TextBox txtPwd;
  protected System.Web.UI.WebControls.TextBox txtPwd2;
  protected System.Web.UI.WebControls.Button btncancle;
  protected System.Web.UI.WebControls.Button btnAdd;
  protected System.Web.UI.WebControls.RadioButton rdobtnNan;
  protected System.Web.UI.WebControls.RadioButtonList rdobtnQx;
  protected System.Web.UI.WebControls.RequiredFieldValidator reqvldt_name;
  protected System.Web.UI.WebControls.RequiredFieldValidator reqvldt_user;
  protected System.Web.UI.WebControls.RequiredFieldValidator reqvldt_pwd;
  protected System.Web.UI.WebControls.RequiredFieldValidator reqvldt_pwd2;
     protected System.Data.SqlClient.SqlConnection myconn;
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
    myconn=new SqlConnection(Session["strConn"].ToString());
   
  }

  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.rdobtnNan.CheckedChanged += new System.EventHandler(this.rdobtnNan_CheckedChanged);
   this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion

  private void rdobtnNan_CheckedChanged(object sender, System.EventArgs e)
  {
  
  }

  private void btnAdd_Click(object sender, System.EventArgs e)
  {
  //1：***************添加数据库的一般方法******************
//   myconn.Open();
//   string employee_name=this.txtName.Text;
//   string sex="男";
//   string userName;
//   string quanxian;
//   try
//   {
//    SqlCommand cmd=new SqlCommand();
//    if(this.rdobtnNan.Checked)
//    {
//     this.rdobtnNv.Checked=false;
//     sex="男";
//    }
//    else if(this.rdobtnNv.Checked)
//    {
//     this.rdobtnNan.Checked=false;
//     sex="女";
//    }
//    userName=this.txtUsername.Text.ToString();
//    quanxian=this.rdobtnQx.SelectedValue.ToString();
//    cmd.Connection=myconn;
//    cmd.CommandText="insert into employee(employee_name,sex,user_name,quanxian)values('"+employee_name+"','"+sex+"','"+userName+"','"+quanxian+"')";
//    cmd.ExecuteNonQuery();
//    myconn.Close();
//   }
//   catch (Exception err)
//   {
//    this.RegisterStartupScript("add","<script>alert('"+err.Message.ToString()+"');</script>");
//   }
//   this.RegisterStartupScript("add","<script>alert('员工添加成功');</script>");

  //2：***************使用存储过程添加数据的方法**************

//   try
//   {
//    myconn.Open();
//    string employee_name=this.txtName.Text;
//    string sex="男";
//    if(this.rdobtnNan.Checked)
//    {
//     this.rdobtnNv.Checked=false;
//     sex="男";
//    }
//    else if(this.rdobtnNv.Checked)
//    {
//     this.rdobtnNan.Checked=false;
//     sex="女";
//    }
//   SqlCommand cmd=new SqlCommand();
//   cmd.CommandType=CommandType.StoredProcedure;
//   cmd.CommandText="employee_add";
//   cmd.Connection=myconn;
//   SqlParameter employeeName=new SqlParameter("@employee_name",SqlDbType.Char);
//   SqlParameter empSex=new SqlParameter("@sex",SqlDbType.Char);
//   SqlParameter empusername=new SqlParameter("@userName",SqlDbType.VarChar);
//   SqlParameter empquanxian=new SqlParameter("@quanxian",SqlDbType.VarChar);
//
//   employeeName.Value=employee_name.ToString();
//   empSex.Value=sex;
//   empusername.Value=this.txtUsername.Text.ToString();
//   empquanxian.Value=this.rdobtnQx.SelectedValue.ToString();
//
//   cmd.Parameters.Add(employeeName);
//   cmd.Parameters.Add(empSex);
//   cmd.Parameters.Add(empusername);
//   cmd.Parameters.Add(empquanxian);
//   cmd.ExecuteNonQuery();
//    myconn.Close();
//   }
//   catch (Exception err)
//   {
//    this.RegisterStartupScript("add","<script>alert('"+err.Message.ToString()+"');</script>");
//   }
//   this.RegisterStartupScript("add","<script>alert('员工添加成功');</script>");

  //3：*****************使用参数添加数据的方法******************

   try
   {
    myconn.Open();
    string employee_name=this.txtName.Text;
    string sex="男";
    
    SqlCommand cmd=new SqlCommand();
    cmd.Connection=myconn;
    cmd.CommandText="insert into employee(employee_name,sex,user_name,quanxian)values(@employee_name,@sex,@userName,@quanxian)";
    SqlParameter employeeName=new SqlParameter("@employee_name",SqlDbType.Char);
    SqlParameter empSex=new SqlParameter("@sex",SqlDbType.Char);
    SqlParameter empusername=new SqlParameter("@userName",SqlDbType.VarChar);
    SqlParameter empquanxian=new SqlParameter("@quanxian",SqlDbType.VarChar);
   
    employeeName.Value=employee_name.ToString();
    empSex.Value=sex;
    empusername.Value=this.txtUsername.Text.ToString();
    empquanxian.Value=this.rdobtnQx.SelectedValue.ToString();
   
    cmd.Parameters.Add(employeeName);
    cmd.Parameters.Add(empSex);
    cmd.Parameters.Add(empusername);
    cmd.Parameters.Add(empquanxian);
    cmd.ExecuteNonQuery();
    myconn.Close();
   }

   catch (Exception err)
   {
    this.RegisterStartupScript("add","<script>alert('"+err.Message.ToString()+"');</script>");
   }
   this.RegisterStartupScript("add","<script>alert('员工添加成功');</script>");

   
  }
 }
}
数据库的存储过程：
存储过程名为：employee_add
CREATE PROCEDURE employee_add
(@employee_name char(20),@sex  char(2),@userName varchar(50),@quanxian varchar(50))
 AS
insert into employee(employee_name,sex,user_name,quanxian)values(@employee_name,@sex,@userName,@quanxian)
GO