?
Solved

GRIDVIEW HYPERLINK EDIT ON 2ND PAGE

Posted on 2011-02-19
2
Medium Priority
?
472 Views
Last Modified: 2012-05-11
Please reference the attached files used in conjunction with an access data base.   I have two pages "Home1" and "Home2".     The Hyperlink located on "Home1" directs perfectly to "Home2".   I am able to edit and update
correctly on "Home1".    However, when EDIT and Update on "Home2" is used it does update but is updating the
entire data base row leaving blank information for that row deleting previous data.   With the filter applied  to "Home1"  displaying only open items in the status row,  it no longer displays when returning home.  

How can I edit page 2 or "Home2" without impacting the entire data set row after update?  
Home1.aspx
Home2.aspx
database2.mdb
0
Comment
Question by:BOEING39
2 Comments
 
LVL 41

Accepted Solution

by:
guru_sami earned 2000 total points
ID: 34938399
If you just want to update Reason2 and Parts then adjust your UpdateCommand and UpdateParamters on home2 to use only the fields that needs to updated.

UpdateCommand="UPDATE [AOS] SET [Reason1] = ?, [Reason2] = ?, [Parts] =? WHERE [ID] = ?"

<UpdateParameters>
<asp:parameter Name="Reason2" Type="String" />
<asp:parameter Name="Parts" Type="String" />
<asp:parameter Name="ID" Type="Int32" />

Open in new window

</UpdateParameters>
0
 

Author Closing Comment

by:BOEING39
ID: 34940219
Thx I worked that out with your help.  I ended up using detail view instead on form2 as it was more useful presented that way.  Thank You
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Integration Management Part 2
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question