private void BindData() { SitesList.PageSize = int.Parse(PageSizeList.SelectedValue); SitesList.DataSource = GetDataView(); SitesList.DataBind(); }
private void BindTable() { SitesList.Columns[0].HeaderText = LocRM.GetString("Title"); SitesList.Columns[1].HeaderText = LocRM.GetString("Domain"); SitesList.Columns[2].HeaderText = LocRM.GetString("CName"); SitesList.Columns[3].HeaderText = LocRM.GetString("eMail"); SitesList.Columns[4].HeaderText = LocRM.GetString("Phone"); SitesList.Columns[5].HeaderText = "Reseller"; DataTable dt = DBTrialRequest.GetDataTable(); DataView dv = dt.DefaultView; dv.Sort = ViewState[ConstRequestSortingKey].ToString(); string sFilter = ""; if (ddReseller.SelectedItem.Value != "0") { sFilter = "ResellerTitle='" + ddReseller.SelectedItem.Text + "'"; } if (ddStatus.SelectedItem.Value == "1") { if (sFilter.Length > 0) { sFilter += "AND IsActive='True'"; } else { sFilter = "IsActive='True'"; } } if (ddStatus.SelectedItem.Value == "-1") { if (sFilter.Length > 0) { sFilter += "AND IsActive='False'"; } else { sFilter = "IsActive='False'"; } } if (sFilter.Length > 0) { dv.RowFilter = sFilter; } SitesList.DataSource = dv; SitesList.DataBind(); }