一个存储过程,多个select语句,形成多个表读取数据

     public   static  DataSet SqlNormal_( string  storename)
     {
        DataSet dataset = new DataSet();
        SqlConnection SqlConn = new SqlConnection(connection);
        SqlConn.Open();
        SqlCommand comm = new SqlCommand(storename, SqlConn);
        comm.CommandType = System.Data.CommandType.StoredProcedure;
        SqlDataAdapter data = new SqlDataAdapter(comm);
        data.Fill(dataset);
        data.Dispose();
        comm.Dispose();
        SqlConn.Close();
        return dataset;
    }

     protected   void  Page_Load( object  sender, EventArgs e)
     {
        DataSet dataset = SqlStore.SqlNormal_("novel_default");
        this.List_Very.DataSource = dataset.Tables[0];
        this.List_Very.DataBind();
        this.List_News.DataSource = dataset.Tables[1];
        this.List_News.DataBind();
        this.List_Update.DataSource = dataset.Tables[2];
        this.List_Update.DataBind();
        this.List_Day.DataSource = dataset.Tables[22];
        this.List_Day.DataBind();
        this.List_Week.DataSource = dataset.Tables[4];
        this.List_Week.DataBind();
        this.List_All.DataSource = dataset.Tables[5];
        this.List_All.DataBind();
        this.List_Commend1.DataSource = dataset.Tables[6];
        this.List_Commend1.DataBind();
        this.List_Commend2.DataSource = dataset.Tables[7];
        this.List_Commend2.DataBind();
        this.List_NewsBook.DataSource = dataset.Tables[8];
        this.List_NewsBook.DataBind();
    }

sql

ALTER   PROCEDURE   [ dbo ] . [ novel_default ]
AS
     select   top   2   *   from  novel_commend  where  mark = 1
     select   top   6   [ name ] ,topicid,title,pic,intro  from  novel_topic,novel_board  where  pic <> ''   and  novel_topic.boardid = novel_board.boardid  and  hidden = 0   order   by  topicid  desc
     select   top   40   [ name ] ,novel_topic.topicid  as  topicid,title,newchapter,author,updatetime  from  novel_topic,novel_board  where  novel_topic.boardid = novel_board.boardid  and  hidden = 0   order   by  updatetime  desc
     select  topicid,title,amount  into  #order_day  from  novel_order  where   datediff ( day ,  dateadd ( day ,  - 1 ,  getdate ()), times) >= 0
     select   top   19  topicid,title, sum (amount)  as  amount  from  #order_day  group   by  topicid,title  order   by   sum (amount)  desc
     select  topicid,title,amount  into  #order_week  from  novel_order   where   datediff ( day ,  dateadd ( day ,  - 7 ,  getdate ()), times) >= 0
     select   top   19  topicid,title, sum (amount)  as  amount  from  #order_week  group   by  topicid,title  order   by   sum (amount)  desc
     select   top   20   topicid,title,hits  from  novel_topic  order   by  hits  desc
     select   top   16  topicid,title  from  novel_commend  where  mark = 0   order   by  commendid  desc
     select   top   16  topicid,title  from  novel_topic  order   by  commend  desc
     select   top   16  topicid,title  from  novel_topic  where  hidden = 0   order   by  addtime  desc

转载于:https://www.cnblogs.com/zwl12549/archive/2007/07/11/814138.html