我的存储过程是
ALTER PROCEDURE abc @id int AS select 表名.*, aa AS Expr1, bb AS Expr1 from 表名 where ID=@idGrid 过程是
private void hh()
{ SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["Conn"]);
SqlDataAdapter1 = new SqlDataAdapter();
SqlDataAdapter1.SelectCommand=new SqlCommand("abc",SqlConnection1);
SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure ;
DataSet1=new DataSet();
try
{
SqlDataAdapter1.Fill(DataSet1,"表名");
}
catch
{
Response.Write("<script>alert('数据库操作错误!');</script>");
}
managerAuthority1.DataSource=DataSet1;
managerAuthority1.DataBind(); }从上一个页面传个来的ID值怎样应用到Grid控件中??????
ALTER PROCEDURE abc @id int AS select 表名.*, aa AS Expr1, bb AS Expr1 from 表名 where ID=@idGrid 过程是
private void hh()
{ SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["Conn"]);
SqlDataAdapter1 = new SqlDataAdapter();
SqlDataAdapter1.SelectCommand=new SqlCommand("abc",SqlConnection1);
SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure ;
DataSet1=new DataSet();
try
{
SqlDataAdapter1.Fill(DataSet1,"表名");
}
catch
{
Response.Write("<script>alert('数据库操作错误!');</script>");
}
managerAuthority1.DataSource=DataSet1;
managerAuthority1.DataBind(); }从上一个页面传个来的ID值怎样应用到Grid控件中??????
p1.value = your id value;
SqlDataAdapter1.SelectCommand.Parameters.Add(p1);
{SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["Conn"]);
SqlDataAdapter1 = new SqlDataAdapter();
SqlDataAdapter1.SelectCommand=new SqlCommand("abc",SqlConnection1);Parameter p1 = new Parameter("@id",DbType.Int)
p1.value = your id value;
SqlDataAdapter1.SelectCommand.Parameters.Add(p1);SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure ;
DataSet1=new DataSet();
try
{
SqlDataAdapter1.Fill(DataSet1,"表名");
}
catch
{
Response.Write("<script>alert('数据库操作错误!');</script>");
}
managerAuthority1.DataSource=DataSet1;
managerAuthority1.DataBind();}
C:\Inetpub\wwwroot\5o5k\Manager\AddManagerAuthority.aspx.cs(58): 找不到类型或命名空间名称“Parameter”(是否缺少 using 指令或程序集引用?)
C:\Inetpub\wwwroot\5o5k\Manager\AddManagerAuthority.aspx.cs(59): “System.Web.UI.HtmlControls.HtmlInputText”并不包含对“value”的定义
还有p1 就是个名字吧
{SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["Conn"]);
SqlDataAdapter1 = new SqlDataAdapter();
SqlDataAdapter1.SelectCommand=new SqlCommand("abc",SqlConnection1);SqlDataAdapter1.SelectCommand.Parameters.Clear();
SqlDataAdapter1.SelectCommand.Parameters.Add("@id",SqlDbTyep.int);
SqlDataAdapter1.SelectCommand.Parameters["@id"].value=Convert.Int32(this.Request.QueryString[0].ToString());
SqlDataAdapter1.SelectCommand.Parameters["@id"].Direction=ParameterDirection.InputOutput;SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure ;SqlDataAdapter1.SelectCommand.ExecuteNonQuery();DataSet1=new DataSet();
try
{
SqlDataAdapter1.Fill(DataSet1,"表名");
}
catch
{
Response.Write("<script>alert('数据库操作错误!');</script>");
}
managerAuthority1.DataSource=DataSet1;
managerAuthority1.DataBind();}