How to update data in a table in asp.net

Question

0.00/5 (No votes)

See more:

I have created one employee table.
I tried to insert data in it. Now I want to update the data in it. For that I used grid view. Now came to know that following key words I have to use.

XML

<asp:GridView ID="EmployeeGridView"   
              runat="server" 
              AutoGenerateColumns="False"
              DataKeyNames="Emp_id"     
              onrowcancelingedit="EmployeeGridView_RowCancelingEdit"
              onrowediting="EmployeeGridView_RowEditing"              
              onrowdeleting="EmployeeGridView_RowDeleting"
              onrowupdating="EmployeeGridView_RowUpdating">

I have used methods for updating, deleting but I don't know where to place those methods. Please tell me where to use it.
As i am new to .net, explain me in a easier way, so that I could be able to understand.

Posted 20-Nov-12 20:52pm

vinod.sambangi

Updated 20-Nov-12 20:57pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

2 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)

__TR__ · Accepted Answer · 2012-11-20T21:01:00

Solution 1

Refer these aricles
Insert, Update, Delete with Gridview ... Simple Way[^]
Editable GridView in ASP.NET 2.0[^]

Posted 20-Nov-12 21:01pm

__TR__

Updated 20-Nov-12 21:06pm

v2

Comments

vinod.sambangi 21-Nov-12 3:56am

Where to place the code of it.This "protected void grdContact_RowUpdating(object sender, GridViewUpdateEventArgs e)
" function where i can get in the page and to place it.Please tell me.

__TR__ 21-Nov-12 5:08am

The code will be in your code behind (.cs) file.

vinod.sambangi 21-Nov-12 5:18am

I was getting error in the following code in "e.RowIndex" in the below code
"
protected void EmployeeGridView_RowUpdating(object sender, GridViewEditEventArgs e)

{
int empid =((TextBox)EmployeeGridView.Rows[e.RowIndex].FindControl("txtempexp")).Text;//Get Each Row unique value from DataKeyNames
string name = ((TextBox)EmployeeGridView.Rows[e.RowIndex].FindControl("txtempname")).Text;//get TextBox Value in EditItemTemplet that row is clicked
"
It was saying error as "using System.Web.UI.WebControls.GridViewCancelEditEventArgs
does not contain definition of RowIndex and RowIndex accepting first arguement of
System.Web.UI.WebControls.GridViewCancelEditEventArgs
could be found"
.This is the error.Please tell me

__TR__ 21-Nov-12 5:30am

For row update event your method should look like
protected void EmployeeGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
And the error you have included looks like its generated for Cancel Edit Event.

sachinkale20 · Accepted Answer · 2012-11-20T21:05:00

http://stackoverflow.com/questions/5893373/c-sharp-rowupdating-method-not-called-when-update-is-clicked-in-a-gridview?answertab=active#tab-top[^]

http://www.velocityreviews.com/forums/t705244-i-want-the-code-for-rowupdating-and-rowdeleting-for-gridview-control-in-following-cod.html[^]

Check these two links...if you face any difficulty post it..