public void Bind4() { string sql = "select top 5 * from [Plan] where username='******' order by planid desc"; this.DataList4.DataSource = OperateDB.ExecuteDataSet(sql); this.DataList4.DataBind(); }
public void Bind3() { string sql = "select top 5 * from News order by NewsID desc"; DataList3.DataSource = OperateDB.ExecuteDataSet(sql); DataList3.DataBind(); }
private void bind2() { string Name = SelectName(); string sql = "select top 5 title,sid,Pubdate from Email where Meetname='" + Name + "' order by sid desc "; this.DataList2.DataSource = OperateDB.ExecuteDataSet(sql); this.DataList2.DataBind(); }
private void bing1() { string UserName = Session["UserName"].ToString(); string sql = "select id from UserInfo where UserName='******'"; int id = Convert.ToInt32(OperateDB.getExecuteScalar(sql)); string sql1 = "select top 5 * from Calendar where id=" + id + " order by CalendarID desc"; DataSet ds = OperateDB.ExecuteDataSet(sql1); this.DataList1.DataSource = ds.Tables[0]; this.DataList1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { string num = getemailnum(getname()); if (num != "0") { this.emailcount.InnerText = num; this.title.InnerHtml = "You have " + num + " Mails"; string sql = "select * from Email where Meetname='" + getname() + "' and Status = '未读'"; this.dl.DataSource = OperateDB.ExecuteDataSet(sql); dl.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!OA.Administrator.admin.isadmin(Session["UserName"].ToString())) { Response.Write("<script>alert('你没有权限');window.opener=null;window.close();</script>"); } else { string num = getemailnum(getname()); if (num != "0") { this.emailcount.InnerText = num; this.title.InnerHtml = "You have " + num + " Mails"; string sql = "select * from Email where Meetname='" + getname() + "' and Status = '未读'"; this.dl.DataSource = OperateDB.ExecuteDataSet(sql); dl.DataBind(); } } }
public static PagedDataSource paged(string sql, AspNetPager AspNetPager1) { DataSet ds = OperateDB.ExecuteDataSet(sql); DataTable dt = new DataTable(); dt = ds.Tables[0]; DataColumn dc = dt.Columns.Add("number", System.Type.GetType("System.String")); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["number"] = (i + 1).ToString(); } DataView dv = ds.Tables[0].DefaultView; PagedDataSource pds = new PagedDataSource(); AspNetPager1.RecordCount = dv.Count; pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; pds.PageSize = AspNetPager1.PageSize; return(pds); }