update the gv

HI EVERY ONE,
I palce a delete button bellow the gv. if user checks on checkbox then that row will become updatable format. Now i want to update those details in the database. plz help me soon. if any one doesn't understand the prob plz ask me again. i will explain in details.

Friend ,

Here is Sample Code i have Coded for you !!

just Take a Look at Attachment I have attached Example Project Files

protected void Page_Load(object sender, EventArgs e)
    {
        // Load the Data 
        if (!IsPostBack)
        {
            SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
            con.Open();
 
            SqlCommand comm = new SqlCommand("select * from UserData", con);
            GridView1.DataSource = comm.ExecuteReader();
            DataBind();
            con.Close();
        }
    }
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow r in GridView1.Rows)
        {
            if (((CheckBox)r.Cells[0].FindControl("CheckBox1")).Checked == true)
            {
                //Take Key Value From Row And Delete it From Database 
                string username = r.Cells[1].Text;
                //Delete it 
                SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
                con.Open();
 
                SqlCommand comm = new SqlCommand("delete from userdata where username='"+username+"'", con);
                comm.ExecuteNonQuery();
                con.Close(); 
            }
        }
        Response.Redirect("Default.aspx");
    }

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel16y ago
Accepted answer
Friend ,

Here is Sample Code i have Coded for you !!

just Take a Look at Attachment I have attached Example Project Files

protected void Page_Load(object sender, EventArgs e)

    {

        // Load the Data

        if (!IsPostBack)

        {

            SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");

            con.Open();

            SqlCommand comm = new SqlCommand("select * from UserData", con);

            GridView1.DataSource = comm.ExecuteReader();

            DataBind();

            con.Close();

        }

    }

    protected void btnDelete_Click(object sender, EventArgs e)

    {

        foreach (GridViewRow r in GridView1.Rows)

        {

            if (((CheckBox)r.Cells[0].FindControl("CheckBox1")).Checked == true)

            {

                //Take Key Value From Row And Delete it From Database

                string username = r.Cells[1].Text;

                //Delete it

                SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");

                con.Open();

                SqlCommand comm = new SqlCommand("delete from userdata where username='"+username+"'", con);

                comm.ExecuteNonQuery();

                con.Close();

            }

        }

        Response.Redirect("Default.aspx");

    }
Lalit M16y ago
Accepted answer
You will help this article

http://aspalliance.com/1125_Dynamically_Templated_GridView_with_Edit_Delete_and_Insert_Options.all

Thanks hemanth hemanth....