strsql = "select top 5 File_name_cn,Doc_name_cn,Doc_path,Doc_dissertation from docnews where Top_id ="+Top_id+" order by Doc_while desc ";
strsql+="select top 5 File_name_cn,Doc_name_cn,Doc_path,Doc_dissertation from docnews where Top_id =4 order by Doc_while desc ";
strsql+="select top 5 File_name_cn,Doc_name_cn,Doc_path,M_type from GWPmeeting order by Doc_while desc ";
strsql+="select top 5 File_name_cn,Doc_name_cn,Doc_path,Doc_dissertation from docnews where Top_id =5 order by Doc_while desc ";
strsql+="select top 5 File_name_cn,Doc_name_cn,Doc_path,Doc_dissertation from docnews where Top_id =6 order by Doc_while desc ";
strsql+="select top 5 File_name_cn,Doc_name_cn,Doc_path,Doc_dissertation from docnews where Top_id =7 order by Doc_while desc ";
DataSet ds = new DataSet();
ds = cb.GetDataSet(strsql);//就是一个dataset这是我写的返回一个dataset的代码,你可以不用管写自己的代码。
dt = ds.Tables[0];//新闻动态
foreach(DataRow dr in dt.Rows)
{
if(dr[3].ToString().Trim() =="N")
{
strtx = dr[0].ToString().Trim();
}
else
{
strtx = "[专题] "+dr[0].ToString().Trim();
}
HyperLink hlc = new HyperLink();
hlc.Text = ""+"· "+"<A class="+"body"+" href="+"GWPNews/GWPSigleNews.aspx?id="+ dr[2].ToString().Trim()+"\\"+dr[1].ToString().Trim() +" target=\"_blank\""+">" + strtx +"</A>"+"<br>";
this.TD1.Controls.Add(hlc);
}
dt = ds.Tables[1];//活动
foreach(DataRow dr in dt.Rows)
{
if(dr[3].ToString().Trim() =="N")
{
strtx = dr[0].ToString().Trim();
}
else
{
strtx = "[专题] "+dr[0].ToString().Trim();
}
HyperLink hlc = new HyperLink();
hlc.Text = ""+"· "+"<A class="+"body"+" href="+"GWPActive/GWPSigleActive.aspx?id="+ dr[2].ToString().Trim()+"\\"+dr[1].ToString().Trim() +" target=\"_blank\""+">" + strtx +"</A>"+"<br>";
this.Td2.Controls.Add(hlc);
}
.
.
.
.
SqlDataAdapter da = new SqlDataAdapter ();
SqlConnection cnn = new SqlConnection();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = cnn;
da.SelectCommand.CommandText = "SELECT * FROM TableA; SELECT * FROM TableB";