/* Use to bind all styles from database */
private void BindGrid()
{
StoreFront ObjStoreFront = new StoreFront();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataView dv = new DataView();
ds = ObjStoreFront.GetStyle(Request.QueryString["SearchFor"].ToString(), Request.QueryString["SearchText"].ToString());
ddlSearch.SelectedValue = Request.QueryString["SearchFor"].ToString();
txtSearch.Text = Request.QueryString["SearchText"].ToString();
if (ds.Tables[0].Rows.Count > 0)
{
gdvStyle.Visible = true;
btnDelete.Visible = true;
btnStatus.Visible = true;
//lblNorec.Visible = false;
dt = ds.Tables[0];
dv = dt.DefaultView;
if ((SortExpression != string.Empty) && (SortDirection != string.Empty))
{
dv.Sort = SortExpression + " " + SortDirection;
}
gdvStyle.DataSource = dv;
gdvStyle.DataBind();
CheckAll();
check();
Utility.Setserial(gdvStyle, "srno");
btnExport.Visible = true;
btnImport.Visible = true;
divsearch.Visible = true;
}
else
{
// lblNorec.Visible = true;
divsearch.Visible = false;
btnDelete.Visible = false;
btnNew.Visible = true;
btnStatus.Visible = false;
gdvStyle.Visible = false;
ErrMessage("Sorry no records found.");
if ((Convert.ToInt32(ddlSearch.SelectedIndex) > 0) && (txtSearch.Text != ""))
{
txtSearch.Text = "";
ddlSearch.SelectedIndex = 0;
lnkNorec.Visible = true;
btnNew.Visible = false;
// btnAdd.Visible = false;
btnExport.Visible = false;
btnImport.Visible = false;
//divSelectPet.Visible = false;
//lblMsg.Visible = true;
ErrMessage("Sorry no records found.");
}
}
}
