private void GetStates(string Location) { try { int locationid = 0; if (Location.Trim() == "INDG" || Location.Trim() == "INBH") { locationid = 1; } else { locationid = 2; } Attendance.BAL.Report obj = new Report(); DataTable dt = obj.GetAllStates(locationid); ddlEmpState.DataSource = dt; ddlEmpState.DataTextField = "StateName"; ddlEmpState.DataValueField = "StateID"; ddlEmpState.DataBind(); ddlCn1State.DataSource = dt; ddlCn1State.DataTextField = "StateName"; ddlCn1State.DataValueField = "StateID"; ddlCn1State.DataBind(); ddlCn2State.DataSource = dt; ddlCn2State.DataTextField = "StateName"; ddlCn2State.DataValueField = "StateID"; ddlCn2State.DataBind(); ddlCn3State.DataSource = dt; ddlCn3State.DataTextField = "StateName"; ddlCn3State.DataValueField = "StateID"; ddlCn3State.DataBind(); } catch (Exception ex) { } }