推荐订阅源

在SQL中建立的存储过程

CREATE PROCEDURE find
(@strName int)
 AS
select @strName=rtrim(@strName)
select * from khxxb
where (KHLXZ=@strName)
return
GO

在ASP.NET中的调用:
SqlConnection myconn = new SqlConnection((string)Application["Connstr"]);
   
   SqlCommand mycomm = new SqlCommand();
   SqlParameter Param=new SqlParameter("@strName",SqlDbType.Int);
   Param.Value="1";
   mycomm.Connection=myconn;
   mycomm.CommandType=CommandType.StoredProcedure;
   mycomm.CommandText="find";
   mycomm.Parameters.Add(Param);

   myconn.Open();

   DataSet ds = new DataSet();
   SqlDataAdapter da = new SqlDataAdapter(mycomm);
   da.Fill(ds);
   this.DataGrid1.DataSource = ds;
   this.DataGrid1.DataBind();