February 28, 2008 01:28 PM

Managing Hierarchical Rowsets

Build a TableAdapter application fed by stored procedures
Rating: (0)
SQL Server Magazine
InstantDoc ID #97182
A developer recently asked me how to set up a TableAdapter application that’s fed by stored procedures instead of base tables. Stored procedures optimize application, database, and development team performance as well as simplify maintenance. However, using them as the rowset source for forms-over-data applications is thinly documented and requires some manual setup and custom coding— especially when you’re working with stored proceduregenerated rowsets that h...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

I tried to "download" the code as described in the article. The complete Visual Studio project is not included in the download as the article states. Could you please provide the VS project/source code for the program described in the article?

Thanks in advice.

STEPHEN10/17/2008 12:16:15 PM


Hi TomMohoric,
Thanks for commenting on this article. The following is William Vaughn's response to your comment:

"IIRC, the database used in the article, is one of the sample databases downloadable from the Microsoft SQL Server site. http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en."


Please feel free to contact me directly at megan.bearly@penton.com if you have anymore questions.
Thanks!

Megan Bearly
Associate Editor, SQL Server Magazine
megan.bearly@penton.com

meganbearly 8/25/2008 4:27:40 PM


There doesn't appear to be a CREATE database script included.

TomMohoric7/29/2008 11:07:46 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS