1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12public partial class ExcuteProcParm : System.Web.UI.Page
13...{
14    protected void Page_Load(object sender, EventArgs e)
15    ...{
16
17    }
18    protected void Button1_Click(object sender, EventArgs e)
19    ...{
20        //初始化参数
21        SqlParameter myparm = new SqlParameter();
22        //获取参数的名字
23        myparm.ParameterName = txtparm.Text;
24        //设置变量的类型和长度
25        myparm.SqlDbType = SqlDbType.NVarChar;
26        myparm.Size = 20;
27        //获取参数的值
28        myparm.Value = txtvalue.Text;
29        //获取要执行的存储过程名
30        string sqlexec = txtsqlexec.Text;
31        SqlCommand cmd = new SqlCommand();
32        //定义对象资源保存的范围，一旦using范围结束，将释放对方所占的资源
33        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
34        ...{
35            //打开连接
36            conn.Open();
37            //调用执行方法
38            SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, sqlexec, myparm);
39            Response.Write("<font color=red>操作完成！请检查数据库！</font>");
40        }
41    }
42}
43