存储过程在WEB 中调用.doc

统一数据库连接字符串的产生 创建网站 如果网站中没有出现WEB.config, 添加WEB.config 在Default.aspx中通过拖放方式生成数据浏览页面 回到WEB.config中找到connectionStrings节点 (这是自动产生连接字符串XMConnectionString;注意不同的数据库将来的连接字符串名是不同的,应该到WEB.config中去找name 属性的值就是具体的连接字符串名. ) 无参数查询事件 头文件：using System.Data.SqlClient; using System.Configuration; if(!IsPostBack) { SqlConnection conn=new SqlConnection(ConfigurationManager.ConnectionStrings[“XSConnectionString”].ToString()); SqlDataAdapter da = new SqlDataAdapter(); conn.Open(); da.SelectCommand = new SqlCommand(); da.SelectCommand.Connection = conn; da.SelectCommand.CommandText = pro_select_all; da.SelectCommand.CommandType = CommandType.StoredProcedure; GridView1.DataSource=da.SelectCommand.ExecuteReader(); GridView1.DataBind (); conn.Close(); } 带参数查询 头文件：using System.Data.SqlClient; using System.Configuration; SqlConnection conn=new SqlConnection conn=new SqlConnection(ConfigurationManager.ConnectionStrings[XSConnectionString].ToString()); SqlDataAdapter da = new SqlDataAdapter(); conn.Open(); da.SelectCommand = new SqlCommand(); da.SelectCommand.Connection = conn; da.SelectCommand.CommandText = pro_select_jx2; da.SelectCommand.Parameters.Add(@jx_id, SqlDbType.Int).Value = int.Parse(TextBox1.Text); da.SelectCommand.CommandType = CommandType.StoredProcedure; GridView1.DataSource=da.SelectCommand.ExecuteReader(); GridView1.DataBind (); conn.Close(); 插入 头文件：using System.Data.SqlClient; using System.Configuration; SqlConnection conn=new SqlConnection(ConfigurationManager.ConnectionStrings[“XSConnectionString”].ToString()); conn.Open(); SqlCommand thisCommand = conn.CreateCommand(); thisCommand.Connection = conn; thisCommand.CommandText = proc_insert_zy; thisCommand.Parameters.Add(@zy_id, SqlDbType.Int).Value = int.Parse(TextBox1.Text); thisCommand.Parameters.Add(@zy_name, SqlDbTy