Problem with Gridview Editing

Question

0.00/5 (No votes)

See more:

HI,
This is Ganesh,
I have a table with no primary key and it contains 40 fields and holding only one row.
My problem is how to bind these details to a GridView with Edit Opertaion.
and also i have to edit all the data in that table.

Can any one help me out.
Any help would be greatly appreciated.

Regards,
Ganesh Kumar

Posted 15-Apr-12 4:34am

Ganesh Kumar Kaki

Updated 15-Apr-12 6:17am

v4

Add a Solution

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)

bbirajdar · Answer 1 · 2012-04-15T05:10:00

Solution 1

Editable GridView in ASP.NET 2.0[^]

http://wiki.asp.net/page.aspx/1360/add-edit-update-delete-gridview/[^]

Posted 15-Apr-12 5:10am

bbirajdar

Kuldeep B · Answer 2 · 2012-04-15T07:09:00

Solution 2

Its Easy...

Check in gridview enable editing is checked..
and when your editing done update the database so next time u get that edited data.

Best Regards
Kuldeep

Posted 15-Apr-12 7:09am

Kuldeep B

Ganesh Kumar Kaki · Answer 3 · 2012-04-15T07:28:00

Solution 3

Thanks for your reply
but the actual problem I'm facing is that my table contains 40 fields(columns) and how can i write/ mention each field in my source code.
And what about my update statement. I have to update each and every column in the grid.
And remember that my table doesn't have the PRIMARY KEY. And also in the edit mode of my gridview it has to show few dropdownlist's and one fileupload control and one listbox.

Is there any alternative way without mentioning the 40 fields in my source code.

Any help would be greatly appreciated.Thanks!!

Posted 15-Apr-12 7:28am

Ganesh Kumar Kaki

Comments

Kuldeep B 15-Apr-12 13:41pm

fields count is not issue.
when you call update method all edited data is updated

Kuldeep B 15-Apr-12 13:55pm

Update--
Gridview1.Databind();

Nelek 15-Apr-12 18:29pm

Please don't write solutions to give more information about your problem. You can use the "improve question" to add the information to your original message and/or click on "have a question or comment" to directly speak with the person you want to (he/she will get a notification), as we are doing right now with you.

Kuldeep B 16-Apr-12 8:51am

Good Advice Nelek....