sql server - Inserting multiple data tables from stored procedure into strongly typed/named dataset -


i have sql server stored procedure returns several tables. accessing these in vb via data adapter table mapping in following method:

da.selectcommand = sqlcommand da.tablemappings.add("table", "settingstable") da.tablemappings.add("table1", "maindatatable")  da.fill(dsresult) 

the issue have here around source table name. these automatically generate table, table1, table2 etc. there way can give these tables names coming out of stored procedure? depending on parameters may not return tables every time, table map "maindatatable" "table1", , "table2".

are there solutions this? need keep compatibility far sql server 2008 r2 if possible.

many in advance.


Comments

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -