Grid view Edit Item template

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Text;
using System.Net;
using System.Configuration;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.WebControls.Expressions;

public partial class Admin_view_record_demo : System.Web.UI.Page
{

    Class1 cls;
    

    protected void Page_Load(object sender, EventArgs e)
    {

        cls = new Class1();
        if (!Page.IsPostBack)
        {
            
            this.bind_grd1();
        }
    }



    protected void DownloadFile(object sender, EventArgs e)
    {
        string filePath = (sender as LinkButton).CommandArgument;
        Response.ContentType = ContentType;
        Response.AppendHeader("Content-Disposition", "attachment; filename=" + Path.GetFileName(filePath));
        Response.WriteFile(filePath);
        Response.End();
    }



    protected void bind_grd1()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["constring"]);
        SqlCommand cmd = new SqlCommand();
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "select_grid_demo";
        cmd.Connection = con;
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        grd1.DataSource = ds;
        grd1.DataBind();

    }
    protected void grd1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        grd1.EditIndex = e.NewEditIndex;
        this.bind_grd1();
    }
    protected void grd1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string admn_cmmnt=(grd1.Rows[e.RowIndex].FindControl("t1") as TextBox).Text;
        string aprORrjct = (grd1.Rows[e.RowIndex].FindControl("drpAOR_1") as DropDownList).SelectedItem.Value;
        string j_ID = grd1.DataKeys[e.RowIndex].Value.ToString();
        string strConnString = ConfigurationManager.ConnectionStrings["constring"].ConnectionString;
        using (SqlConnection con1 = new SqlConnection(strConnString))
        {
            string query1 = "update Admin_Added_Details set Admin_Comment=@Admin_Comment1,ApprovedORrejected=@ApprovedORrejected1 where ID=@ID1";
            using (SqlCommand cmd2 = new SqlCommand(query1))
            {
                cmd2.Connection = con1;
                cmd2.Parameters.AddWithValue("@Admin_Comment1", admn_cmmnt);
                cmd2.Parameters.AddWithValue("@ApprovedORrejected1",aprORrjct);
                cmd2.Parameters.AddWithValue("@ID1",j_ID);
                con1.Open();
                cmd2.ExecuteNonQuery();
                con1.Close();
            }
        }

         
    }
    
    protected void grd1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        grd1.EditIndex = -1;
        bind_grd1();
    }




    protected void grd1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow && grd1.EditIndex==e.Row.RowIndex)
        {
                DropDownList ddrrpp = (DropDownList)e.Row.FindControl("drpAOR_1");
                string query = "select ApprovedORrejected from approved_OR_rejected ";
                SqlCommand cmd2 = new SqlCommand(query);
                ddrrpp.DataSource = GetData(cmd2);
                ddrrpp.DataTextField = "ApprovedORrejected";
                ddrrpp.DataValueField = "ApprovedORrejected"; 
                ddrrpp.DataBind();
                ddrrpp.Items.FindByValue((e.Row.FindControl("LL0") as Label).Text).Selected = true;
                 
            }
        
    }


    private DataTable GetData(SqlCommand cmd2)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["constring"]);
        //string strr = ConfigurationManager.ConnectionStrings["constring"].ConnectionString;
        //using (SqlConnection conn = new SqlConnection(strr))
        //{
            using (SqlDataAdapter ssda = new SqlDataAdapter())
            {
                cmd2.Connection = con;
                ssda.SelectCommand = cmd2;
                using (DataTable ddt = new DataTable())
                {
                    ssda.Fill(ddt);
                    return ddt;
                }


            //}
        }
    }


     
}