protected void dlKmlPlaceMarks_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.SelectedItem) { GridView grdList = (GridView)e.Item.FindControl("grdList"); ListMaster objListMaster = new ListMaster(ConnectionString); DataTable dtLists = objListMaster.getAllListsWithMembersCount("ListName", "ASC"); grdList.DataSource = dtLists; grdList.DataBind(); } }
protected void bindGrid() { try { ListMaster objListMaster = new ListMaster(ConnectionString); DataTable dtLists = objListMaster.getAllListsWithMembersCount("ListName", "ASC"); dlList.DataSource = dtLists; dlList.DataBind(); } catch (Exception ex) { throw ex; } }
/// <summary> /// To bind List grid /// </summary> /// <param name="fillFlag"></param> /// <param name="_sortdir"></param> /// <param name="_gridSortExp"></param> protected void bindGrid(string fillFlag, string _sortdir, string _gridSortExp) { try { string sortdir = (fillFlag == "sort" ? GetSortDirection() : GridViewSortDirection); if (flagreset == true) { sortdir = "ASC"; GridSortExpression = "ListName"; } ListMaster objListMaster = new ListMaster(ConnectionString); DataTable dtLists = objListMaster.getAllListsWithMembersCount(GridSortExpression, sortdir); if (dtLists.Rows.Count > 0) { grdList.DataSource = dtLists; grdList.DataBind(); GridPrevSortExpression = GridSortExpression; } udpnlListGridview.Update(); } catch (Exception ex) { throw ex; } }
public XmlDocument GetAllLists(string UserID, string Password) { XmlDocument doc = new System.Xml.XmlDocument(); string Con = GetConnectionString(UserID, Password); ListMaster objListMaster = new ListMaster(Con); DataTable dtLists = objListMaster.getAllListsWithMembersCount("ListMasterID", "asc"); StringBuilder str = new StringBuilder(); str.Append("<ListsInfo>"); if (dtLists != null) { for (int i = 0; i < dtLists.Rows.Count; i++) { str.Append("<List Row=\"" + i.ToString() + "\"> "); str.Append("<ListMasterID>" + dtLists.Rows[i]["ListMasterID"].ToString() + "</ListMasterID> "); str.Append(" <ListName>" + dtLists.Rows[i]["ListName"].ToString() + "</ListName>"); //str.Append(" <ListDesc>" + dtLists.Rows[i]["ListDesc"].ToString() + "</ListDesc>"); if (string.IsNullOrEmpty(dtLists.Rows[i]["ListDesc"].ToString())) str.Append("<ListDesc>" + string.Empty + "</ListDesc>"); else str.Append("<ListDesc>" + Server.HtmlEncode(dtLists.Rows[i]["ListDesc"].ToString()) + "</ListDesc>"); str.Append(" <ListCowner>" + dtLists.Rows[i]["ListCowner"].ToString() + "</ListCowner>"); str.Append(" <AllMembers>" + dtLists.Rows[i]["AllMembers"].ToString() + "</AllMembers>"); str.Append(" <ValidMembers>" + dtLists.Rows[i]["ValidMembers"].ToString() + "</ValidMembers>"); str.Append(" <CreatedDate>" + Convert.ToDateTime(dtLists.Rows[i]["CreatedDate"]).ToString() + "</CreatedDate>"); str.Append("<Errormessage></Errormessage>"); str.Append("</List>"); string ss = str.ToString(); } } else { str.Append("<Message> Please Enter Valid Inputs</Message>"); } str.Append("</ListsInfo>"); doc.LoadXml(str.ToString()); return doc; }
private void bindGridto() { try { ListMaster objListMaster = new ListMaster(ConnectionString); DataTable dtLists = objListMaster.getAllListsWithMembersCount("CreatedDate", "desc"); dtLists.AsEnumerable().ToList().ForEach(delegate(DataRow row) { if (row["ListName"].ToString().Contains(""")) row["ListName"] = Server.HtmlEncode(row["ListName"].ToString()); }); GrdList2.DataSource = dtLists; GrdList2.DataBind(); } catch (Exception ex) { throw ex; } }
protected void bindGrid(string fillFlag, string _sortdir, string _gridSortExp) { try { string sortdir = (fillFlag == "sort" ? GetSortDirection() : GridViewSortDirection); // to display listname wise sorting whenever a list gets created or removed if (!_gridSortExp.Equals(string.Empty)) { sortdir = _sortdir; GridSortExpression = _gridSortExp; } ListMaster objListMaster = new ListMaster(ConnectionString); DataTable dtLists = objListMaster.getAllListsWithMembersCount(GridSortExpression, sortdir); //to sort grdList1.DataSource = dtLists; GrdList2.DataSource = dtLists; grdList1.DataBind(); GrdList2.DataBind(); // if grid has no records then disable the remove button udpnlGrid1.Update(); udpnlGrid2.Update(); GridPrevSortExpression = GridSortExpression; } catch (Exception ex) { throw ex; } }
private void buildSegmentFromLists(string fillFlag, int pageIndex) { try { string sortdir = (fillFlag == "sort" ? GetSortDirection() : GridViewSortDirection); if (flagreset == true) { sortdir = "ASC"; GridSortExpression = "ListName"; } ListMaster objListMaster = new ListMaster(ConnectionString); DataTable dtLists = objListMaster.getAllListsWithMembersCount(GridSortExpression, sortdir); if (hdfListId.Value != "") { DataRow[] dataRow = dtLists.Select("ListMasterId=" + hdfListId.Value); dtLists.Rows.Remove(dataRow[0]); } if (dtLists.Rows.Count > 0) { rgdList.DataSource = dtLists; rgdList.CurrentPageIndex = pageIndex; rgdList.DataBind(); GridPrevSortExpression = GridSortExpression; } lblMember.Text = ""; lblListsSelected.Text = ""; divListFiletr.Style.Add("display", "none"); divCampaigns.Style.Add("display", "none"); divCampaignFilter.Style.Add("display", "none"); divLists.Style.Add("display", "block"); } catch (Exception ex) { throw ex; } }