我的存储过程
ALTER PROCEDURE abc @aa Nchar(50),@bb nchar(50) As Update 表名 set aa=@aa,bb=@bb where aa=@aa下拉列表ID 为HH aa的值是从上个页面传过来的
SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["Conn"]);
SqlCommand1=new SqlCommand("abc",SqlConnection1);
SqlCommand1.CommandType = CommandType.StoredProcedure;
SqlCommand1.Parameters.Add(new SqlParameter("@aa",SqlDbType.NVarChar,50));
SqlCommand1.Parameters["@aa"].Value = Request["aa"];
SqlCommand1.Parameters.Add(new SqlParameter("@bb",SqlDbType.NVarChar,50));
SqlCommand1.Parameters["@bb"].Value = HH.selecteditem.Value.Trim();
SqlCommand1.ExecuteNonQuery();如何把HH下拉列表的值更新到表里?
以上是我自己写的 但有问题 请高手帮我改一改
ALTER PROCEDURE abc @aa Nchar(50),@bb nchar(50) As Update 表名 set aa=@aa,bb=@bb where aa=@aa下拉列表ID 为HH aa的值是从上个页面传过来的
SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["Conn"]);
SqlCommand1=new SqlCommand("abc",SqlConnection1);
SqlCommand1.CommandType = CommandType.StoredProcedure;
SqlCommand1.Parameters.Add(new SqlParameter("@aa",SqlDbType.NVarChar,50));
SqlCommand1.Parameters["@aa"].Value = Request["aa"];
SqlCommand1.Parameters.Add(new SqlParameter("@bb",SqlDbType.NVarChar,50));
SqlCommand1.Parameters["@bb"].Value = HH.selecteditem.Value.Trim();
SqlCommand1.ExecuteNonQuery();如何把HH下拉列表的值更新到表里?
以上是我自己写的 但有问题 请高手帮我改一改
SqlCommand1=new SqlCommand("abc",SqlConnection1);
SqlCommand1.CommandType = CommandType.StoredProcedure;
SqlCommand1.Parameters.Add(new SqlParameter("@aa",SqlDbType.NVarChar,50));
SqlCommand1.Parameters["@aa"].Value = Request["aa"].Tostring(); //////////
SqlCommand1.Parameters.Add(new SqlParameter("@bb",SqlDbType.NVarChar,50));
SqlCommand1.Parameters["@bb"].Value = HH.selecteditem.Value.Trim().Tostring(); //////
SqlConnection1.open(); ////////////
SqlCommand1.ExecuteNonQuery();