You can use DataAdapter.Fill , it will create one table per result set
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"abc my vclass" <my********@myclass.com> wrote in message
news:O9**************@TK2MSFTNGP10.phx.gbl...
How to retrieve many resultsets from stored procedure and put to dataset?
If it can, is there any example code let me to know.
In order to avoid multiple trips to the database, I would like to fill
several tables in a DataSet with a single call to a stored procedure that
will return resultsets for the appropriate tables.
...
Hi, I searched through this newsgroup looking for an answer for this, but
didn't find any (it probably is here. Just didn't find it).
I am trying to retrieve information from two related tables,...
I have made the following stored procedure with the following select
statement
select * from user
select * from order, orderdetail where order.id=orderdetail.id
I know I can uses DataReader...
Hi
I am calling a DB2 stored procedure with 3 parameters. The last one is an inout parameter in which a value is returned (SQLCODE). I am using the DB2DataAdapter object's fill method to return a...
Stored procedures are faster and more efficient than in-line SQL
statements. In this article we will look at two SQL Server stored
procedures; one using an input parameter and one not, and see how...
How to generate a dataset from stored procedure which have many resultsets?
I try Dataset designer from VS2005, it only generate first table from stored
procedure on server explorer. Another...
Hi,
Using Visual Basic 2005 -- I have a stored procedure that returns
multiple resultsets. I fill a datareader (SQLDataReader to be exact)
with the results from a command object's ExecuteReader...
I am relatively inexperienced in using delegates and asynchronous
methods. I read several articles, and then I developed my own code
with a mission to improve the performance. Wow! I cannot...
Folks,
For designing WinApps, I do prefer to have the controls dragged and dropped
into the screen, mainly for datagridview controls. For that end, I normally
use the DataSet designer but...
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...