一个存储过程,多个select语句,形成多个表读取数据
一个存储过程,多个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_("News_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();
}
存储过程如下:
ALTER PROCEDURE [dbo].[News_default]
AS
select top 2 * from News_commend where mark=1
select top 6 [name],topicid,title,pic,intro from News_topic,News_board where pic<>'' and News_topic.boardid=News_board.boardid and hidden=0 order by topicid desc
select top 40 [name],News_topic.topicid as topicid,title,newchapter,author,updatetime from News_topic,News_board where News_topic.boardid=News_board.boardid and hidden=0 order by updatetime desc
select topicid,title,amount into #order_day from News_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 News_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 News_topic order by hits desc
select top 16 topicid,title from News_commend where mark=0 order by commendid desc
select top 16 topicid,title from News_topic order by commend desc
select top 16 topicid,title from News_topic where hidden=0 order by addtime desc
出自：http://hi.baidu.com/n_g_p/blog/item/e78e916dc7f1f1ff43169414.html
