**********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