Asp.net insert, Edit, update, delete data in gridview

By: Suresh Dasari Feb 9, 2011

Introduction:

In this article I will explain how to insert, edit, update and delete data in gridview using asp.net.

Description:

I have one gridview I need to write code to insert data into gridview after that I need to edit that gridview data and update it and if I want to delete the record in grdview we need to delete record simply by click on delete button of particular row to achieve these functionalities I have used some of gridview events those are

1 1) Onrowcancelingedit

2 2) Onrowediting

3 3) Onrowupdating

4 4) Onrowcancelingedit

5 5) Onrowdeleting

By Using above griview events we can insert, edit, update and delete the data in gridview. My Question is how we can use these events in our coding before to see those details first design table in database and give name Employee_Details

ColumnName	DataType
UserId	Int(set identity property=true)
UserName	varchar(50)
City	varchar(50)
Designation	varchar(50)

After completion table creation design aspx page like this

<title>Untitled Page</title>

.Gridview

{

font-family:Verdana;

font-size:10pt;

font-weight:normal;

color:black;

}

</style>

</head>

<body>

<div>

<asp:GridView ID="gvDetails" DataKeyNames="UserId,UserName" runat="server"

AutoGenerateColumns="false" CssClass="Gridview" HeaderStyle-BackColor="#61A6F8"

ShowFooter="true" HeaderStyle-Font-Bold="true" HeaderStyle-ForeColor="White"

onrowcancelingedit="gvDetails_RowCancelingEdit"

onrowdeleting="gvDetails_RowDeleting" onrowediting="gvDetails_RowEditing"

onrowupdating="gvDetails_RowUpdating"

onrowcommand="gvDetails_RowCommand">

<asp:TemplateField>

<asp:ImageButton ID="imgbtnUpdate" CommandName="Update" runat="server" ImageUrl="~/Images/update.jpg" ToolTip="Update" Height="20px" Width="20px" />

<asp:ImageButton ID="imgbtnCancel" runat="server" CommandName="Cancel" ImageUrl="~/Images/Cancel.jpg" ToolTip="Cancel" Height="20px" Width="20px" />

</EditItemTemplate>

<asp:ImageButton ID="imgbtnEdit" CommandName="Edit" runat="server" ImageUrl="~/Images/Edit.jpg" ToolTip="Edit" Height="20px" Width="20px" />

<asp:ImageButton ID="imgbtnDelete" CommandName="Delete" Text="Edit" runat="server" ImageUrl="~/Images/delete.jpg" ToolTip="Delete" Height="20px" Width="20px" />

</ItemTemplate>

<asp:ImageButton ID="imgbtnAdd" runat="server" ImageUrl="~/Images/AddNewitem.jpg" CommandName="AddNew" Width="30px" Height="30px" ToolTip="Add new User" ValidationGroup="validaiton" />

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="UserName">

<asp:Label ID="lbleditusr" runat="server" Text='<%#Eval("Username") %>'/>

</EditItemTemplate>

<asp:Label ID="lblitemUsr" runat="server" Text='<%#Eval("UserName") %>'/>

</ItemTemplate>

<asp:TextBox ID="txtftrusrname" runat="server"/>

<asp:RequiredFieldValidator ID="rfvusername" runat="server" ControlToValidate="txtftrusrname" Text="*" ValidationGroup="validaiton"/>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="City">

<asp:TextBox ID="txtcity" runat="server" Text='<%#Eval("City") %>'/>

</EditItemTemplate>

<asp:Label ID="lblcity" runat="server" Text='<%#Eval("City") %>'/>

</ItemTemplate>

<asp:TextBox ID="txtftrcity" runat="server"/>

<asp:RequiredFieldValidator ID="rfvcity" runat="server" ControlToValidate="txtftrcity" Text="*" ValidationGroup="validaiton"/>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Designation">

<asp:TextBox ID="txtDesg" runat="server" Text='<%#Eval("Designation") %>'/>

</EditItemTemplate>

<asp:Label ID="lblDesg" runat="server" Text='<%#Eval("Designation") %>'/>

</ItemTemplate>

<asp:TextBox ID="txtftrDesignation" runat="server"/>

<asp:RequiredFieldValidator ID="rfvdesignation" runat="server" ControlToValidate="txtftrDesignation" Text="*" ValidationGroup="validaiton"/>

</FooterTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

<div>

<asp:Label ID="lblresult" runat="server"></asp:Label>

</div>

</form>

</body>

</html>

Now add the following namespaces in codebehind

using System;

using System.Data;

using System.Data.SqlClient;

using System.Drawing

After that write the following code

SqlConnection con = new SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindEmployeeDetails();

}

protected void BindEmployeeDetails()

{

con.Open();

SqlCommand cmd = new SqlCommand("Select * from Employee_Details", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

con.Close();

if (ds.Tables[0].Rows.Count > 0)

{

gvDetails.DataSource = ds;

gvDetails.DataBind();

}

else

{

ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());

gvDetails.DataSource = ds;

gvDetails.DataBind();

int columncount = gvDetails.Rows[0].Cells.Count;

gvDetails.Rows[0].Cells.Clear();

gvDetails.Rows[0].Cells.Add(new TableCell());

gvDetails.Rows[0].Cells[0].ColumnSpan = columncount;

gvDetails.Rows[0].Cells[0].Text = "No Records Found";

}

protected void gvDetails_RowEditing(object sender, GridViewEditEventArgs e)

{

gvDetails.EditIndex = e.NewEditIndex;

BindEmployeeDetails();

}

protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

int userid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString());

string username = gvDetails.DataKeys[e.RowIndex].Values["UserName"].ToString();

TextBox txtcity = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtcity");

TextBox txtDesignation = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtDesg");

con.Open();

SqlCommand cmd = new SqlCommand("update Employee_Details set City='" + txtcity.Text + "',Designation='" + txtDesignation.Text + "' where UserId=" + userid, con);

cmd.ExecuteNonQuery();

con.Close();

lblresult.ForeColor = Color.Green;

lblresult.Text = username + " Details Updated successfully";

gvDetails.EditIndex = -1;

BindEmployeeDetails();

}

protected void gvDetails_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

gvDetails.EditIndex = -1;

BindEmployeeDetails();

}

protected void gvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

int userid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Values["UserId"].ToString());

string username = gvDetails.DataKeys[e.RowIndex].Values["UserName"].ToString();

con.Open();

SqlCommand cmd = new SqlCommand("delete from Employee_Details where UserId=" + userid, con);

int result = cmd.ExecuteNonQuery();

con.Close();

if (result == 1)

{

BindEmployeeDetails();

lblresult.ForeColor = Color.Red;

lblresult.Text = username + " details deleted successfully";

}

protected void gvDetails_RowCommand(object sender, GridViewCommandEventArgs e)

{

if(e.CommandName.Equals("AddNew"))

{

TextBox txtUsrname = (TextBox)gvDetails.FooterRow.FindControl("txtftrusrname");

TextBox txtCity = (TextBox)gvDetails.FooterRow.FindControl("txtftrcity");

TextBox txtDesgnation = (TextBox) gvDetails.FooterRow.FindControl("txtftrDesignation");

con.Open();

SqlCommand cmd =

new SqlCommand(

"insert into Employee_Details(UserName,City,Designation) values('" + txtUsrname.Text + "','" +

txtCity.Text + "','" + txtDesgnation.Text + "')", con);

int result= cmd.ExecuteNonQuery();

con.Close();

if(result==1)

{

BindEmployeeDetails();

lblresult.ForeColor = Color.Green;

lblresult.Text = txtUsrname.Text + " Details inserted successfully";

}

else

{

lblresult.ForeColor = Color.Red;

lblresult.Text = txtUsrname.Text + " Details not inserted";

}

Demo

Download sample code attached

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS

Subscribe by Email

250 comments :

«Oldest ‹Older 1 – 200 of 250 Newer› Newest»

Anonymous said...: Good one it helped a lot; April 29, 2011 at 11:06 AM
naresh said...: hey really awesome..can i ve ur number..i feel vry proud to ve ur number in my mobile..awesome dude..keep helping..; July 5, 2011 at 12:53 AM
* MOON * said...: Can i know the explanation of each of the tag used in above example..; July 6, 2011 at 10:41 PM
Anonymous said...: Thanks Boss, this is best site for IT Languages and database.; August 24, 2011 at 4:58 AM
K. Mohan Kumar said...: Good start suresh...Your articles are excellent!!!! Great stuff...; November 22, 2011 at 10:21 PM
Anupam said...: really helpfull.Its working quit faster.

thanx for sharing; November 23, 2011 at 3:35 AM
Phalguni Bhuyan said...: excellent one but while deleting a record the confirmation is not cumming which is written using JavaScript function; December 6, 2011 at 6:08 AM
Phalguni Bhuyan said...: Can you give your number please; December 6, 2011 at 6:10 AM
Amar Prasad said...: Hi sir,
i have 3 buttons Add/Update/Delete in my Grid View,..Plz, sir can u say me how to ADD/UPDATE/DELETE images in Grid View...

Plz,mail me on tech.amarprasad@gmail.com; January 10, 2012 at 4:20 AM
sunitha said...: i can't understand how to insert,update and delete in gridview .please explain briefly.; January 23, 2012 at 10:23 PM
sunitha said...: gud mrng sir,i want this as in 3-tier.please explain sir; January 24, 2012 at 7:44 PM
Anonymous said...: thanx ... its a relaay nice post; January 26, 2012 at 2:48 AM
Vicky Surya said...: hi sir, in the above program updating and deleting is not working. mainly that Convert.Int32 line shows error due to invalid method arguments. please found me a solution.; February 2, 2012 at 4:28 AM
khusboo said...: i got problem in con.open() plz help me my mind is gng to blast...plzzzzzzz help me soon...; February 6, 2012 at 4:22 AM
Shubham Vijay said...: very useful..; February 22, 2012 at 10:21 PM
Bill said...: Excellent! It was so good I'm now using it! Thank you for sharing!; March 2, 2012 at 10:22 AM
Bill said...: If you having a problem at con.open() it is because there is no database. Right click on App_Data, and add new item . SQL Server Database and name it anything you want. Add a table, and add 4 columns, called
UserID int (make this primary key and also make it auto increment by adjusting the column properties to Identity Specification to YES)
and three others called UserName, City, Designation (all strings or nchar(40))
Save this table as Employee_Details. Right click on the database and select properties. Copy the whole connection string and paste into line #17 where the string starts with Data Source=. When you start the sample it should run!; March 2, 2012 at 10:34 AM
Unknown said...: best one sir really very helpfull sir.
And thanks for sharing
God bless you.; March 4, 2012 at 10:18 PM
Anonymous said...: First of all thanks,
iam running the Project i got one Error that is:

Object reference not set to an instance of an object.

in the Update and Delete button

plz give me Suggession For this....Iam waiting for Replay

Thank You,
Yours Faithfully,
Basha; March 24, 2012 at 7:05 AM
ketan said...: hellloooo..
i need "drag and drop items from one list to another list " code

yr other code very usefull to me.its so eazy....
plz.... send me on my email id"ketan_coolboy@ymail.com"; March 30, 2012 at 1:39 PM
ann said...: Can i include an imageicon in the gridview columns; April 11, 2012 at 4:28 AM
Singamalai said...: Hi sir, my name is singamalai.
in the above code
i'm getting the default value instead of
updated value in TextBox txtcity,

If anybody knows, please mail the code to simhamalai@yahoo.com; April 11, 2012 at 11:22 PM
Anonymous said...: Great...
But sir, I want to hide all the information from gridview after saved.
When serach then it will come up. So please help me. My email-id: rd.666@rediffmail.com

Thank you Sir.; April 13, 2012 at 7:00 AM
Anonymous said...: Thanks,Was confusing before this one but now clear as i was did this earlier but through direct DSN.
Issac.; April 23, 2012 at 11:35 AM
Srinivasa said...: Very very Thanks suresh . freshers or exp helpfull to this website; April 30, 2012 at 7:38 AM
dinesh kumar said...: Im facing error like this:::(Object reference not set to an instance of an object.)plz help me sir.; May 7, 2012 at 5:51 AM
ganesh0025 said...: else
{
lblresult.ForeColor = Color.Red;
lblresult.Text = txtUsrname.Text + " Details not inserted";
}

above code is not working properly plz check ot naresh..
rply me below email id.
my mail id:
ganesh0025@gmail.com; May 14, 2012 at 7:44 AM
benita said...: hhkjhjk; May 23, 2012 at 12:40 AM
Unknown said...: Gracias, muy bueno.; May 25, 2012 at 8:38 AM
bhuvanashree venkatesan said...: i don have any words bro. u are a DOTNET-GOD; June 1, 2012 at 5:53 AM
Anonymous said...: really nice work; June 1, 2012 at 6:46 AM
anusha said...: only insert in working...when click delete it will go to row command..pls help me out; June 2, 2012 at 3:12 AM
anusha said...: anyone pls help me..; June 2, 2012 at 3:13 AM
anusha said...: void grid()
{
SqlCommand cmd = new SqlCommand("Select * from TEST1", cn);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
cn.Close();
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
GridView1.DataSource = ds;
GridView1.DataBind();
int columncount = GridView1.Rows[0].Cells.Count;
GridView1.Rows[0].Cells.Clear();
GridView1.Rows[0].Cells.Add(new TableCell());
GridView1.Rows[0].Cells[0].ColumnSpan = columncount;
GridView1.Rows[0].Cells[0].Text = "No Records Found";
}
}

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
TextBox t1 = (TextBox)GridView1.FooterRow.FindControl("TextBox1");
TextBox t2 = (TextBox)GridView1.FooterRow.FindControl("TextBox2");
TextBox t3 = (TextBox)GridView1.FooterRow.FindControl("TextBox3");
cn.Open();

cmd = new SqlCommand("insert into TEST1(name,email,age) values('" + t1.Text + "','" + t2.Text + "','" + t3.Text + "')", cn);
cmd.ExecuteNonQuery();
Response.Write("inserted");
grid();
cn.Close();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string Name = GridView1.DataKeys[e.RowIndex].Values["name"].ToString();
cn.Open();
cmd = new SqlCommand("delete from TEST1 where name="+Name, cn);

//cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = GridView1.Rows[e.RowIndex].Cells[2].Text;
cmd.ExecuteNonQuery();
Response.Write("deleted");
grid();
cn.Close();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
grid();
}; June 2, 2012 at 3:14 AM
anusha said...: pls help me my above code is not working properly in while deleting; June 2, 2012 at 3:15 AM
Suresh Dasari said...: @Anusha...
Pls check whether you gave CommandName="Delete" for your delete button or not.; June 2, 2012 at 9:00 AM
Yagnesh Dixit said...: Great work Suresh.... I dont know if I will really use it or not but I like the tidy and well structured and ready to use code of yours... Keep going......; July 3, 2012 at 10:25 PM
Anonymous said...: good yar excelent...........; July 13, 2012 at 12:28 AM
Unknown said...: vamsi
------
error
------
Object reference not set to an instance of an object

soluction
---------
once check web.config page; July 14, 2012 at 5:55 PM
Santhosh Sanmugam said...: I am always preferring you site only boss....; July 17, 2012 at 1:38 AM
Shruthi said...: Hi,
A very helpful post.. It was really easy to understand.. Thanks a lot..:); July 19, 2012 at 9:44 AM
RAJEEV RANJAN said...: hello sir thank you for this very very helpfull tutorials its work fine .but i have a problem

when i insrted string value in UserId then following error displayed at the time of update or delete a record

"Conversion failed when converting the varchar value 'FI' to data type int."

and i have changed the data type of useris to varchar also.
plz help me sir; July 24, 2012 at 10:27 PM
Suresh Dasari said...: @Rajeev Ranjan...
That problem because of you mentioned column datatype as int and sending string values to that column. i think you forgot to change your stored procedure datatype int to varchar check it once...; July 24, 2012 at 10:33 PM
RAJEEV RANJAN said...: sir i have created a table like this
carete table cat1(
category_code varchar(10),
category_name varchar(50),
category_short_desc varchar
)

insert into cate values('FI','Fitness','fitness')
insert into cate values('IN','Indoor Sports','Sports')

i have aply DataKeyName in category_code column

here is code for delete the record
protected void gvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string code = Convert.ToString(gvDetails.DataKeys[e.RowIndex].Value.ToString());
con.Open();
SqlCommand cmd = new SqlCommand("delete from cat1 where category_code=" + code, con);
int result = cmd.ExecuteNonQuery();
con.Close();
if (result == 1)
{
BindEmployeeDetails();
lblresult.ForeColor = Color.Red;
lblresult.Text = " details deleted successfully";
}
}

and the same error found at the the time of update the table ..pls help me sir; July 25, 2012 at 11:08 PM
RAJEEV RANJAN said...: i have solved my problem sir ..
thank you so much.

sir is there a sample for live search from database in asp; July 26, 2012 at 1:30 AM
Suresh Dasari said...: @Rajeev Ranjan...
Check this article http://www.aspdotnet-suresh.com/2011/12/search-records-in-gridview-and.html; July 26, 2012 at 1:32 AM
RAJEEV RANJAN said...: it is nice but i want live search like facebook search box.; July 26, 2012 at 5:32 AM
RAJEEV RANJAN said...: sir
how can i display only one row which is click for edit..bcoz the grid view of my database is so long and when i press edit for last row it wil disply in edit mode but the page will move to up so we scroll down the page where i choose for edit the row; August 1, 2012 at 3:32 AM
anee said...: this is working very fastly but i have one problm whne grid contains much record then it get scrolled ,i want that footer is going to be fixed.
so how to fix the footer in above grid plz rly sir...its urgent; August 3, 2012 at 1:20 AM
Suresh Dasari said...: @anee....
Check this link here i explained scrollable gridview with fixed header same way you can implement for your footer
http://www.aspdotnet-suresh.com/2011/11/how-to-implement-scrollable-gridview.html; August 3, 2012 at 1:31 AM
Anonymous said...: bit i want same above grid with edit ,delete.but add in footer row should be fixed.i don;t get help from link....plz rly soon; August 3, 2012 at 2:18 AM
anee said...: but i want same above grid with edit ,delete.but add in footer row should be fixed.i don;t get help from link....plz rly soon; August 3, 2012 at 2:19 AM
Santhosh Sanmugam said...: Hello Suresh,

Registration with Facebook Id in my application..

So need some help; August 8, 2012 at 12:07 AM
Anonymous said...: hey,
wen i enter data in the o/p that data store in the table using update query..... how can i solve???give me code....; August 10, 2012 at 9:48 AM
Unknown said...: Hi,
your coding is very useful. I made some modification in the above coding I feel one difficulty. That is I added a button or a dropdownlist with autopostback set as true. Initially the gridview is empty and thus "No Records Found" message is shown. When I select any item from the dropdownlist or button click an empty row with Item Template controls(edit and delete) at 1st row position by the gridview.
please give me a solution for avoiding this auto post back problem.
Thank you...; August 16, 2012 at 5:47 AM
Anonymous said...: very - very useful sir,; August 19, 2012 at 5:30 AM
Santhosha said...: This comment has been removed by the author.; August 22, 2012 at 12:34 AM
Unknown said...: really it's helpful for me; August 26, 2012 at 6:20 AM
Anonymous said...: Awesome; August 29, 2012 at 10:45 AM
Salman Rehman said...: anusha check the code using break point "Step Into"..; August 31, 2012 at 5:25 AM
vamsikrishna said...: vamsi krishna; September 7, 2012 at 12:58 AM
Anonymous said...: thanks a lot; September 15, 2012 at 3:42 AM
Unknown said...: this is a very good site I've come across,
Thank you Suresh; September 24, 2012 at 11:05 PM
Unknown said...: Wow! just posting the comment gives user google account details and link to user blog to the website. This is wonderful. How did you do this? How can I achieve this in my website? I am new to asp.net and programmer in C#. Moreover there is sign out option too. Does that make user sign out of google?; September 24, 2012 at 11:22 PM
Anonymous said...: crore of thanks to you sir...; September 26, 2012 at 2:24 AM
Unknown said...: Suresh garu your examples are soooo good, i have a small doubt,if there is in(sql data base) no of particles like name ,date, dob etc. so, my requirement is ,i need two of them only. Is it possible in Grid view. Please Post Your answer.; September 27, 2012 at 2:03 AM
Anonymous said...: while implementing this code m getng error as server is not tagged well....?help me; September 27, 2012 at 11:15 AM
Unknown said...: HI i am manjunathan I want insert,delete,update,edit,searching with gridview coding can u any one help me pls
in designing part i want to use query; September 27, 2012 at 11:38 AM
Anonymous said...: Thank You Suresh; October 2, 2012 at 8:14 PM
Anonymous said...: Thanks Boss Its Really Helpfull...May God Bless u....; October 3, 2012 at 5:12 AM
anas said...: sir,
i am getting this error when i am compiling this code
"The name 'color' does not exist in the current context "
can you help me out; October 4, 2012 at 12:44 PM
nisha said...: nice website...; October 6, 2012 at 1:49 AM
anas said...: sir ,
help me out i am waiting for your reply
i am new to .net is there any other post in which simple insert update delete operation is performed?; October 6, 2012 at 1:53 AM
Suresh Dasari said...: @anas,
i hope u forgot to add namespaces mentioned (using system.drawing) in post. Please check it once...; October 6, 2012 at 2:26 AM
Unknown said...: input string is not currect formet error occure during update and deleting .....what is the solutin..........please tell me; October 7, 2012 at 3:35 AM
Prem Arya said...: Thanks it helps me lot keep on such nice work; October 10, 2012 at 3:53 AM
anas said...: sir,
it worked out ... thnx-:); October 10, 2012 at 11:29 AM
Anonymous said...: Hi suresh,

I am satyam . Can you tell me how to access like button of Facebook to my website by using WCF and please provide the code for this; October 11, 2012 at 4:18 AM
Anonymous said...: hi i need help. when start w/o debugging i have this error
Invalid object name 'Employee_Details'
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'Employee_Details'.

Source Error:

Line 32: SqlDataAdapter da = new SqlDataAdapter(cmd);
Line 33: DataSet ds = new DataSet();
Line 34: da.Fill(ds);
Line 35: con.Close();
Line 36: if (ds.Tables[0].Rows.Count > 0)

here is my code :

public partial class _Default : System.Web.UI.Page
{
string connStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection("Data Source=SIN-L-RLIM\\SQLEXPRESS;Integrated Security=True;Initial Catalog=EmployeeDB");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindEmployeeDetails();
}
}

protected void BindEmployeeDetails()
{

con.Open();
SqlCommand cmd = new SqlCommand("Select * from Employee_Details", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0); October 15, 2012 at 1:39 AM
Anonymous said...: Suresh, I'm not an ASP developer, but was able to put an ASPX page together some time ago that does just this that you showed. It runs smoothly when under VS IDE, but when I deploy it to GoDaddy's server, it pops the following error :

Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.

I'm willing to pay for you to correct this and leave this page running fast when deployed. My e-mail is epastorejr(arr)hotmail(dot)com, please get in touch. Regards, Emilio.; October 19, 2012 at 12:15 PM
Anonymous said...: hi.. could you please give the code in vb.net; October 23, 2012 at 2:29 AM
Unknown said...: IMAGES edit/delete continously refresh after insert ing one record so its little bit disturbing please
tell me solution i used update panel but does not work another point i want enter instead of tab about navigation; October 25, 2012 at 8:57 AM
Dipak said...: Dear Sir,

I want to make a DLL which recive some information and errors from another application and display it on text file named error.txt
scenerio
------------------------------------------------
Some Information Processed and displayed

------------------------------------------------
Repeat this step Each time client Application Call this DLL; October 25, 2012 at 9:32 AM
Anonymous said...: hi suresh, how r u? whats ur contact no........
plz send ur no. on my emailID.my emailID is mantosh05@gmail.com; November 5, 2012 at 6:54 AM
Unknown said...: Hi suresh,

I have one big dought. i think u solve this problem.

I have one gridview, in grid one dropdown list, dropdown list have values after that last one control, when u click the control one popup will be show.

How to solve this problem.
Please try to this problem every one.
please share with me.

My mail id:- rajkumarse6@gmail.com; November 11, 2012 at 7:03 AM
Anonymous said...: i am raju i want to know about how to image update in gridview. please help me; November 20, 2012 at 5:40 AM
Virtual Web Solutions said...: Thanks for a really nice article.
I really enjoyed it.

Many Thanks.; November 26, 2012 at 1:40 AM
Jatin said...: This is the best... gr8 ..nice job done and very helpful for our .net juniors,hope every juniors will like this post.

Thnks & Regards,
Jatin Kashwani; November 30, 2012 at 7:55 AM
Anonymous said...: thank you very much giving good example. keep posting. http://murraliitechnos.in; November 30, 2012 at 6:18 PM
Anonymous said...: very helpful article. Thank you so much.. Keep writing this kind of article; December 10, 2012 at 2:21 AM
Anonymous said...: it's very helpful.
thnx.....; December 12, 2012 at 7:28 AM
Unknown said...: how delete row in datagridview
plz sir
code send ravisin562@gmail.com; December 13, 2012 at 2:57 AM
Retty said...: thanku very much............... you helped me a lot.............; December 17, 2012 at 8:50 PM
shanti said...: its very help ful... thank you; December 20, 2012 at 5:52 AM
Anonymous said...: amazing work.. wish u gud luck..; December 24, 2012 at 1:18 AM
Anonymous said...: Really helpful for me; December 27, 2012 at 1:26 AM
Unknown said...: Dear Suresh,

Very good effort and I really appreciate your hard work. Thanks!

Zaid Ahmad
Software Engineer
Lahore(Pakistan).; December 27, 2012 at 2:53 AM
Anonymous said...: nice; December 27, 2012 at 10:21 PM
CHANGES IN FLAT said...: such nice and gr8 guidance; December 28, 2012 at 5:21 AM
Anonymous said...: hai; December 28, 2012 at 10:58 PM
Anonymous said...: I am beginner,its very helpful for me
Thank You Suresh...; January 6, 2013 at 4:50 AM
Anonymous said...: sir iam fresher ,ple help me to how learn qick in .net,show me simple ways.; January 7, 2013 at 12:51 AM
Anonymous said...: fabulous job suresh..; January 8, 2013 at 10:43 PM
Unknown said...: i have error from edit to update,delete button; January 12, 2013 at 6:05 AM
Anonymous said...: Really u are an n genious ,
just i go stuck with UserId , but now the grid working charm ...
Really superb,,

thans; January 17, 2013 at 1:54 AM
Unknown said...: i want code for text box not allowing special characters i have a code but not work in firefox; January 18, 2013 at 2:05 AM
Rahul said...: How to display message Box while deleting Items from grid view.; January 21, 2013 at 11:07 AM
Rahul said...: dear Suresh,

Please tell how to write above example i.e edit update and delete using three layers ?
i.e presentation layer business object and data access layer please clear above example; January 21, 2013 at 11:11 AM
Anonymous said...: very nice post ..; January 24, 2013 at 3:54 AM
Anonymous said...: really awesome,
keep writing tutorials like this...
thanks...; January 25, 2013 at 9:42 PM
neeraj said...: thanks; January 28, 2013 at 2:49 AM
aparna said...: Hi suresh i have 1 doubt..
after clicking edit button it goes to update nd cancel. right. how it possible ??
plz replay me; January 29, 2013 at 2:37 AM
sam said...: it is not working in allowpaging true.............; January 29, 2013 at 10:24 PM
Anonymous said...: sir, its really working.. thank u so much..; February 4, 2013 at 10:26 PM
Anonymous said...: sir, am divya...its a best way to insert, update and delete the data to the table. this post really helps me a lot.. thank you sir..

but if are using this for master table means we cant able to delete the data..
for that can i use some flags?? how to use flags here?? can u suggest me??
plz...

help me sir..; February 4, 2013 at 11:52 PM
Anonymous said...: sir, i need how to insert, delete, update and cancel in details view in codeing; February 8, 2013 at 3:15 AM
Unknown said...: thanks is very helpfull; February 17, 2013 at 8:05 PM
Anonymous said...: This comment has been removed by a blog administrator.; February 17, 2013 at 11:01 PM
Anonymous said...: This comment has been removed by a blog administrator.; February 18, 2013 at 3:10 AM
AmolD said...: HI .............thnx for code.......
but footr template for add is not visible at runtime; February 18, 2013 at 10:16 AM
AmolD said...: is there problem in following code:::; February 18, 2013 at 10:17 AM
AmolD said...: This comment has been removed by the author.; February 18, 2013 at 10:18 AM
Anonymous said...: This comment has been removed by a blog administrator.; February 19, 2013 at 4:16 PM
Anonymous said...: Please anyone can explain What is the use Eval function in the above code , also i want to know how to use it and when to use it ?; February 19, 2013 at 9:41 PM
Anonymous said...: This comment has been removed by a blog administrator.; February 20, 2013 at 5:17 AM
Anonymous said...: This comment has been removed by a blog administrator.; February 20, 2013 at 1:45 PM
Unknown said...: hi, why is the gvDetailes in default.cs is not recognize?; February 21, 2013 at 8:22 AM
Gargi said...: I don't know sir ,if you are still replying at this site as your last reply was at Oct 6,2012. Still if you can assist please help,i couldnt find ts solution even at google,and other places still.and am a beginner in asp.net. am getting this following error,how should i remove this?
"Validation(XHTML 1.0 Transitional):Element 'panel' is not supported."; February 24, 2013 at 6:32 AM
Unknown said...: This is awesome..; February 28, 2013 at 3:01 AM
raja pandurangan said...: help me to learn the insert delete and update the data in asp.net c# with two textbox...

i went an interview their they are asking to do a task by saving the data and retrieving the edit delete and update... i m begineer pls help me to learn this... my mailid rajarockz666@gmail.com; February 28, 2013 at 8:49 AM
raja pandurangan said...: also tell me where will u post the answer; February 28, 2013 at 8:51 AM
Anonymous said...: Nice article . Learned many things from this post & about GV .

One doubt , is it needs to give "onrowcommand="gvDetails_RowCommand"" in .aspx page ? If we place this , Rowcommand method executes twice .; March 1, 2013 at 2:09 AM
Ramaraj said...: Its working gud Mr.Suresh. wil u pls giv this in 3-tier architecture; March 3, 2013 at 10:08 PM
Anonymous said...: Mr. Suresh
In My DB... 4 tablse
1) Registration table
2) Country table
3) state table
4)city table

Now in registration table many colums like name ,Mobile,Country, state, city,...etc

and i want to fetch data of Country, state and city from those tables (Country,State and City)

and I also want to save them into Registartion Table also So can in Possible..?
Give me answer.... pls; March 5, 2013 at 1:15 AM
Anonymous said...: thnx you sir for giving best solution; March 6, 2013 at 10:02 PM
Unknown said...: thnx you sir for giving best solution....this is one of the best site for IT; March 6, 2013 at 10:03 PM
Anonymous said...: @Sam

for using allow paging, set the following properties in gridview,

AllowPaging ="true" PageSize ="3" OnPageIndexChanging="gvDetails_PageIndexChanging"

and also add the following code,

protected void gvDetails_PageIndexChanging(object sender, GridViewPageEventArgs e)
{

gvDetails.PageIndex = e.NewPageIndex;

BindEmployeeDetails();

}

hope this will help you..

regards
divya..; March 9, 2013 at 1:44 AM
Unknown said...: hi, thankyou for this post. i have a problem- nothing is happening when i am clicking the images (delete, update, insert)

need your help asap!; March 11, 2013 at 1:20 AM
timestamil24.in said...: Dear suresh could you upload the the code for merge gridview headers in asp.net.? Please kindly help me; March 14, 2013 at 12:53 PM
Anonymous said...: It helps a lot... good post suresh...I'm proud that you are an andhra guy...; March 17, 2013 at 8:24 AM
Travel Fobby said...: realy awsome man keep in touch for clear my doubts; March 19, 2013 at 9:33 PM
Anonymous said...: how to use dublict value in your gridview
thans..; March 21, 2013 at 3:56 AM
Anonymous said...: Why you not record this things Its better way to explain and easy to understand; March 25, 2013 at 8:09 PM
Unknown said...: This is very useful to me !

Thank U Very much; March 28, 2013 at 2:34 AM
Anonymous said...: good one; March 30, 2013 at 11:44 PM
Anonymous said...: Hi,
i want to perform update,delete and insert options using MVC 4,after performing the operations it should be displayed in gridview and should be updated in the database,how can i do that,please let me know i need it ASAP...
any help would be appreciated..
Thankyou so much,
Bhavani.; April 5, 2013 at 4:47 AM
Anonymous said...: please help me ,its really important...
thankyou,
Bhavani; April 5, 2013 at 4:50 AM
Bharath said...: Asp.net insert, Edit, update, delete data in gridview

Hi sir this is bharath, i am doing the above ur example. i am getting an error in RowUpdating event.
"system.web.ui.webcontrols.gridviewupdateeventargs does not contain a definition Rowindex"

colud u plz help me...; April 6, 2013 at 12:36 AM
Anonymous said...: Hi Avneesh here i m getting an error in update section "Object reference not set to an instance of an object".

Plz help me out Thx in advance.....; April 9, 2013 at 11:23 PM
Unknown said...: I want to insert,update ,delete,in gridview. But Here only we can bind the data,, but i need images also to be binded in gridview with the help of fileupload control.Inside the footer template only i need fileupload control to be accessed..; April 16, 2013 at 1:14 AM
Anonymous said...: Thank you sir, Nice material; April 19, 2013 at 5:59 AM
Anonymous said...: I HAVE ONLY FEW WORDS FOR YOU........

"GOD BLESS YOU"; May 3, 2013 at 9:40 AM
Unknown said...: very nice article...super....; May 7, 2013 at 11:34 PM
Unknown said...: i need a help for this...i have 3 radio buttons in gridview...how can i update data using radio buttons...without radio button thats not a problem...using radio buttons how can i update data in asp.net with c#; May 7, 2013 at 11:39 PM
sindhu said...: sir, suppose there are 2 pages and on click of some hyperlink the control goes to next page.

in the next page i'm inserting some data and once i click the submit button, the details are stored in the database and immediately the control should go to the 1st page... not knowing how to go about it.

please help me sir.; May 13, 2013 at 11:22 AM
john cena said...: its simply superb........; May 17, 2013 at 2:12 AM
Anonymous said...: Hi Suresh,

Thanks for the fantastic article. It is very useful. You have explained everything so simply that I have got no questions regarding the topic but I have another question for you.

How did you create the GIF image to show demo ?
Which software did you use ?

Regards,
Maulin Thaker; May 20, 2013 at 10:05 PM
Anonymous said...: I want to insert,update ,delete,in gridview. But Here only we can bind the data,, but i need images also to be binded in gridview with the help of fileupload control.Inside the footer template only i need fileupload control to be accessed.. Please can u help me... Thank you...; May 22, 2013 at 10:20 PM
Anonymous said...: Nice Program......; May 31, 2013 at 7:10 AM
Anonymous said...: Very nice article. Fully working...thanks.; June 7, 2013 at 2:11 AM
Anonymous said...: nice and simple programs for fresher like me it was hard to think about simple program.
but u made it easy understanding and for practice too.

thanku; June 10, 2013 at 12:43 AM
Unknown said...: hello sir,
there is problem in binding of gridview with empty data. if i use your code and there is no data in table then EDIT and DELETE botton automatically appears and create problem if i click on that buttons.
Is there any code so that i can hide those buttons an can display only empty Griedview.; June 12, 2013 at 8:01 AM
Unknown said...: sir
pllease help me its urgent for me.; June 12, 2013 at 8:27 AM
Unknown said...: Sir,
I have tried it in entity framework too but it didn't work for me.
problem is when gridview is empty at that time gridview not showing the footer.
And using entity framework how to show the no record found msg in gridview?; June 17, 2013 at 10:46 AM
Welcome to said...: Hi Sir,

How to insert the Current Date and time into Gridview from Textbox and save it into SqlServer 2008 and display the current date time into gridview.; June 18, 2013 at 1:13 AM
Tanmoy said...: Thanks...!!! Simple one yet fantastic...!!!; June 18, 2013 at 3:24 AM
Anonymous said...: Sir,
I hav a question that whether jquery is required for that or whatever you hav written that is sufficient; June 26, 2013 at 10:11 PM
Anonymous said...: it is good one..; July 2, 2013 at 2:41 AM
vicky said...: I am fresher. I am doing one small medical application which has around 29 fields in database.. I want to use a grid view, only for few fields.. Is it possible? If yes, then how to do... Database is oracle 10g.

Waiting for your reply; July 3, 2013 at 10:42 PM
Unknown said...: hi sir,
I want code for search box to put on website; July 4, 2013 at 6:59 AM
Anonymous said...: reference object set an instance is not nulled i got this error; July 5, 2013 at 9:21 PM
Anonymous said...: Thanks For Giving Great Examples For Leanrners; July 5, 2013 at 9:30 PM
Unknown said...: Thanks Sir...............; July 8, 2013 at 8:41 PM
Anonymous said...: each n every thing is exlained clearly thanq....very helpful for freshers....:) :); July 8, 2013 at 8:56 PM
Vishal said...: Create a employee table, designation table, as soon as we select designation form dropdown list according to that the employee name should be display in grid view. The grid should be fully editable all facilities should be there.
Take 5 designation names in table.
Use stored procedure.

Does anyone have a solution? Please help me.; July 9, 2013 at 12:35 AM
Unknown said...: suresh i have 2 or more gridview on page
when i use your code on first gridview its work fine but when i use same code on second gridview the both are not working; July 20, 2013 at 10:55 PM
Unknown said...: its great; July 25, 2013 at 3:45 AM
Anonymous said...: very simple and very worthy; August 10, 2013 at 9:24 AM
Admin said...: Hello Suresh
I use your post for development but now days demo images are not visible on site. The demo images are very useful to me.; August 18, 2013 at 1:15 PM
nilu gupta said...: sir this code is very effective .. but some problem occur..

TextBox txtR_adderss = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtR_adderss");
in this line :-e.RowIndex gives error .. so pl if possible beacouse it does not contayins in the cureent contecst on update and add new button. thak u pl ... sir; September 11, 2013 at 11:57 PM
sivas kangalı said...: thanks for your sharing.; September 27, 2013 at 5:47 AM
Anonymous said...: hello sir thank you for your guidance...but im facing a problem when trying to update..im beginner in this kind of arrangment....can you tell me why this happen?...

Object reference not set to an instance of an object.<----- happen when update button is clicked..search at google failed to find any solution.; September 27, 2013 at 9:31 AM
Anonymous said...: Hi suresh error on deleting data "Index was out of range. Must be non-negative and less than the size of the collection."; October 1, 2013 at 11:02 AM
Anonymous said...: hello sir,
I'm kohila. your each and every code run successfully.
but, in my project i have to save gridview data and other textbox data at the same time,
in a single table.
please give me sample code for these. please do it for me sir.
i hope many people get useful if you post that code.
thank you sir.
here my email-id: kohilavani2011@gmail.com.
Thank you sir.; October 11, 2013 at 11:24 PM
Anonymous said...: only insert is working.. foe deleting and updating i'm getting an error like input string was not in correct format.. can u help?; October 17, 2013 at 11:33 PM
Anonymous said...: earn online register there ,,,,, http://www.Pay4Visits.com/index.php?refcode=7640; October 24, 2013 at 11:56 AM
gjayaprakash said...: "system.web.ui.webcontrols.gridviewupdateeventargs does not contain a definition Rowindex"; October 30, 2013 at 4:08 AM
infoline said...: very nice website man ,,,,,,K.$..; October 31, 2013 at 5:43 AM
Anonymous said...: A1 site; November 3, 2013 at 8:39 AM
Unknown said...: Good Evening sir,
thank u for the code, but i'm getting an error while changing the auto-generate columns property to false give me some guidance to solve this problem......; November 9, 2013 at 2:30 AM
Unknown said...: Hello Suresh ,
I have a question i wanna use gridview for only inserting the records but without binding the data in gridview it is not appearing. can u help me out; November 14, 2013 at 8:54 AM
Unknown said...: hi suresh in this articles user id cant displayed in the output. only username, city and designation only available in the gridview during the running section so pls tel me how solve this... mail to ksanbutnj@gmail.com; November 20, 2013 at 5:11 AM
Unknown said...: thank u sir; December 5, 2013 at 9:38 PM
Unknown said...: Hello sir,
Can we use the above function dynamically for all tables??; December 8, 2013 at 1:59 AM
Unknown said...: This comment has been removed by the author.; December 19, 2013 at 4:40 AM
Unknown said...: Sir I have done the same coding but while updating event execution the code is taking old values of template textbox. Please help me on this issue. This is my update event code....
TextBox EName, MobileNo, Address;
Label Eid;
GridViewRow grv = (GridViewRow)GridView2.Rows[e.RowIndex];
Eid = (Label)GridView2.Rows[e.RowIndex].FindControl("Label6");
EName = (TextBox)GridView2.Rows[e.RowIndex].FindControl("TextBox15");
MobileNo = (TextBox)GridView2.Rows[e.RowIndex].FindControl("TextBox17");
Address = (TextBox)GridView2.Rows[e.RowIndex].FindControl("TextBox19");
UpdateData(Eid.Text, EName.Text, MobileNo.Text, Address.Text);
GridView2.EditIndex = -1;; December 19, 2013 at 4:45 AM
rajesh said...: thanks sir...........; December 23, 2013 at 2:34 AM
Unknown said...: i used your code it worked fine....but am facing prob that when i click edit the rowcells which are not in edit mode are shrinking.....any solution??; December 29, 2013 at 1:01 AM
Anonymous said...: hello sir thank you for your guidance..but the code have some problem .insert Command in GridView's RowCommand keep on executing on Page Refresh.. how to solve this problem ? Please can u help me.
Thank you sir.
here my email-id: shajin2233@gmail.com; January 11, 2014 at 2:29 AM
PRAMOD NAIR said...: One of the best ASP Dot Net Blog from Suresh Dasari.
Sulekha.com may proud of this coder as its employee; January 15, 2014 at 3:25 AM