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);
    }