public void BindProcess()
    {
        GetElectionProcessTableAdapter gt = new GetElectionProcessTableAdapter();
        DataTable dt = new DataTable();

        dt = gt.GetElectionProcess();
        Electionprocess_rpt.DataSource = dt;
        Electionprocess_rpt.DataBind();
    }
    public void BindProcess()
    {
        GetElectionSummaryTableAdapter ES = new GetElectionSummaryTableAdapter();
        DataTable dt = new DataTable();

        dt = ES.GetElectionSummary();
        Electionprocess_rpt.DataSource = dt;
        Electionprocess_rpt.DataBind();
    }
    public void BindProcess()
    {
        Upcoming_ElectionsTableAdapter UE = new Upcoming_ElectionsTableAdapter();
        DataTable dt = new DataTable();

        dt = UE.GetUpcomingElection();
        Electionprocess_rpt.DataSource = dt;
        Electionprocess_rpt.DataBind();
    }
    protected void GetVote_btn_Click(object sender, EventArgs e)
    {
        StateSelect_pnl.Visible = false;
        StateWise_pnl.Visible   = true;
        string   dateString            = Sdate_txt.Text;
        string   format                = "dd/mm/yyyy";
        DateTime dateTime              = DateTime.ParseExact(dateString, format, CultureInfo.InvariantCulture);
        string   strNewDate            = dateTime.ToString("yyyy-dd-mm");
        GetVotesByStateTableAdapter VS = new GetVotesByStateTableAdapter();
        DataTable dt = new DataTable();

        dt = VS.GetVotesByState(State_ddl.SelectedValue, strNewDate);
        Electionprocess_rpt.DataSource = dt;
        Electionprocess_rpt.DataBind();
    }