How to delete the record from the grid view and update the database.

Question

0.00/5 (No votes)

See more:

Dear All...

I am new to programming..

please help me in the following problem which i am facing in C# and SQL server as backend.

1) How to delete the record from the grid view and update the database.

2) How to refresh the gridview.

3) how to update the gridview

please help me for the same..

Thanks...

Posted 27-Sep-12 20:45pm

zaid Qureshi

Add a Solution

Comments

Oshtri Deka 28-Sep-12 3:22am

You should really try Google first.

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

Abhijit Parab · Answer 1 · 2012-09-27T20:50:00

Solution 1

Try the following link
this is a simple to understand.........

Insert, Update, Delete with Gridview ... Simple Way[^]

Posted 27-Sep-12 20:50pm

Abhijit Parab

Comments

Oshtri Deka 28-Sep-12 3:18am

Good link.

ridoy 28-Sep-12 3:25am

+5

Vijay Walunj,Navi mumbai · Answer 2 · 2012-09-27T20:52:00

Solution 3

http://www.dotnetfunda.com/articles/article29.aspx[^]

Insert, Update, Delete in ASP.NET Gridview, DataSource as SQL Server, MS Access (mdb/accdb), XML and Framework as 2.0 / 3.0 / 3.5 / 4.0 (VS 2005/2008/2010)[^]

Posted 27-Sep-12 20:52pm

Vijay Walunj,Navi mumbai

Comments

Oshtri Deka 28-Sep-12 3:21am

IMO second link is a bit over the top for beginner.

Anele Ngqandu · Answer 3 · 2012-09-27T21:49:00

Solution 4

http://weblogs.asp.net/manojkdotnet/archive/2009/10/11/insert-update-and-delete-using-grid-view-and-objectdatasource.aspx[^]

Posted 27-Sep-12 21:49pm

Anele Ngqandu

solanki.net · Answer 4 · 2012-09-27T20:50:00

Solution 2

there r many ways so tell me that when u r hitting database i mean every time after deleting record or only once when u click on save button .

Posted 27-Sep-12 20:50pm

solanki.net

Comments

zaid Qureshi 28-Sep-12 3:10am

i didnt get u bro..@solanki

Oshtri Deka 28-Sep-12 3:19am

This is not correct place for l33t

zaid Qureshi 28-Sep-12 3:26am

Oshtri Deka : whats that l33t

solanki.net · Answer 5 · 2012-09-27T22:25:00

Solution 5

i mean when u want to delete the record from database after click the delete button of grid or anything else .

Posted 27-Sep-12 22:25pm

solanki.net

Comments

zaid Qureshi 28-Sep-12 5:03am

yes..after clicking the delete Button from the grid

solanki.net 28-Sep-12 5:15am

it means every time after deleting record from grid u will have to hit database .
on rowDeleting event find id of row like that :
Label lblid = (Label)gvHardware.Rows[e.RowIndex].FindControl("lblId");
send this id with special parameter(like "Delete") and check in database value of special parameter and delete record using id .
after deleting record again u will have hit database for binding grid .

zaid Qureshi 28-Sep-12 5:25am

@ solanki:just give an example plz...