I have a table ( aheader) whcih also has another 7 children tables, all of them with an specific functionality in accordance to the business rules defined for that entity.
I'd like to know if there is a way of combining all of the 8 tables at once in a page: the amster table plus all other 7 tables
What I'd like to achieve is having a grid displaying a list of all headers stored in the database (let's call it Request Orders for instance) and then show all other 7 grids showing the list of details entered (if any ... because it might as well have it
still has zero data) and then allowing me to enter data (in DETAIL-ENTRY mode) for each one of the tables and showing (refreshing) the newly entered data
Is that possible at all in a C# ASP.Net Dynamic Data project?
If you don't insist doing that with Dynamic Data, It's very easy for you to do the master-detail formView+GridView on the common asp.net page. You can refer this:
(By the way ... I am going to use some capital letters here .... they don't mean yelling or fault or whatever other negative conmnotation generally is given to capitals. I will use them in order to enhance my questions and comments here .... not for
anything else than that .... Ok ...) ....
If I'm currently developing an C# ASP.Net Dynamic Data (with SQL Server) project, why do I have to think outside that box?
This is answer is not by any means and neither does it imply lack of respect or whatsoever ....
... just a true simple question: Can't it be done using Dynamic Data?
I know for sure this can be done in conventional ASP.Net. Same criteria apply to anything else: cascading, menus, validations, customized forms, etc. But I respectfully insist: Talking about anything else than Dynamic Data as a solution IS NOT a solution
for this kind of project BECAUSE Dynamic Data BEHAVES DIFFERENTLY THAN STANDARD ASP.NET FORMS
To be very honest, not absloutely. But considering it that if you are using Dynamic Data, and you have to apply the template inside VS, but the template for Dynamic Data (in default) there's only one GridView or FormView. It's not easy to achieve that.
This is one of the things that I think should be part of the native package of VS20XX
How many systems have been developed using the snowflake design technique? Probably millions, no? So, displaying this kind of master-detail(s)-grandson(s) ... nephews, cousins and any other fancy way of resolving quickly referential integrity at the level
of the data itself should be good .... AND PRINT IT AT THE SAME TIME ... isn't it?
For instance, if I had something like in a underwriting company, I'd had a request order, a request header, a sheet for the answers gathered during inspection and at the same time: names of tenants, legal representatives of yours and your customers, details
of lands, details of machinery, details of gas tanks, details of dangerous animals, phones, addresses, dates, data of security, chimneys, etc.
You'll probably have all of this data stored into different correlated tables but you'll surely like to have it available at once for data entering and printing the final report ... isn't it?
So, if you put yourself in that scenario you will understand my request
Member
242 Points
480 Posts
Multiple Master Detail forms
Nov 21, 2012 01:19 PM|klca|LINK
Hi,
I have a table ( aheader) whcih also has another 7 children tables, all of them with an specific functionality in accordance to the business rules defined for that entity.
I'd like to know if there is a way of combining all of the 8 tables at once in a page: the amster table plus all other 7 tables
What I'd like to achieve is having a grid displaying a list of all headers stored in the database (let's call it Request Orders for instance) and then show all other 7 grids showing the list of details entered (if any ... because it might as well have it still has zero data) and then allowing me to enter data (in DETAIL-ENTRY mode) for each one of the tables and showing (refreshing) the newly entered data
Is that possible at all in a C# ASP.Net Dynamic Data project?
is like having: (click link for larger image)
Carlos N. Porras
(El Salvador)
All-Star
94130 Points
18109 Posts
Re: Multiple Master Detail forms
Nov 22, 2012 12:56 AM|Decker Dong - MSFT|LINK
Hi,
If you don't insist doing that with Dynamic Data, It's very easy for you to do the master-detail formView+GridView on the common asp.net page. You can refer this:
http://www.codeproject.com/Articles/16780/GridView-FormView-Master-Detail-Control
Member
242 Points
480 Posts
Re: Multiple Master Detail forms
Nov 22, 2012 07:31 AM|klca|LINK
Hi Mr. Dong,
(By the way ... I am going to use some capital letters here .... they don't mean yelling or fault or whatever other negative conmnotation generally is given to capitals. I will use them in order to enhance my questions and comments here .... not for anything else than that .... Ok ...)
....
If I'm currently developing an C# ASP.Net Dynamic Data (with SQL Server) project, why do I have to think outside that box?
This is answer is not by any means and neither does it imply lack of respect or whatsoever ....
... just a true simple question: Can't it be done using Dynamic Data?
I know for sure this can be done in conventional ASP.Net. Same criteria apply to anything else: cascading, menus, validations, customized forms, etc. But I respectfully insist: Talking about anything else than Dynamic Data as a solution IS NOT a solution for this kind of project BECAUSE Dynamic Data BEHAVES DIFFERENTLY THAN STANDARD ASP.NET FORMS
Carlos N. Porras
(El Salvador)
All-Star
94130 Points
18109 Posts
Re: Multiple Master Detail forms
Nov 22, 2012 08:35 PM|Decker Dong - MSFT|LINK
To be very honest, not absloutely. But considering it that if you are using Dynamic Data, and you have to apply the template inside VS, but the template for Dynamic Data (in default) there's only one GridView or FormView. It's not easy to achieve that.
So a general ASP.NET would be better in my mind.
Member
242 Points
480 Posts
Re: Multiple Master Detail forms
Nov 23, 2012 09:41 AM|klca|LINK
Hi Mr. Dong,
This is one of the things that I think should be part of the native package of VS20XX
How many systems have been developed using the snowflake design technique? Probably millions, no? So, displaying this kind of master-detail(s)-grandson(s) ... nephews, cousins and any other fancy way of resolving quickly referential integrity at the level of the data itself should be good .... AND PRINT IT AT THE SAME TIME ... isn't it?
For instance, if I had something like in a underwriting company, I'd had a request order, a request header, a sheet for the answers gathered during inspection and at the same time: names of tenants, legal representatives of yours and your customers, details of lands, details of machinery, details of gas tanks, details of dangerous animals, phones, addresses, dates, data of security, chimneys, etc.
You'll probably have all of this data stored into different correlated tables but you'll surely like to have it available at once for data entering and printing the final report ... isn't it?
So, if you put yourself in that scenario you will understand my request
Carlos N. Porras
(El Salvador)
All-Star
94130 Points
18109 Posts
Re: Multiple Master Detail forms
Nov 23, 2012 07:27 PM|Decker Dong - MSFT|LINK
Hello again,
It seems that you wanna a Master-Details in a Dyanmic Data Sample,please have a look at this:
http://forums.asp.net/p/1301257/2542759.aspx
All-Star
17916 Points
5681 Posts
MVP
Re: Multiple Master Detail forms
Nov 24, 2012 07:07 AM|sjnaughton|LINK
Hi Carlos, I already have this working see below, this is available via my open source project here and will be available via nuget eventually.
Always seeking an elegant solution.
Member
242 Points
480 Posts
Re: Multiple Master Detail forms
Feb 17, 2013 09:54 PM|klca|LINK
Hi,
Where is the master/detail thing in that link? couldn't find it !
Carlos N. Porras
(El Salvador)