A Little Direction - Please

[just_the_basix]

Just looking for someone to give me a little direction on the design of my ASP.Net app. Basically it goes like this:
Connect to SQL
query 13 different tables in the same DB
main table is mostly foreign keys from different tables
need to use these keys to look up text, etc. on the other 12 tables
End Product should be like this:
User selects an entry from a drop down box
query db with that entry and get the selections from all tables
display them
This can't be that difficult, but I am refusing to band-aid it and use classic ASP. I got .NET and intend to use it. I have tried several things (13 different data adapters and 13 different datasets, made custom classes that basically mirror the tables, but I guess I am too stupid to make it work, cause it ain't) Any direction would be greatly appreciated. Thanks in advance

[Webforumz Staff]

This isn't specific to .NET really, but you'll substantially improve your performance and simplify your .NET code by doing as much of this as possible with Stored Procedures within SQL itself.