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)
{
}
}