Soldato
- Joined
- 25 Mar 2004
- Posts
- 16,007
- Location
- Fareham
Hi all,
I've some basic Parent-Child data I want to work with for updates etc.
Am coding in Visual Studio 2010 using ASP.NET C# as my language of choice.
My DB in production is using MS SQL 2008 though I am messing around with a test version of MS SQL 2005 at the moment to house my test data.
Please see this image for the table layout, which shows how evrerything relates up:
The Subscriptions table is the 'Parent' table, the exch_mailboxes table is the 'Child' Element.
What I would like is for people to be able to search the Parent element for a subscription, once found they can click into it and then be presented with the child elements, or all the records from the exch_mailboxes that meet the criteria for an inner join across the tables.
Wondering what the best approach is for this?
I have some experience with throwing in SQL TableAdapters into a dataset.xsd page and then calling this into GridView, but updating the data is going to prove a bit trickier I would expect.
Any pointers welcome.
I've some basic Parent-Child data I want to work with for updates etc.
Am coding in Visual Studio 2010 using ASP.NET C# as my language of choice.
My DB in production is using MS SQL 2008 though I am messing around with a test version of MS SQL 2005 at the moment to house my test data.
Please see this image for the table layout, which shows how evrerything relates up:
The Subscriptions table is the 'Parent' table, the exch_mailboxes table is the 'Child' Element.
What I would like is for people to be able to search the Parent element for a subscription, once found they can click into it and then be presented with the child elements, or all the records from the exch_mailboxes that meet the criteria for an inner join across the tables.
Wondering what the best approach is for this?
I have some experience with throwing in SQL TableAdapters into a dataset.xsd page and then calling this into GridView, but updating the data is going to prove a bit trickier I would expect.
Any pointers welcome.