在线等存储过程调用问题.有效马上结分.谢谢.

Question

想把存储过程查询到的结果存储到sqldatareader里应该怎样做?谢谢.
存储过程:
if exists(select * from  sysobjects where name='search')
drop proc search
gocreate proc search
select * from uload
go以下是部分代码接着应该怎样写?using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection("server=.uid=sa;pwd=sa;database=mytest");
        SqlCommand cmd = new SqlCommand("search", conn);//search为存储过程名称
         cmd.CommandType = CommandType.StoredProcedure;
        
    }
}

Answer 1

conn.open();
 SqlDataReader reader = cmd.ExecuteReader();
        while (reader.Read())
        {
            Console.WriteLine(String.Format("{0}", reader[0]));
        }
conn.close();

Answer 2

 protected void Button1_Click(object sender, EventArgs e) 
    { 
        SqlConnection conn = new SqlConnection("server=.uid=sa;pwd=sa;database=mytest"); 
        SqlCommand cmd = new SqlCommand("search", conn);//search为存储过程名称 
         cmd.CommandType = CommandType.StoredProcedure; 
        SqlDataReader dr= cmd.ExecuteReader();
        if (dr.Read())
                {
                    
                      //你要做什么                              }     } 

Answer 3

SqlDataReader dr= cmd.ExecuteReader();

Answer 4

public void DataGridBand(string tblName,string fldName,Wuqi.Webdiyer.AspNetPager aspnet,string fldSort,int Sort,string strCondition,string PrimaryKey,int Dist,System.Web.UI.WebControls.DataGrid datagrid)
{
tmCmd=new System.Data.SqlClient.SqlCommand("proc_paged_2part_selectMax",tmConn);
tmCmd.CommandType=System.Data.CommandType.StoredProcedure;
tmCmd.Parameters.Add("@tblName",tblName);   
tmCmd.Parameters.Add("@fldName",fldName); 
tmCmd.Parameters.Add("@pageSize",aspnet.PageSize);   
tmCmd.Parameters.Add("@page",aspnet.CurrentPageIndex); 
tmCmd.Parameters.Add("@fldSort",fldSort);   
tmCmd.Parameters.Add("@Sort",Sort); 
tmCmd.Parameters.Add("@strCondition",strCondition);   
tmCmd.Parameters.Add("@ID",PrimaryKey);   
tmCmd.Parameters.Add("@Dist",Dist); 
tmCmd.Parameters.Add("@pageCount",System.Data.SqlDbType.VarChar,100); 
tmCmd.Parameters["@pageCount"].Direction=System.Data.ParameterDirection.Output;
this.openConn(this.tmConn);
System.Data.SqlClient.SqlDataReader sdr= tmCmd.ExecuteReader();   
datagrid.DataSource= sdr;   
datagrid.DataBind(); 
datagrid.CssClass="edittable";
datagrid.ItemStyle.CssClass="datagridtextcenter";
datagrid.HeaderStyle.CssClass="fixedtitlerow";
datagrid.AlternatingItemStyle.CssClass="datagridalter";
this.tmConn.Close();
}