private string GetStateName(string StateID) { string sState = string.Empty; try { DropdownBL objdropdownBL = new DropdownBL(); DataSet dsDropDown = new DataSet(); if (System.Web.HttpContext.Current.Session["DsDropDown"] == null) { dsDropDown = objdropdownBL.Usp_Get_DropDown(); System.Web.HttpContext.Current.Session["DsDropDown"] = dsDropDown; } else { dsDropDown = (DataSet)System.Web.HttpContext.Current.Session["DsDropDown"]; } DataTable dt = new DataTable(); DataView dv = new DataView(); dv = dsDropDown.Tables[1].DefaultView; dv.RowFilter = "State_ID='" + StateID + "'"; dt = dv.ToTable(); if (dt.Rows.Count > 0) { sState = dt.Rows[0]["State_Code"].ToString(); } //ddlLocationState.Items.Insert(0, new ListItem("Unspecified", "0")); } catch (Exception ex) { } return sState; }
private void FillStates() { DropdownBL objdropdownBL = new DropdownBL(); DataSet dsDropDown = new DataSet(); try { if (Session["DsDropDown"] == null) { dsDropDown = objdropdownBL.Usp_Get_DropDown(); Session["DsDropDown"] = dsDropDown; } else { dsDropDown = (DataSet)Session["DsDropDown"]; } grdAssign.DataSource = dsDropDown.Tables[1]; grdAssign.DataBind(); } catch (Exception ex) { } }