Edit update and delete from grid view in asp.net

Question

5.00/5 (1 vote)

See more:

SQL-Server-2008

, +

Hello

I am trying to edit update and delete in grid view. My code is as follows.
Id is auto incremental.
But now update and delete is not working please help.

C#

public partial class MainTable : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);

    protected void Page_Load(object sender, EventArgs e)
    {
        //SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
        if (!IsPostBack)
        {
            bind();
        }
    }

    protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
    {

    }

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        GridViewRow row=(GridViewRow)GridView1.Rows[e.RowIndex];
        Label lbldeleteid = (Label)row.FindControl("lblID");
        conn.Open();
        SqlCommand cmd = new SqlCommand("SELECT * FROM tbl_SqlImage", conn);
        cmd.ExecuteNonQuery();
        conn.Close();
        bind();



    }
    public void bind()
    {

        conn.Open();
        SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM tbl_SqlImage", conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "emp");
        GridView1.DataSource = ds.Tables[0];
        GridView1.DataBind();
        conn.Close();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        bind();
        //GridView1.DataBind();
    }

    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
        Label lblID = (Label)row.FindControl("lblID");
        TextBox textName = (TextBox)row.FindControl("txtName");
        TextBox textDesc = (TextBox)row.FindControl("txtDesc");
        TextBox textImage = (TextBox)row.FindControl("txtImage");
        TextBox textActive = (TextBox)row.FindControl("txtActive");
        TextBox textCreatedBy = (TextBox)row.FindControl("txtCreatedBy");
        TextBox textCreatedDate = (TextBox)row.FindControl("txtCreatedDate");
        GridView1.EditIndex = -1;
        conn.Open();
        SqlCommand cmd = new SqlCommand("SELECT * FROM tbl_SqlImage", conn);
        cmd.ExecuteNonQuery();
        conn.Close();
        bind();
        //GridView1.DataBind();

    }



    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        bind();

    }

    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
         GridView1.EditIndex = -1;
         bind();
    }



}

Please help what's wrong with the code.
Please help.

Posted 20-Jun-12 23:17pm

Nikil0012

Updated 20-Jun-12 23:28pm

Vani Kulkarni

v3

Add a Solution

Comments

Vani Kulkarni 21-Jun-12 5:26am

What is the error you are getting?

Code 89 21-Jun-12 5:39am

wat u gettin??

[no name] 21-Jun-12 5:43am

in update and delete query is not right.

Code 89 21-Jun-12 5:46am

tel me d error u getttin

Nikil0012 21-Jun-12 6:15am

Hello sir/madam

My new query is this,
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
Label lblID = (Label)row.FindControl("lblID");

TextBox textName = (TextBox)row.FindControl("txtName");
TextBox textDesc = (TextBox)row.FindControl("txtDesc");
TextBox textImage = (TextBox)row.FindControl("txtImage");
TextBox textActive = (TextBox)row.FindControl("txtActive");
TextBox textCreatedBy = (TextBox)row.FindControl("txtCreatedBy");
TextBox textCreatedDate = (TextBox)row.FindControl("txtCreatedDate");
GridView1.EditIndex = -1;
conn.Open();

//SqlCommand cmd = new SqlCommand("update emp set marks=" + textmarks.Text + " , name='" + textname.Text + "' where rowid=" + lbl.Text + "", conn);
SqlCommand cmd = new SqlCommand("UPDATE tbl_SqlImage set Name=" + textName.Text + " , Description='" + textDesc.Text + " , Image='" + textImage.Text + " , Active='" + textActive.Text + " , CreatedBy='" + textCreatedBy.Text + " , CreatedDate='" + textCreatedDate.Text + "' where ID=" + lblID.Text + "", conn);

cmd.ExecuteNonQuery();
conn.Close();
bind();
//GridView1.DataBind();

Now i am getting an error object reference not set to an instance of the object.

i wnat to know also that createddate.text is write or i have to convert it.

[no name] 21-Jun-12 8:22am

please check the start and end quotes in the query. like Description='" + textDesc.Text + "'

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mits Machhi · Answer 1 · 2012-06-20T23:46:00

use this :

 protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            GridViewRow row=(GridViewRow)GridView1.Rows[e.RowIndex];
            Label lbldeleteid = (Label)row.FindControl("lblID");
            conn.Open();
            SqlCommand cmd = new SqlCommand("delete * FROM tbl_SqlImage where id_field='"+lbldeleteid+"'", conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            bind();
 

 
        }



 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
            Label lblID = (Label)row.FindControl("lblID");
            TextBox textName = (TextBox)row.FindControl("txtName");
            TextBox textDesc = (TextBox)row.FindControl("txtDesc");
            TextBox textImage = (TextBox)row.FindControl("txtImage");
            TextBox textActive = (TextBox)row.FindControl("txtActive");
            TextBox textCreatedBy = (TextBox)row.FindControl("txtCreatedBy");
            TextBox textCreatedDate = (TextBox)row.FindControl("txtCreatedDate");
            GridView1.EditIndex = -1;
            conn.Open();
            SqlCommand cmd = new SqlCommand("update tablename set name='"+textname.Text+"',desc='"+txtdesc.Text+"' where id='"+lblID+"', conn); //  Here set Update Query to update the Field.
            cmd.ExecuteNonQuery();
            conn.Close();
            bind();
            //GridView1.DataBind();
            
        }


this will help you..........

Prosan · Answer 2 · 2012-06-20T23:47:00

in command write update and delete query which will update the data. u have simply write select query.

C#

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            GridViewRow row=(GridViewRow)GridView1.Rows[e.RowIndex];
            Label lbldeleteid = (Label)row.FindControl("lblID");
            conn.Open();
            SqlCommand cmd = new SqlCommand("delete FROM tbl_SqlImage where id="+ lbldeleteid.Text, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            bind();
 
        }

in update write

C#

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {


SqlCommand cmd = new SqlCommand("update  tbl_SqlImage set Name='"+ textName.text +"' where id="+ lbldeleteid.Text, conn);
}

for more look in this article[^]

Jαved · Answer 3 · 2012-06-21T01:23:00

Solution 3

Hi,
Go through this link-
gridview-sqldatasource-insert-edit-delete.html[^]

Posted 21-Jun-12 1:23am

Jαved

Edit update and delete from grid view in asp.net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0