public void BindGrid()
        {
            EmployeOperation obj = new EmployeOperation();

            GridView1.DataSource = obj.GetEmpList();
            GridView1.DataBind();
        }
        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow && GridView1.EditIndex == e.Row.RowIndex)
            {
                DropDownList ddlgender = (DropDownList)e.Row.FindControl("ddlgender");

                string           cmd = "spGettblGender";
                EmployeOperation obj = new EmployeOperation();

                ddlgender.DataSource     = obj.GetData(cmd);
                ddlgender.DataValueField = "Gender";
                ddlgender.DataTextField  = "Gender";
                ddlgender.DataBind();
                ddlgender.Items.FindByValue((e.Row.FindControl("lblgender") as Label).Text).Selected = true;
                DropDownList ddldept = (DropDownList)e.Row.FindControl("ddldept");
                string       cmd1    = "spGettbldes";
                ddldept.DataSource     = obj.GetData(cmd1);
                ddldept.DataValueField = "DeptName";
                ddldept.DataTextField  = "DeptName";
                ddldept.DataBind();
                // ddldept.Items.FindByValue((e.Row.FindControl("lblDept") as Label).Text).Selected = true;
            }
        }