public void FillState()
{
DataTable dt = new DataTable();
GetStateTableAdapter dv = new GetStateTableAdapter();
dt = dv.GetDataBy();
State_ddl.DataSource = dt;
State_ddl.DataValueField = "StateID";
State_ddl.DataTextField = "StateName";
State_ddl.DataBind();
ListItem li = new ListItem("--select---", "-1");
State_ddl.Items.Insert(0, li);
}
public void FillElectionState()
{
try
{
GetStateTableAdapter St = new GetStateTableAdapter();
DataTable dt = new DataTable();
dt = St.GetElectionState();
State_ddl.DataSource = dt;
State_ddl.DataValueField = "StateID";
State_ddl.DataTextField = "StateName";
State_ddl.DataBind();
ListItem li = new ListItem("---select---", "-1");
State_ddl.Items.Insert(0, li);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Repeated Election are taking place in same state..!.');window.location='Welcome2.aspx';", true);
}
}