Solved

How to handle editing/inserting with a gridview in a formview

Posted on 2008-10-29
5
529 Views
Last Modified: 2008-11-04
I;ve got to display orders details and order items on a vb webpage.  It looks like the best way of showing this in aspx is to have a formview showing the Order details with a embeded griview showing order items.

I set this up with two sql datasources and I can show data fine. However, I', hjaving difficulty handling edits/inserts with this setup.  When I update the form, the updates in the gridview disapear, and vis-versa.

Has anybody got any code sample for this?  It's a very common thing in access (form/sub-form) but I cant find anything miuch for aspx!
0
Comment
Question by:jmsjms
  • 3
  • 2
5 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 22839927
0
 

Author Comment

by:jmsjms
ID: 22840740
Hi CodeCruiser,

>http://visualbasic.ittoolbox.com/groups/technical-functional/vb-dotnet-access-l/writing-to-related-child-table-using-details-form-controls-2249978

Not relevant - Doesnt provide any help, it's just a user asking for a similar (but not the same) thing

>http://blogs.msdn.com/bethmassi/archive/2008/02/19/one-to-many-master-detail-forms-with-linq-to-sql.aspx

Not relevant - This is about VB winforms.  I need the info for a webapp (as noted in question)

>http://doc.xceedsoft.com/products/XceedGrid/Building_a_bound_hierarchical_master_detail_grid.html

Not relevant - about building a hierarchical master/detail grid.

>http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic58829.aspx

Not relevant - About binding two grids.

>http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/GridViewMasterDetailsInsert.src

Not relevant - About a grid master and a details view linked to the grid.

This is just stuff that I've dug up on numerous occasions that does't help at all.  Have you read my question?  ;-)

I can see loads on the net about having a grid view and then opening up a detailsview/formview based on selected record.  I know how to do this and use this regularly.

I really need to get this working ASAP, and whilst I appreciate your efforts these non-relevant links arent helping and perhaps stop ofther experts looking as they think we are working ont it.   I've ahd to re-ask this question in another format because my similar question (which you answered using the technique) has stalled  Can I ask you to only give me relevant help.

Many thanks.
John


0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 22841150
Glad to not bother mate.
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 22841162
By the way, this platform is meant to provide either hints or links to resources which may help construct the solution. I hope you are not expecting a visual studio solution uploaded as a zip file.
0
 

Accepted Solution

by:
jmsjms earned 0 total points
ID: 22842607
CodeCruiser, I'm happy and very grateful for relevant Google search results.  If you find any please let me know.

As for coding, I'm looking for whats hopefully a standard code pattern.  Ie. empty code or example as to how to handle a nested gridview inside a formview.  

Just so happens that I think I've found what i need doing another search.  Ironic really as the guy has kindly created a complete VS solution.

For reference, and in case someone else browses to this in search of the same thing its

http://www.eggheadcafe.com/tutorials/aspnet/0af43149-8fa7-4ab8-8d08-e885090f1a8d/aspnet-data-control-seri.aspx


0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

705 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now