static int Main () { DataList user_list = new DataList (); List<string> str = new List<string> (); str.Add ("foo"); user_list.DataSource = str; user_list.DataBind (); StringWriter sw = new StringWriter (); HtmlTextWriter h = new HtmlTextWriter (sw); user_list.RenderControl (h); string expected = string.Format ("<table cellspacing=\"0\" border=\"0\" style=\"border-collapse:collapse;\">{0}" + "\t<tr>{0}" + "\t\t<td></td>{0}" + "\t</tr>{0}" + "</table>", Environment.NewLine); if (sw.ToString () != expected) { Console.WriteLine (sw.ToString ()); return 1; } return 0; }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); var lcc = new List <LinkCategory>(); lcc.AddRange(Repository.GetActiveCategories()); CatList.DataSource = lcc; CatList.DataBind(); }
void load(DataList x, string maloai) { HangBLL hb = new HangBLL(); ArrayList lst = new ArrayList(); lst = (ArrayList)hb.showHang("select * from Hang where maloai=" + maloai + "order by MaHang desc"); x.DataSource = lst; x.DataBind(); }
public void dlBind(DataList dlName, DataTable dsTable) { if (dsTable != null) { dlName.DataSource = dsTable.DefaultView; dlName.DataKeyField = dsTable.Columns[0].ToString(); dlName.DataBind(); } }
protected void parent_ItemDataBound(object sender, RepeaterItemEventArgs e) { DataList list = e.Item.FindControl("child") as DataList; DataRowView drv = e.Item.DataItem as DataRowView; DataTable table = t_2.type_2list(int.Parse(drv["typeid_1"].ToString()), ""); list.DataSource = table.DefaultView; list.DataBind(); }
/// <summary> /// 对DataList控件进行绑定 /// </summary> /// <param name="dlName">DataList控件名</param> /// <param name="dsTable">数据集DataSet的表的集合</param> public void dlBind(DataList dlName,DataTable dsTable) { if (dsTable != null) { dlName.DataSource = dsTable.DefaultView; dlName.DataKeyField = dsTable.Columns[0].ToString(); dlName.DataBind(); } }
//================================================= //功能描述:对datalist进行数据绑定,无排序 //输入参数:sql,查询的SQL语句;dl,需要绑定的datalist控件 //返回值:无 //时间:2013.08.20 //================================================= public static void binddatalist(string sql, DataList dl) { OleDbConnection conn = DB.Getconn(); DataSet ds = getdataset(sql); dl.DataSource = ds.Tables[0].DefaultView; closeConnection(); dl.DataBind(); }
protected void rptconfig1_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataList repinner = (DataList)e.Item.FindControl("rptconfig_inner1"); repinner.DataSource = filterdataset(dsexcel.Tables[2], "type", DataBinder.Eval(e.Item.DataItem, "type").ToString()); repinner.DataBind(); } }
public DataView loadData(ListInfo info, DBManager db, DataList repeater) { DBFilter filter = binding.createFilter(); DateTime dtPeriodFr, dtPeriodTo; if (DateTime.TryParse(RequestFromDate.Value, out dtPeriodFr)) { filter.add(new Match("RequestLateWaiveCreateDate", ">=", dtPeriodFr)); } if (DateTime.TryParse(RequestToDate.Value, out dtPeriodTo)) { filter.add(new Match("RequestLateWaiveCreateDate", "<", dtPeriodTo.AddDays(1))); } filter.add(new Match("c.EmpID", this.CurID)); if (!EmpRequestStatus.SelectedValue.Equals(string.Empty)) { if (EmpRequestStatus.SelectedValue.Equals("REQUEESTSTATUS_PROCESSING")) { AND andTerms = new AND(); andTerms.add(new Match("EmpRequestStatus", "<>", EEmpRequest.STATUS_APPROVED)); andTerms.add(new Match("EmpRequestStatus", "<>", EEmpRequest.STATUS_CANCELLED)); andTerms.add(new Match("EmpRequestStatus", "<>", EEmpRequest.STATUS_REJECTED)); filter.add(andTerms); } else if (EmpRequestStatus.SelectedValue.Equals("REQUEESTSTATUS_END_PROCESS")) { OR orTerms = new OR(); orTerms.add(new Match("EmpRequestStatus", EEmpRequest.STATUS_APPROVED)); orTerms.add(new Match("EmpRequestStatus", EEmpRequest.STATUS_CANCELLED)); orTerms.add(new Match("EmpRequestStatus", EEmpRequest.STATUS_REJECTED)); filter.add(orTerms); } } string select = "c.*, a.AttendanceRecordDate, a.AttendanceRecordActualLateMins, r.EmpRequestStatus, r.EmpRequestLastAuthorizationWorkFlowIndex, r.EmpRequestID "; string from = "from [" + db.dbclass.tableName + "] c " + " LEFT JOIN " + EAttendanceRecord.db.dbclass.tableName + " a On c.AttendanceRecordID = a.AttendanceRecordID " + " LEFT JOIN " + EEmpRequest.db.dbclass.tableName + " r On r.EmpRequestRecordID = c.RequestLateWaiveID and r.EmpRequestType = '" + EEmpRequest.TYPE_EELATEWAIVE + "'"; DataTable table = filter.loadData(dbConn, info, select, from); view = new DataView(table); ListFooter.Refresh(); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
public void InitBindData(Control c, Wuqi.Webdiyer.AspNetPager aspnet, string tbname, string tbcolumn, string sqlwhere) { aspnet.RecordCount = GetRows(tbname, sqlwhere); if (aspnet.RecordCount > 0) { string contype = c.GetType().ToString(); DataSet ds = GetList(aspnet.PageSize, aspnet.CurrentPageIndex, sqlwhere, tbname, tbcolumn); if (ds.Tables[0].Rows.Count > 0) { if (contype.IndexOf("GridView") != -1) { GridView gv = (GridView)c; gv.DataSource = ds; gv.DataBind(); } else if (contype.IndexOf("Repeater") != -1) { Repeater rep = (Repeater)c; rep.DataSource = ds; rep.DataBind(); } else if (contype.IndexOf("DataList") != -1) { DataList dl = (DataList)c; dl.DataSource = ds; dl.DataBind(); } } c.Visible = true; } else { string contype = c.GetType().ToString(); if (contype.IndexOf("GridView") != -1) { GridView gv = (GridView)c; gv.DataSource = null; gv.DataBind(); } else if (contype.IndexOf("Repeater") != -1) { Repeater rep = (Repeater)c; rep.DataSource = null; rep.DataBind(); } else if (contype.IndexOf("DataList") != -1) { DataList dl = (DataList)c; dl.DataSource = null; dl.DataBind(); } c.Visible = false; } }
/// <summary> /// 绑定首页商品推荐tab /// </summary> /// <param name="classNum">类别</param> /// <param name="dl">上面两个推荐位</param> /// <param name="dl2">下面四个推荐位</param> protected void bind(int classNum, DataList dl, DataList dl2) { dtTable = new DataTable(); DataColumn[] dataColumns = new DataColumn[6]; string[] colunm = { "BookID", "BookName", "picUrl", "BookUrl", "OriginalPrice", "MarketPrice" }; for (int k = 0; k < colunm.Length; k++) { dataColumns[k] = new DataColumn(colunm[k]); dtTable.Columns.Add(dataColumns[k]); } string sql = "select BookID,BookName,picUrl,OriginalPrice,MarketPrice from Goods_Recommend_ByClass,dbo.Goods_Class where Goods_Class.ClassID=Goods_Recommend_ByClass.ClassID AND Goods_Recommend_ByClass.ClassID=@Class"; SqlParameter[] parameters = { new SqlParameter("Class", classNum) }; DataSet ds = operate.GetTable(sql, parameters); DataRow row; for (int j = 0; j <= 3; j++) { row = dtTable.NewRow(); row["BookID"] = ds.Tables[0].Rows[j][0].ToString(); row["BookName"] = ds.Tables[0].Rows[j][1].ToString(); row["picUrl"] = ds.Tables[0].Rows[j][2].ToString(); row["OriginalPrice"] = ds.Tables[0].Rows[j][3].ToString(); row["MarketPrice"] = ds.Tables[0].Rows[j][4].ToString(); row["BookUrl"] = "Goods/Detail.aspx?id=" + ds.Tables[0].Rows[j][0].ToString(); dtTable.Rows.Add(row); } dl.DataSource = dtTable.DefaultView; dl.DataBind(); DataTable dtTable2 = new DataTable(); DataColumn[] dataColumns2 = new DataColumn[6]; string[] colunm2 = { "BookID", "BookName", "picUrl", "BookUrl", "OriginalPrice", "MarketPrice" }; for (int k = 0; k < colunm2.Length; k++) { dataColumns2[k] = new DataColumn(colunm2[k]); dtTable2.Columns.Add(dataColumns2[k]); } for (int j = 4; j <= 5; j++) { row = dtTable2.NewRow(); row["BookID"] = ds.Tables[0].Rows[j][0].ToString(); row["BookName"] = ds.Tables[0].Rows[j][1].ToString(); row["picUrl"] = ds.Tables[0].Rows[j][2].ToString(); row["OriginalPrice"] = ds.Tables[0].Rows[j][3].ToString(); row["MarketPrice"] = ds.Tables[0].Rows[j][4].ToString(); row["BookUrl"] = "Goods/Detail.aspx?id=" + ds.Tables[0].Rows[j][0].ToString(); dtTable2.Rows.Add(row); } dl2.DataSource = dtTable2.DefaultView; dl2.DataBind(); }
public static void Data_Preview_6(string Category, DataList Data_SubList, DataList Data_Product, DataList Data_More_Product, DataList Data_More_Product_2, DataList Data_More_Product_3, DataList Data_More_Product_4) { DataTable dt = null; dt = db.QP("exec Common_Proc_Category_Select @P0,@P1", Category, "Product").Tables[0]; if (dt.Rows.Count > 0) { Data_SubList.DataSource = dt; Data_SubList.DataBind(); } dt = null; dt = db.QP("exec Product_Data_List @P0", Category).Tables[0]; if (dt.Rows.Count > 0) { Data_Product.DataSource = dt; Data_Product.DataBind(); } dt = null; dt = db.QP("exec Product_Data_List @P0", Category).Tables[0]; if (dt.Rows.Count > 0) { Data_More_Product.DataSource = dt; Data_More_Product.DataBind(); } dt = null; dt = db.QP("exec Product_Data_List @P0", Category).Tables[0]; if (dt.Rows.Count > 0) { Data_More_Product_2.DataSource = dt; Data_More_Product_2.DataBind(); } dt = null; dt = db.QP("exec Product_Data_List @P0", Category).Tables[0]; if (dt.Rows.Count > 0) { Data_More_Product_3.DataSource = dt; Data_More_Product_3.DataBind(); } dt = null; dt = db.QP("exec Product_Data_List @P0", Category).Tables[0]; if (dt.Rows.Count > 0) { Data_More_Product_4.DataSource = dt; Data_More_Product_4.DataBind(); } }
//================================================= //功能描述:对datalist进行数据绑定,无排序 //输入参数:sql,查询的SQL语句;dl,需要绑定的datalist控件 //返回值:无 //时间:2013.08.20 //================================================= public static void binddatalist(string sql, DataList dl) { OleDbConnection conn = DB.Getconn(); DataSet ds = getdataset(sql); dl.DataSource = ds.Tables[0].DefaultView; closeConnection(); dl.DataBind(); }
protected void gvItemHistory_RowDataBound(object sender, GridViewRowEventArgs e) { if (DataControlRowType.DataRow == e.Row.RowType) { DataList rptr = (DataList)e.Row.FindControl("rptQuoted"); string Document = ((Label)e.Row.FindControl("lblReqsnNO")).ToolTip; rptr.DataSource = BLL_PURC_Common.Get_QuotedRates_ByItem(Document, Request.QueryString["item_ref_code"]); rptr.DataBind(); } }
public void findAll(TextBox textBox, DataList dataList) { string query = "select * from Product where Name LIKE '%" + textBox.Text + "%'"; var sqlda = new SqlDataAdapter(query, connect.setConnect()); var ds = new DataSet(); sqlda.Fill(ds, "Product"); dataList.DataSource = ds.Tables["Product"]; dataList.DataBind(); }
public void DataPage(string sqlcom, DataList MarketDetailDl, Label lblCurPage, Label lblTnum, Label lblEachPage, HyperLink lnkFirst, HyperLink lnkLast, HyperLink lnkPrev, HyperLink lnkNext, HttpRequest Request) { DataAccess data = new DataAccess(); data.Connection(); SqlCommand cmd = data.excute(sqlcom); DataSet ds = data.Fill(cmd); MarketDetailDl.DataSource = ds.Tables[0].DefaultView; MarketDetailDl.DataBind(); PagedDataSource objPage = new PagedDataSource();//创建分页类 objPage.DataSource = ds.Tables["Table"].DefaultView;//设置数据源 objPage.AllowPaging = true; objPage.PageSize = 5; if (Request.QueryString["Page"] != null) { CurPage = Convert.ToInt32(Request.QueryString["Page"]); CurPage = Math.Min(CurPage, objPage.PageCount); CurPage = Math.Max(CurPage, 1); } else CurPage = 1; objPage.CurrentPageIndex = CurPage - 1; TotalPage = objPage.PageCount; Tnum = objPage.DataSourceCount; EachPage = objPage.Count; lblCurPage.Text = "第 " + CurPage.ToString() + " / " + TotalPage.ToString() + " 页"; lblTnum.Text = "共: " + Tnum + " 条记录"; lblEachPage.Text = "每页有: " + EachPage.ToString() + " 条记录"; if (objPage.CurrentPageIndex != 0) lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage-CurPage +1); if (objPage.CurrentPageIndex != TotalPage - 1) lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(TotalPage); if (!objPage.IsFirstPage) lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1); if (!objPage.IsLastPage) lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1); MarketDetailDl.DataSource = objPage; MarketDetailDl.DataBind(); }
public static void BindDataList2(DataList dl) { SqlConnection conn = Conn(); string sqlstr = "select top 7 * from news where newstype='班级新闻' order by id desc"; SqlCommand cmd = new SqlCommand(sqlstr, conn); SqlDataReader sdr = cmd.ExecuteReader(); dl.DataSource = sdr; dl.DataBind(); }
public void setDatalist(DataTable dtDatos, DataList dtlDatalist) { if (dtDatos != null) { PagedDataSource objPds = new PagedDataSource(); objPds.DataSource = dtDatos.DefaultView; dtlDatalist.DataSource = objPds; dtlDatalist.DataBind(); } }
protected void outerDataList_OnItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView drv = e.Item.DataItem as DataRowView; DataList innerDataList = e.Item.FindControl("innerDataList") as DataList; innerDataList.DataSource = drv.CreateChildView("QA_Relation"); innerDataList.DataBind(); } }
private void LoadChartOfAccountList(DataList lstChartOfAccount, int AccountCategoryID) { ChartOfAccounts clsChartOfAccount = new ChartOfAccounts(); DataClass clsDataClass = new DataClass(); System.Data.DataTable dt = clsDataClass.DataReaderToDataTable(clsChartOfAccount.List(AccountCategoryID, "ChartOfAccountCode", SortOption.Ascending)); clsChartOfAccount.CommitAndDispose(); lstChartOfAccount.DataSource = dt.DefaultView; lstChartOfAccount.DataBind(); }
void LoadShippingList() { DataList dtAddresses = (DataList)wizCheckout.FindControl("dtAddresses"); if (dtAddresses != null) { dtAddresses.DataSource = OrderController.GetUserAddresses(); dtAddresses.DataBind(); } }
void load(DataList x, string maloai) { //Lấy ra số lượng hàng theo từng loại hàng HangBLL hb = new HangBLL(); ArrayList lst = new ArrayList(); lst = (ArrayList)hb.showHang("select top 5 * from Hang where maloai=" + maloai + "order by MaHang desc"); x.DataSource = lst; x.DataBind(); }
private void LoadAccountCategoryList(DataList lstAccountCategory, int AccountSummaryID) { AccountCategories clsAccountCategory = new AccountCategories(); DataClass clsDataClass = new DataClass(); System.Data.DataTable dt = clsDataClass.DataReaderToDataTable(clsAccountCategory.List(AccountSummaryID, "AccountCategoryCode", SortOption.Ascending)); clsAccountCategory.CommitAndDispose(); lstAccountCategory.DataSource = dt.DefaultView; lstAccountCategory.DataBind(); }
private void bind() { int count = BlogManager.GetInstance().BlogBaseModel.BlogModel.RecentCommentListCount; CommentBindModel bindModel = CommentManager.GetInstance().GetRecentCommentList(count); DataList dlRecentComment = (DataList)snap_RecentComment.FindControl("panel1").FindControl("dlRecentComment"); dlRecentComment.DataSource = bindModel; dlRecentComment.DataBind(); }
public void BindData() { this.LauncherRecommList = new GroupBLL().GetLauncherRecommend(SchemeID, GroupTypeID); DataList.DataSource = this.LauncherRecommList; DataList.DataBind(); if (PageType == "new" && LauncherRecommList.Count > 0) { Button1.Visible = true; } }
protected void dlChild_ItemDataBound(object sender, System.Web.UI.WebControls.DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item | e.Item.ItemType == ListItemType.AlternatingItem) { CheckBox ChkIsAdd = (CheckBox)e.Item.FindControl("ChkIsAdd"); HtmlTableCell objIsadd = (HtmlTableCell)e.Item.FindControl("tdIsAdd"); if (ChkIsAdd.Visible == false) { objIsadd.InnerHtml = "NA"; } CheckBox ChkIsEdit = (CheckBox)e.Item.FindControl("ChkIsEdit"); HtmlTableCell objIsEdit = (HtmlTableCell)e.Item.FindControl("tdIsEdit"); if (ChkIsEdit.Visible == false) { objIsEdit.InnerHtml = "NA"; } CheckBox ChkIsDelete = (CheckBox)e.Item.FindControl("ChkIsDelete"); HtmlTableCell objIsDelete = (HtmlTableCell)e.Item.FindControl("tdIsDelete"); if (ChkIsDelete.Visible == false) { objIsDelete.InnerHtml = "NA"; } DataList dlChild = (DataList)e.Item.Parent; DataList dl = (DataList)e.Item.FindControl("dlChild2"); DataTable dt = new DataTable(); if (string.IsNullOrEmpty(hdnPKID.Value)) { if ((bool)Session[appFunctions.Session.IsSuperAdmin.ToString()] == true) { dt = objRole.LoadPermissionTab(0.ToString(), dlChild.DataKeys[e.Item.ItemIndex].ToString(), "", (bool)Session[appFunctions.Session.IsSuperAdmin.ToString()]); } else { dt = objRole.LoadPermissionTab(Session[appFunctions.Session.RoleID.ToString()].ToString(), dlChild.DataKeys[e.Item.ItemIndex].ToString(), "", (bool)Session[appFunctions.Session.IsSuperAdmin.ToString()]); } } else { if ((bool)Session[appFunctions.Session.IsSuperAdmin.ToString()] == true) { dt = objRole.LoadPermissionTab(hdnPKID.Value, dlChild.DataKeys[e.Item.ItemIndex].ToString(), "", (bool)Session[appFunctions.Session.IsSuperAdmin.ToString()]); } else { dt = objRole.LoadPermissionTab(Session[appFunctions.Session.RoleID.ToString()].ToString(), dlChild.DataKeys[e.Item.ItemIndex].ToString(), "", (bool)Session[appFunctions.Session.IsSuperAdmin.ToString()], hdnPKID.Value); } } dl.DataSource = dt; dl.DataBind(); } }
/// <summary> /// Views the Assignments. /// </summary> /// <param name="dlistLectureNote">Datalist to display the assignments.</param> /// <param name="courseID">ID of the course.</param> public static void ViewAssignment(DataList dlistAssignment, string courseID) { AssignmentList alist; DataTable dt = new DataTable(); alist = AssignmentController.GetItem(courseID); DataColumn dc = new DataColumn(); dc.DataType = Type.GetType("System.String"); dc.ColumnName = "AFileLocation"; dt.Columns.Add(dc); DataColumn dc1 = new DataColumn(); dc1.DataType = Type.GetType("System.String"); dc1.ColumnName = "AssignmentID"; dt.Columns.Add(dc1); DataColumn dc2 = new DataColumn(); dc2.DataType = Type.GetType("System.String"); dc2.ColumnName = "AssignmentTitle"; dt.Columns.Add(dc2); DataColumn dc3 = new DataColumn(); dc3.DataType = Type.GetType("System.String"); dc3.ColumnName = "DueDate"; dt.Columns.Add(dc3); DataColumn dc4 = new DataColumn(); dc4.DataType = Type.GetType("System.String"); dc4.ColumnName = "AssignmentDate"; dt.Columns.Add(dc4); DataRow dr; if (alist != null) { foreach (Assignment assignment in alist) { dr = dt.NewRow(); dr["AFileLocation"] = assignment.AFileLocation; dr["AssignmentID"] = assignment.AssignmentId; dr["AssignmentTitle"] = assignment.ATitle; dr["DueDate"] = assignment.DueDate.ToShortDateString(); dr["AssignmentDate"] = assignment.AssignedDate; dt.Rows.Add(dr); } } dlistAssignment.DataSource = dt; dlistAssignment.DataBind(); }
public static void Process_Pagination(DataList _list, Repeater _rept, LinkButton _prev, LinkButton _next, int _size, int _pagenumber, IEnumerable _source, int _totalrecords) { int total_pages = (int)Math.Ceiling((double)_totalrecords / _size); if (total_pages > 1) { // Previous Link Scripting if (_pagenumber > 1) { _prev.Visible = true; int firstbound = (((_pagenumber - 1) - 1) * _size) + 1; if (firstbound < 0) { firstbound = 1; } int lastbound = firstbound + _size - 1; _prev.ToolTip = "Showing " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records"; } else { _prev.Visible = false; } // Next Link Scripting if (_pagenumber < total_pages) { _next.Visible = true; int firstbound = (((_pagenumber + 1) - 1) * _size) + 1; int lastbound = firstbound + _size - 1; if (lastbound > _totalrecords) { lastbound = _totalrecords; } _next.ToolTip = "Showing " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records"; } else { _next.Visible = false; } // main pagination links ArrayList arr = Return_Pagination_Link_v2(total_pages, _pagenumber); _rept.Visible = true; _rept.DataSource = arr; _rept.DataBind(); } else { _rept.Visible = false; _next.Visible = false; _prev.Visible = false; } _list.DataSource = _source; _list.DataBind(); }
public void bindnested(int itemindex) { int z = itemindex; int id = Convert.ToInt32(DataList1.DataKeys[itemindex]); admin ad = new admin(); DataTable dt = ad.getsubsubcategorywithcountbysubcategory(id); DataList nesteddatalist = (DataList)DataList1.Items[itemindex].FindControl("DataList2"); nesteddatalist.DataSource = dt; nesteddatalist.DataBind(); }
public void loadDataList(String sql, DataList dtl) { connectDB(); SqlDataAdapter adapter = new SqlDataAdapter(sql, sqlcon); adapter.Fill(dt); dtl.DataSource = dt; dtl.DataBind(); close(); adapter.Dispose(); }
public static void Listeler_Area_ID(string Proc, DataList Datalist, string Area, int ID, int Top) { //try //{ DataTable dt = db.QP("exec " + Proc + " @P0,@P1,@P1", Area, ID, Top).Tables[0]; Datalist.DataSource = dt; Datalist.DataBind(); //} //catch { } }
protected void dlBookings_ItemDataBound(object sender, DataListItemEventArgs e) { DataList dl = (DataList)e.Item.FindControl("dlBookingDetails"); int bookingId = Convert.ToInt32(((Label)e.Item.FindControl("BookingIdLabel")).Text); dl.DataSource = (from bookingObj in bookings where bookingObj.BookingId == bookingId select bookingObj.BookingDetails).Single(); dl.DataBind(); }
public void dlDataBind(DataList dl, string sqlstr) { sqlconn.Open(); SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlconn); DataSet myds = new DataSet(); myda.Fill(myds); dl.DataSource = myds; dl.DataBind(); sqlconn.Close(); }
public void changeLinks() { DbProvider dbSelectZip = new DbProvider(); int sideType = 0; string admin = Convert.ToString(Request.Cookies["adminId"].Value); //For Customers DataList MyDataListCustomers = (DataList)Page.Master.FindControl("dtlcustomers"); sideType = 1; DataSet dsAdminCustomers = dbSelectZip.GetSideLinkInfo(Convert.ToInt32(admin), sideType); if (dsAdminCustomers.Tables[0].Rows.Count > 0) { if (dsAdminCustomers != null && dsAdminCustomers.Tables.Count > 0 && dsAdminCustomers.Tables[0].Rows.Count > 0) { MyDataListCustomers.DataSource = dsAdminCustomers; MyDataListCustomers.DataBind(); } } //for Site Functions DataList MyDataListSiteFunctions = (DataList)Page.Master.FindControl("dtlsitefunctions"); sideType = 2; DataSet dsAdminSiteFunctions = dbSelectZip.GetSideLinkInfo(Convert.ToInt32(admin), sideType); if (dsAdminSiteFunctions.Tables[0].Rows.Count > 0) { if (dsAdminSiteFunctions != null && dsAdminSiteFunctions.Tables.Count > 0 && dsAdminSiteFunctions.Tables[0].Rows.Count > 0) { MyDataListSiteFunctions.DataSource = dsAdminSiteFunctions; MyDataListSiteFunctions.DataBind(); } } //for reports DataList MyDataListReports = (DataList)Page.Master.FindControl("dtlreports"); sideType = 3; DataSet dsAdminReports = dbSelectZip.GetSideLinkInfo(Convert.ToInt32(admin), sideType); if (dsAdminReports.Tables[0].Rows.Count > 0) { if (dsAdminReports != null && dsAdminReports.Tables.Count > 0 && dsAdminReports.Tables[0].Rows.Count > 0) { MyDataListReports.DataSource = dsAdminReports; MyDataListReports.DataBind(); } } dbSelectZip.dispose(); }
/// <summary> /// 创建时间:2008-4-18 /// 该方法实现的是将数据绑定到DataList控件中 /// 参数:dl 要绑定的DataList控件的控件的名称 /// 参数:SqlStr 执行的Sql语句 public void EXECBindDataList(DataList dl, string SqlStr) { SqlConnection con = new SqlConnection(GetConStr()); con.Open();//打开数据库连接 SqlDataAdapter ada = new SqlDataAdapter(SqlStr, con); DataSet ds = new DataSet(); ada.Fill(ds); dl.DataSource = ds; dl.DataBind(); con.Close();//关闭数据库连接 }
/// 邦定DataList数据 /// <summary> /// 邦定DataList数据 /// </summary> /// <param name="Dl">DataList</param> /// <param name="sql">SQL语句</param> /// <param name="KeyField">关联DataList里DataKeyField的键字段</param> /// <returns></returns> public int BindDataList(DataList Dl, string sql, string KeyField) { Regex reg = new Regex(_noSafe, RegexOptions.IgnoreCase); if (reg.IsMatch(sql)) { throw new System.Exception("警告!!不安全SELECT! "); } try { DataSet ds = GetDS(sql); Dl.DataSource = ds; Dl.DataKeyField = KeyField; Dl.DataBind(); return ds.Tables[0].Rows.Count; } catch { return 0; } }
public static DataList PagesLoad(DataList Repeater1) { //// String com = System.Configuration.ConfigurationManager.AppSettings["com.systemsoriginals.www.webservice"].ToString(); // * ++++++++++++++++++++++************** DataSet ds = new DataSet(); XmlNode CurrNode; XmlDocument HomeSettings = new XmlDocument(); // m_pages //strPhysicalPath = messages.strPhysicalPath; // Request.MapPath("~\\XML\\changeText.xml"); //messages.xml.Load(strPhysicalPath); HomeSettings.Load(strPhysicalPath); CurrNode = HomeSettings.SelectSingleNode("DonateExl"); XmlNodeList CurrNodes = CurrNode.ChildNodes; int xx = 0; messages.arrlstPages.Clear(); if (messages.arrlstPages.Count == 0) { foreach (XmlNode node in CurrNodes) { if (node.Name.ToString() == "DonateHomePage") { messages.defaultpage = node.InnerText; } else { clsPages clspages = new clsPages(node.Name.ToString(), strPhysicalPath); messages.arrlstPages.Add(clspages); } } } messages.lstPages.Clear(); foreach (XmlNode node in CurrNodes) { string nodeAttr = node.Attributes.Count>0? node.Attributes[0].Value : ""; messages.lstPages.Add(node.Name.ToString() + "," + nodeAttr); } Repeater1.DataSource = messages.lstPages; Repeater1.DataBind(); messages.qulstPages.Clear(); messages.qulstPages.Enqueue(lstPages); return Repeater1; }
public static void bindDataList(string command, DataList dl) { dl.DataSource = getDataTable(command); dl.DataBind(); }
// Process Pagination ver 2.0 // Compatible with Hyperlinks // Compatible with both MySQL / SQL SERVER. // Support Advance Pagination public static void Process_Pagination_v2(DataList _list,Repeater _rept,HyperLink _prev,HyperLink _next,int _size, int _pagenumber, IEnumerable _source, int _totalrecords) { if (Site_Settings.Pagination_Type == 1) { // MySQL Compatible int total_pages = (int)Math.Ceiling((double)_totalrecords / _size); if (total_pages > 1) { // Previous Link Scripting if (_pagenumber > 1) { _prev.Visible = true; int firstbound = (((_pagenumber - 1) - 1) * _size) + 1; if (firstbound < 0) firstbound = 1; int lastbound = firstbound + _size - 1; _prev.ToolTip = "Showing " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records"; } else { _prev.Visible = false; } // Next Link Scripting if (_pagenumber < total_pages) { _next.Visible = true; int firstbound = (((_pagenumber + 1) - 1) * _size) + 1; int lastbound = firstbound + _size - 1; if (lastbound > _totalrecords) lastbound = _totalrecords; _next.ToolTip = "Showing " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records"; } else { _next.Visible = false; } // main pagination links ArrayList arr = Pagination_Process.Return_Pagination_Link_v2(total_pages, _pagenumber); _rept.Visible = true; _rept.DataSource = arr; _rept.DataBind(); } else { _rept.Visible = false; _next.Visible = false; _prev.Visible = false; } _list.DataSource = _source; _list.DataBind(); } else { // SQL SERVER Compatible PagedDataSource objPds = new PagedDataSource(); objPds.DataSource = _source; objPds.AllowPaging = true; objPds.PageSize = _size; objPds.CurrentPageIndex = (_pagenumber - 1); if (!objPds.IsFirstPage) { _prev.Visible = true; int firstbound = (((_pagenumber - 1) - 1) * _size) + 1; if (firstbound < 0) firstbound = 1; int lastbound = firstbound + _size - 1; _prev.ToolTip = "Showing previous " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records"; } else { _prev.Visible = false; } if (!objPds.IsLastPage) { int firstbound = (((_pagenumber + 1) - 1) * _size) + 1; int lastbound = firstbound + _size - 1; if (lastbound > _totalrecords) lastbound = _totalrecords; _next.ToolTip = "Showing next " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records"; _next.Visible = true; } else { _next.Visible = false; } ArrayList arr = Pagination_Process.Return_Pagination_Link_v2(objPds.PageCount, _pagenumber); if (objPds.PageCount > 1) { _rept.Visible = true; _rept.DataSource = arr; _rept.DataBind(); } else { _rept.Visible = false; } _list.DataSource = objPds; _list.DataBind(); } }
//FOR DATALIST public void Filldatalist(string strQuery, DataList dtl) { adp = new SqlDataAdapter(strQuery, sqlCon); ds = new DataSet(); adp.Fill(ds); dtl.DataSource = ds; dtl.DataBind(); }
public void DGIBind(int P_Int_Deplay, string P_Str_srcTable,DataList DLName) { SqlConnection myConn = dbObj.GetConnection(); SqlCommand myCmd = new SqlCommand("Proc_DeplayGInfo", myConn); myCmd.CommandType = CommandType.StoredProcedure; // SqlParameter Deplay = new SqlParameter("@Deplay", SqlDbType.Int, 4); Deplay.Value = P_Int_Deplay; myCmd.Parameters.Add(Deplay); // myConn.Open(); try { myCmd.ExecuteNonQuery(); } catch (Exception ex) { throw (ex); } finally { myCmd.Dispose(); myConn.Close(); } SqlDataAdapter da = new SqlDataAdapter(myCmd); DataSet ds = new DataSet(); da.Fill(ds, P_Str_srcTable); DLName.DataSource = ds.Tables[P_Str_srcTable].DefaultView; DLName.DataBind(); }
public void DLClassBind(DataList dlName) { string P_Str_SqlStr = "select * from tb_Class"; SqlConnection myConn = dbObj.GetConnection(); SqlDataAdapter da = new SqlDataAdapter(P_Str_SqlStr, myConn); DataSet ds = new DataSet(); da.Fill(ds, "Class"); dlName.DataSource = ds.Tables["Class"].DefaultView; dlName.DataBind(); }
public void datalistviewcall(string query, DataList g1) { fetch(query); g1.DataSource = ds.Tables[0]; g1.DataBind(); }
public static void Process_Pagination(DataList _list, Repeater _rept, LinkButton _prev, LinkButton _next, int _size, int _pagenumber, IEnumerable _source) { PagedDataSource objPds = new PagedDataSource(); objPds.DataSource = _source; objPds.AllowPaging = true; objPds.PageSize = _size; objPds.CurrentPageIndex = (_pagenumber - 1); if (!objPds.IsFirstPage) _prev.Visible = true; else _prev.Visible = false; if (!objPds.IsLastPage) _next.Visible = true; else _next.Visible = false; ArrayList arr = Return_Pagination_Link(objPds.PageCount, 11, _pagenumber); if (objPds.PageCount > 1) { _rept.Visible = true; _rept.DataSource = arr; _rept.DataBind(); } else { _rept.Visible = false; } _list.DataSource = objPds; _list.DataBind(); }
public static void Process_Pagination(DataList _list, Repeater _rept, LinkButton _prev, LinkButton _next, int _size, int _pagenumber, IEnumerable _source, int _totalrecords) { int total_pages = (int)Math.Ceiling((double)_totalrecords / _size); if (total_pages > 1) { // Previous Link Scripting if (_pagenumber > 1) { _prev.Visible = true; int firstbound = (((_pagenumber - 1) - 1) * _size) + 1; if (firstbound < 0) firstbound = 1; int lastbound = firstbound + _size - 1; _prev.ToolTip = "Showing " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records"; } else { _prev.Visible = false; } // Next Link Scripting if (_pagenumber < total_pages) { _next.Visible = true; int firstbound = (((_pagenumber + 1) - 1) * _size) + 1; int lastbound = firstbound + _size - 1; if (lastbound > _totalrecords) lastbound = _totalrecords; _next.ToolTip = "Showing " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records"; } else { _next.Visible = false; } // main pagination links ArrayList arr = Return_Pagination_Link_v2(total_pages, _pagenumber); _rept.Visible = true; _rept.DataSource = arr; _rept.DataBind(); } else { _rept.Visible = false; _next.Visible = false; _prev.Visible = false; } _list.DataSource = _source; _list.DataBind(); }