解决方案 »
- HTTP 权限问题,
- 郁闷了,刚刚装好了vs.net2003,出了这个问题大家帮忙看看
- vs2005 能否转换vs2003代码?
- 自定义的NameSpace在编译成Dll时遇到问题了...
- textbox的问题,我想实现一个调用text_changed的事件,还不想刷新画面。服务器端有数据库处理。急急急急!!!!!!!!!
- 如何得到一个xsl文件格式化一XML文件后的字符串呢
- datalist帮定问题,,简单的.
- 关于网站用户提款的问题
- 请问怎样列出aspx页所在文件夹的所有文件?
- 请教从asp到asp.net,需要学习什么?
- asp.net MVC 权限管理到没个按钮有什么好的方案
- 扫描枪扫描条形码问题 急求帮助
{
if (!IsPostBack)
{
DataSet ds = db.GetDataSet("Select * From [v_NewList] ");
if (ds != null)
{
DataTable dt=ds.Tables[0];
//最新资讯
rp_01.DataSource = setDataTable(dt.Columns, dt.Select("sid=1","OrderID DESC,FBDate DESC,id DESC"));
rp_01.DataBind();
//院校介绍
rp_02.DataSource = setDataTable(dt.Columns, dt.Select("sid=4", "OrderID DESC,FBDate DESC,id DESC"));
rp_02.DataBind();
//政策公告
rp_03.DataSource = setDataTable(dt.Columns, dt.Select("sid=2", "OrderID DESC,FBDate DESC,id DESC"));
rp_03.DataBind();
//招生简章
rp_04.DataSource = setDataTable(dt.Columns, dt.Select("sid=3", "OrderID DESC,FBDate DESC,id DESC"));
rp_04.DataBind();
//通知
rp_05.DataSource = setDataTable(dt.Columns, dt.Select("sid=18", "OrderID DESC,FBDate DESC,id DESC"));
rp_05.DataBind();
//留言
rp_06.DataSource = db.GetDataSet("Select top 6 * From gl_guestbook Where isCheck=1 Order by CreatTime DESC,id DESC");
rp_06.DataBind();
//院校博览
rp_07.DataSource = setDataTable(dt.Columns, dt.Select("sid=19", "OrderID DESC,FBDate DESC,id DESC"));
rp_07.DataBind();
//解题技巧
rp_08.DataSource = setDataTable(dt.Columns, dt.Select("sid=8", "OrderID DESC,FBDate DESC,id DESC"));
rp_08.DataBind();
//经验心得
rp_09.DataSource = setDataTable(dt.Columns, dt.Select("sid=9", "OrderID DESC,FBDate DESC,id DESC"));
rp_09.DataBind();
//高升专
rp_10.DataSource = setDataTable(dt.Columns, dt.Select("sid=5", "OrderID DESC,FBDate DESC,id DESC"));
rp_10.DataBind();
//高升本
rp_11.DataSource = setDataTable(dt.Columns, dt.Select("sid=6", "OrderID DESC,FBDate DESC,id DESC"));
rp_11.DataBind();
//专升本
rp_12.DataSource = setDataTable(dt.Columns, dt.Select("sid=7", "OrderID DESC,FBDate DESC,id DESC"));
rp_12.DataBind();
//毕业论文
rp_13.DataSource = setDataTable(dt.Columns, dt.Select("sid=10", "OrderID DESC,FBDate DESC,id DESC"));
rp_13.DataBind();
//学位英文
rp_14.DataSource = setDataTable(dt.Columns, dt.Select("sid=11", "OrderID DESC,FBDate DESC,id DESC"));
rp_14.DataBind();
//视频课件
rp_15.DataSource = setDataTable(dt.Columns, dt.Select("sid=12", "OrderID DESC,FBDate DESC,id DESC"));
rp_15.DataBind();
//招聘信息
rp_16.DataSource = setDataTable(dt.Columns, dt.Select("sid=13", "OrderID DESC,FBDate DESC,id DESC"));
rp_16.DataBind();
//求职技巧
rp_17.DataSource = setDataTable(dt.Columns, dt.Select("sid=14", "OrderID DESC,FBDate DESC,id DESC"));
rp_17.DataBind();
//研究生报才
rp_18.DataSource = setDataTable(dt.Columns, dt.Select("sid=15", "OrderID DESC,FBDate DESC,id DESC"));
rp_18.DataBind();
//出国留学
rp_19.DataSource = setDataTable(dt.Columns, dt.Select("sid=16", "OrderID DESC,FBDate DESC,id DESC"));
rp_19.DataBind();
//职业培训
rp_20.DataSource = setDataTable(dt.Columns, dt.Select("sid=17", "OrderID DESC,FBDate DESC,id DESC"));
rp_20.DataBind();
//毕业证书
rp_21.DataSource = setDataTable(dt.Columns, dt.Select("sid=20", "OrderID DESC,FBDate DESC,id DESC"));
rp_21.DataBind();
}
}
}
/// <summary>
/// 强型转换
/// </summary>
/// <param name="columns"></param>
/// <param name="rows"></param>
/// <returns></returns>
private DataTable setDataTable(DataColumnCollection columns,DataRow[] rows)
{
DataTable dt = new DataTable();
foreach (DataColumn col in columns)
{
DataColumn ncol = new DataColumn(col.ColumnName, col.DataType);
dt.Columns.Add(ncol);
}
foreach (DataRow row in rows)
{
dt.Rows.Add(row.ItemArray);
}
return dt;
}
就可以了啊
SELECT top 12 id,bid,[sid],kid,title,cast(infor as nvarchar(500)) as infor,url,hits,fbdate,link,Orderid From gl_NewsSystem Where isCheck=1 and sid=1 Order by isTop DESC,OrderID DESC,FBDate DESC,id DESC
UNION
SELECT top 5 id,bid,[sid],kid,title,cast(infor as nvarchar(500)) as infor,url,hits,fbdate,link,ORderid From gl_NewsSystem Where isCheck=1 and sid=4 Order by isTop DESC,OrderID DESC,FBDate DESC,id DESC
UNION
SELECT top 5 id,bid,[sid],kid,title,cast(infor as nvarchar(500)) as infor,url,hits,fbdate,link,ORderid From gl_NewsSystem Where isCheck=1 and sid=2 Order by isTop DESC,OrderID DESC,FBDate DESC,id DESC
UNION
SELECT top 5 id,bid,[sid],kid,title,cast(infor as nvarchar(500)) as infor,url,hits,fbdate,link,ORderid From gl_NewsSystem Where isCheck=1 and sid=3 Order by isTop DESC,OrderID DESC,FBDate DESC,id DESC
UNION
....
不过你的代码也是循环出来的,感觉rowfilter跟你的setDataTable方法效率也差不多吧?
嵌套用法
http://www.cnblogs.com/zmxmiss/archive/2009/02/26/1398635.html
http://tmouse.cnblogs.com/archive/2006/05/28/256274.html