master-detail

What's the recommended way of doing a master/detail page using ASP.NET MVC?

Hi, Does anyone have any suggestions/ best practices for doing master/ detail pages using the ASP.NET MVC Framework? Background I've got a page of Client information, under each one I need to display 0 or more related records about that client. The database schema looks something like this: Clients -- one to many --> Client...

Master/Detail help needed for ASP.NET newbie. (screenshot too).

I'm just beinning basic data driven ASP.NET webforms design. I have the first part of a form working, but I don't know what to do next. Please see this screenshot of what I have created so far: http://www.twitpic.com/2gnmr I need help knowing what kind of HTML element to use in the master list, and what event/trigger on that element t...

In an SSIS package, how do you insert master-detail records?

I have a data flow task that extracts data from one database and inserts into a SQL Server database. After each record is inserted in the master row I also need to insert rows into a detail table. The data for the detail table is pretty simple and can be calculated. How do I retrieve the value of the identity column after inserting? Ho...

How to insert records in master/detail relationship

I have two tables: OutputPackages (master) |PackageID| OutputItems (detail) |ItemID|PackageID| OutputItems has an index called 'idxPackage' set on the PackageID column. ItemID is set to auto increment. Here's the code I'm using to insert masters/details into these tables: //fill packages table for i := 1 to 10 do begin Packag...

Subclass a table and a big trouble in Delphi

How you can see above, it's a kind of subclass a table in a RDBMS (in this case, my favorite: MySQL) so I handle it with Visual Subclassing a base form for tb_order_base with validating field data, etc. This way, I'm free of repeating code and some other bothering problems, well, it seems a true OO aproach. But ... Now I got a Big pr...

How to handle entity creation/editing in a master-detail

I'm wondering what strategies people are using to handle the creation and editing of an entity in a master-detail setup. (Our app is an internet-enabled desktop app.) Here's how we currently handle this: a form is created in a popup for the entity that needs to be edited, which we give a copy of the object. When the user clicks the "Can...

How to fill objects master - datail collections c#/SQL2005

I'm using Business Objects Collections. (Not using datasets. Generics collections only.) Collections of Business objects are filled using SQL Reader I'd like to know your opinion what is best approach to fill master details (or parent-child) collections Assume I have 2 objects: Invoice and Invoice_Details Invoice Object has generic col...

Updating Parent/Child Records with model binders in ASP.Net MVC

I have modified the Nerd Dinner application to allow editing of child records by adding the following code to the DinnerForm.ascx <p> <%int i = 0; foreach (NerdDinner.Models.RSVP rsvp in this.Model.Dinner.RSVPs) { %> <%= Html.Hidden("Dinner.RSVPs[" + i + "].RsvpID", rsvp.RsvpID)%> <%= Html.Hidden("Dinner...

Gridview row information disappearing after selectedIndexChanged

I have a master/details setup with a GridView and DetailsView both in UpdatePanels. When the DetailsView is edited and updated, I want these changes to be reflected in the GridView, but without rebinding that data (which could change the selectedItem's sort order among other problems it causes) On DetailsView ItemUpdated I have the fol...

What's the best way to display a single record in a webpage?

I have a master/detail form. I have a jquery grid for the detail, works fine. I'm not sure how to display the master single record. I don't want to use an html table. Just a styled list maybe? I've was always so spoiled with asp.net controls in webforms that I don't know any good practices for this sort of thing. I am using PHP and...

Indirect binding to child collections in XAML

Hi folks, I am currently using a Linq template with SubSonic3 to create my models. I have a simple Member class, which has a collection of Notes. A Note class has a PublishedDate and Title properties. I have a UserControl which has a collection of Members for its DataContext. There are two ListBoxes and a bunch of TextBoxes and other c...

How do you do List/Detail Editing with a UITableView?

What's the best way to have a list of text items, tap on one and be able to edit it? How about going to a detail view? But then how do you get your change back into the UITableView? I suppose this could all be done with SQL or CoreData but since the UITableView is based on an array, can we just edit that element of the array and reset t...

Saving/editing parent and child information on same webpage

This is a question related to how people are handling a situation in the user interface for a web application. I have a page which is displayed when a user wants to create/edit a Parent object. It has a few attributes related to this Parent object, as well as a Save button so the Parent can be saved. Each Parent object has a collectio...

Rails Form Builders - How to display a read only field or protect a field

I have created a form that needs to show data from 2 tables (parent and child). When the form is submitted only the child fields are updated (the parent fields are meant to be display only). While the parent model fields are displayed these need to be protected from updates (preferably via the formbuilder, rather than via css). FWIW th...

Master-Detail View ASP.NET MVC

Hello Everybody, I'm new to MVC and I'm involved in a project that is developed with ASP.NET MVC 1.0. I'm also weak in JavaScript :-( I'm trying to demonstrate how Master-Details view work on 'Orders' & 'Order Details' tables from Northwind database. (Hence: the tables has a relation, i.e., an order can have multiple order details) I ...

Aggregate detail values in Master-Detail view

I have a master-detail relationship in some custom entities. Say I have the following structure: class Master : INotifyPropertyChanged { public int Id { get; set; } // + property changed implementation public string Name { get; set; } // + property changed implementation public ObservableCollection<Detail> Details { get; ...

How to make a subreport/master-detail in VS crystal reports without it being clickable?

Often I'm creating reports in Visual Studio's Crystal Reports and want to have a master-detail or 1-many type thing. Something like this: Invoice Number 13245 Total: $1,000,000 Date Raised: 1-Jan-1989 Date Due: 1-Jan-2019 Line items: # Desc Cost 1 Hat 23.00 2 Gloves ...

Implementing a non-hierarchical Master-Detail pattern in WPF

I'd like to implement the Master-Detail pattern in my WPF application, so that when the user selects an item in a ListView its details are displayed elsewhere. However my data source (some XML) is not structured in a hierarchical manner; rather, each item stores a list of IDs which can be used to identify the details in another section o...

What .NET control do i want to use?

What .NET control do i should i use to display this to the user? I have 2 types of elements, a package and item. The data an item contains is id, size and status. The package can have several items (but no packages as its not a tree). It holds status and count. I can think of a 3rd column for this. I will need to right click each item o...

How to check that a record of master table is being used/referenced by child table

In my ERP application, I am taking a extra field named 'IsRemoved' as boolean. Whenever a user deletes any record, the record is not deleted - only its "IsRemoved" column gets value 'true'. It helps us to be able to recover data when ever we want, and its working fine. The problem is that when ever user deletes record of Master Table, ...