GRIDVIEW HYPERLINK EDIT ON 2ND PAGE

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
BOEING39Asked:
Who is Participating?
 
guru_samiConnect With a Mentor Commented:
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
 
BOEING39Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.