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();
}
