Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting TableNames from Stored Proc
Message
From
03/03/2004 17:59:52
 
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00882930
Message ID:
00882938
Views:
14
Victor,

That's one of the downsides of using a StoredProc that returns multiple tables. No matter what you do, the table names will always be table, Table1, Table2, etc. However, I still recommend using Stored Procs as a "best practices" methodology. How did we solve the problem? Typed DataSets. Using Typed DataSets, we further sub-classed the auto-generated class to change the table names to meaningful names, so that now we can access them like ds.ProductList and ds.CategoryList. Do you need an example of how to do this or can you figure it out ok by yourself?

~~Bonnie
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform