public void BindData() { HomeServices ObjHome = new HomeServices(); DataSet ds = new DataSet(); ds = ObjHome.GetAllHomeServiceAdmin(Convert.ToInt32(ddlUserType.SelectedValue)); if (ds.Tables[0].Rows.Count > 0) { GrdServiceHome.Visible = true; GrdServiceHome.DataSource = ds.Tables[0]; GrdServiceHome.DataBind(); Utility.Setserial(GrdServiceHome, "srno"); } else { GrdServiceHome.Visible = true; } }
private void BindGrid() { DataSet ds = new DataSet(); ds = ObjServices.GetAllHomeServices(); if (ds.Tables[0].Rows.Count > 0) { GrdServiceHome.Visible = true; btnRemove.Visible = true; GrdServiceHome.DataSource = ds.Tables[0]; GrdServiceHome.DataBind(); CheckAll(); check(); Utility.Setserial(GrdServiceHome, "srno"); } else { GrdServiceHome.Visible = false; divError.Visible = true; ErrMessage("Please set service for home page(active service only) "); btnRemove.Visible = false; } ViewState["Cat"] = "False"; ViewState["Dog"] = "False"; ViewState["CatID"] = ""; ViewState["DogID"] = ""; if (ds.Tables[0].Rows.Count > 0) { ViewState["Cat"] = "False"; } if (ds.Tables[1].Rows.Count > 0) { ViewState["Dog"] = "False"; } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["ServiceType"].ToString() == "0") { ViewState["Cat"] = "True"; ViewState["CatID"] = ds.Tables[0].Rows[i]["ServiceID"].ToString(); } if (ds.Tables[0].Rows[i]["ServiceType"].ToString() == "1") { ViewState["Dog"] = "True"; ViewState["DogID"] = ds.Tables[0].Rows[i]["ServiceID"].ToString(); } } if (ds.Tables[1].Rows.Count > 0) { ddlCat.DataTextField = "ServiceTitle"; ddlCat.DataValueField = "ServiceID"; ddlCat.DataSource = ds.Tables[1]; ddlCat.DataBind(); divCat.Visible = true; ListItem lst = new ListItem(); lst.Text = "Select One"; lst.Value = "0"; ddlCat.Items.Insert(0, lst); if (ViewState["CatID"].ToString() != "") { ddlCat.SelectedValue = ViewState["CatID"].ToString(); } else { ddlCat.SelectedValue = "0"; } } else { divCat.Visible = false; } if (ds.Tables[2].Rows.Count > 0) { ddlDog.DataTextField = "ServiceTitle"; ddlDog.DataValueField = "ServiceID"; ddlDog.DataSource = ds.Tables[2]; ddlDog.DataBind(); divDog.Visible = true; ListItem lst = new ListItem(); lst.Text = "Select One"; lst.Value = "0"; ddlDog.Items.Insert(0, lst); if (ViewState["DogID"].ToString() != "") { ddlDog.SelectedValue = ViewState["DogID"].ToString(); } else { ddlDog.SelectedValue = "0"; } } else { divDog.Visible = false; } }