本文整理汇总了C#中Database类的典型用法代码示例。如果您正苦于以下问题:C#Database类的具体用法?C#Database怎么用?C#Database使用的例子?这里精选的类代码示例或许可以为您提供帮助。
示例1:Page_Load
protectedvoidPage_Load(objectsender,EventArgse)
{
if(!Page.IsPostBack)
{
intid;
if(!int.TryParse(Request.QueryString["id"],outid))
{
Response.Redirect("~/MediaCenter.aspx");
}
Databasedb=newDatabase();
Langlang=newLang();
db.AddParameter("@lang",lang.getCurrentLang());
db.AddParameter("@id",id);
DataTabledt=db.ExecuteDataTable("selecttop(3)*fromReportwhere[emailprotected]and(not[emailprotected])Orderbyiddesc");
Repeater1.DataSource=dt;
Repeater1.DataBind();
db.AddParameter("@lang",lang.getCurrentLang());
dt=db.ExecuteDataTable("selecttop(3)*fromSocialEventwhere[emailprotected]Orderbyiddesc");
Repeater2.DataSource=dt;
Repeater2.DataBind();
db.AddParameter("@lang",lang.getCurrentLang());
db.AddParameter("@id",id);
dt=db.ExecuteDataTable("select*fromReportwhere[emailprotected]and[emailprotected]");
Repeater3.DataSource=dt;
Repeater3.DataBind();
if(dt.Rows.Count==0)
{
Response.Redirect("~/MediaCenter.aspx");
}
}
}
原文链接:
http://www.jxszl.com/biancheng/C/556847.html