protected void User_grd_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        DataRowView drv = e.Row.DataItem as DataRowView;

        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            if ((e.Row.RowState & DataControlRowState.Edit) > 0)
            {
                DropDownList         dp = (DropDownList)e.Row.FindControl("Stategrd_ddl");
                DataTable            dt = new DataTable();
                GetStateTableAdapter dv = new GetStateTableAdapter();
                dt                = dv.GetDataBy();
                dp.DataSource     = dt;
                dp.DataValueField = "StateID";
                dp.DataTextField  = "StateName";
                dp.DataBind();
                ListItem lit = new ListItem("--select---", "-1");
                dp.Items.Insert(0, lit);
            }
            if ((e.Row.RowState & DataControlRowState.Edit) > 0)
            {
                DropDownList         Party = (DropDownList)e.Row.FindControl("Party_ddl");
                DataTable            pt    = new DataTable();
                GetPartyTableAdapter PT    = new GetPartyTableAdapter();
                pt = PT.GetParty();
                Party.DataSource     = pt;
                Party.DataValueField = "PartyID";
                Party.DataTextField  = "PartyName";
                Party.DataBind();
                ListItem lit = new ListItem("--select---", "-1");
                Party.Items.Insert(0, lit);
            }
        }
    }
    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);
        }
    }