private string selectState()
{
DataTable dt = new DataTable();
dt = (DataTable)statebal.getData();
return(ConvertToJason(dt));
}
protected void dropCountry_SelectedIndexChanged(object sender, EventArgs e)
{
StateBAL StateBal=new StateBAL();
dropState.DataSource = StateBal.getData();
dropState.DataTextField = "State";
dropState.DataValueField = "stateId";
dropState.DataBind();
dropState.Items.Insert(0,new ListItem("Select State","0"));
dropState.SelectedIndex = 0;
}
protected void dropCountry_SelectedIndexChanged(object sender, EventArgs e)
{
StateBAL StateBal = new StateBAL();
dropState.DataSource = StateBal.getData();
dropState.DataTextField = "State";
dropState.DataValueField = "stateId";
dropState.DataBind();
dropState.Items.Insert(0, new ListItem("Select State", "0"));
dropState.SelectedIndex = 0;
}
private void loadFiltersData()
{
dropDownDateFilter.Items.Insert(0, new ListItem("Newest ", "0"));
dropDownDateFilter.Items.Insert(1, new ListItem("Oldest", "1"));
dropDownTypeFilter.DataSource = (DataTable)issuesbal.TypeOfIssue();
dropDownTypeFilter.DataTextField = "type";
dropDownTypeFilter.DataValueField = "typeId";
dropDownTypeFilter.DataBind();
dropDownTypeFilter.Items.Insert(0, new ListItem("All", "0"));
dropDownPartyFilter.DataSource = (DataTable)partybal.getData();
dropDownPartyFilter.DataTextField = "partyName";
dropDownPartyFilter.DataValueField = "partyId";
dropDownPartyFilter.DataBind();
dropDownPartyFilter.Items.Insert(0, new ListItem("All Party", "0"));
dropDownStateFilter.DataSource = (DataTable)statebal.getData();
dropDownStateFilter.DataTextField = "state";
dropDownStateFilter.DataValueField = "stateId";
dropDownStateFilter.DataBind();
dropDownStateFilter.Items.Insert(0, new ListItem("All State", "0"));
}
