row update button coding in grid view for asp.net c#

Nitin Sharma

i have use this part of code for update a row in gridview in c# asp.net

in my past project it was worked but now it is not working can anybody help me in this i have pase my sql query, asp gridview code and my logical code too

please advise me how to update a row in gridview

SQL Query

create database test

use test

create table gridview(id int identity(1,1),ename varchar(50),city varchar(50))

insert into gridview values('nitin','hisar')

insert into gridview values('deepak','gwalior')

insert into gridview values('raman','delhi')

select*from gridview

update gridview set ename='nitin sharma', city='haryana' where id=1

default.aspx

AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" DataKeyNames="id"

onrowcancelingedit="GridView1_RowCancelingEdit"

onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"

onrowupdating="GridView1_RowUpdating">

default.aspx.cs

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);

string name=GridView1.Rows[e.RowIndex].Cells[0].Text;

string city=GridView1.Rows[e.RowIndex].Cells[1].Text;

if (con.State == ConnectionState.Closed)

{

con.Open();

}

SqlCommand cmd = new SqlCommand("update gridview set ename='"+name+"', city='"+city+"' where id='"+id+"'", con);

cmd.ExecuteNonQuery();

con.Close();

GridView1.DataBind();

display();

}

please help me

8 Replies

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

Nitin Sharma12y ago
i have already seen this coding but this coding display an errer
"Object reference not set to an instance of an object."
but my used code work but output is wrong can you please modify my code all details i have posted , its very urgent for me
any body please help me
0
Munesh Sharma12y ago
I am giving you this link see here you will understand better Link
0
Nitin Sharma12y ago
is anybody help me for this how we can make this coding workable
SQL Query
create database test
use test
create table gridview(id int identity(1,1),ename varchar(50),city varchar(50))
insert into gridview values('nitin','hisar')
insert into gridview values('deepak','gwalior')
insert into gridview values('raman','delhi')
select*from gridview
update gridview set ename='nitin sharma', city='haryana' where id=1

default.aspx
AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" DataKeyNames="id"
onrowcancelingedit="GridView1_RowCancelingEdit"
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"
onrowupdating="GridView1_RowUpdating">

default.aspx.cs
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
string name=GridView1.Rows[e.RowIndex].Cells[0].Text;
string city=GridView1.Rows[e.RowIndex].Cells[1].Text;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("update gridview set ename='"+name+"', city='"+city+"' where id='"+id+"'", con);
cmd.ExecuteNonQuery();
con.Close();
GridView1.DataBind();
display();
}
please help me
0
Nitin Sharma12y ago
this code show an error on second line
"Object reference not set to an instance of an object."
0
Munesh Sharma12y ago
You use this Code

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int id = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString());
string name = gvDetails.DataKeys[e.RowIndex].Values["Name"].ToString();
TextBox city = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("city");

con.Open();
SqlCommand cmd = new SqlCommand("update Employee_Details set City='" + city.Text +"',name='" + name.Text + "' where UserId=" + userid, con);
cmd.ExecuteNonQuery();
con.Close();
lblresult.ForeColor = Color.Green;
lblresult.Text = username + " Details Updated successfully";
gvDetails.EditIndex = -1;
BindEmployeeDetails();
}
0
Nitin Sharma12y ago
no no error message , its working but value not updated even previous value has been removed and column become empty

Dear Abhey
given link coding was not working
0
Abhay Shanker12y ago
Please check below link

http://devilswork.wordpress.com/2009/03/27/gridview-row-edit-delete-and-update/
0
Lakshmanan Sethu Sankaranarayan12y ago
Hi You getting any error message?
0