在.NET中调用存储过程

今天试了一下用存储过程取得数据。归纳方法如下：

1.用SqlCommand和DataSet:

SqlConnection conn=new SqlConnection("server=(local);uid=;password=;database=");

SqlCommand cmd=new SqlCommand("StoreProcedure",connn);

cmd.CommandType=CommandType.StoreProcedure;

SqlDataAdapter dsCommand=new SqlDataAdapter(cmd);

DataSet ds=new DataSet();

dsCommand.Fill(ds);

2.用SqlCommand和SqlDataAdapter

Sqlconnection conn=new SqlConnection("server=(local);uid=;password=;database=");

SqlCommand cmd=new SqlCommand("StoreProcedure",conn);

cmd.CommandType=CommandType.StoreProcedure;

SqlDataReader dr=cmd.ExecuteReader()

while(dr.Read())

{

Response.Write(dr.Item["Field"]);

}