Correct syntax for returning a dataset

Joined
Oct 7, 2005
Messages
10
I realise this is a simple question but I wonder if anyone can help me with this:

Untill now i have been using Datareaders for example;

Public Class Catalog
Public Shared Function SP_GetBB() As SqlDataReader

Create the connection object
Dim connection As New SqlConnection(ConnectionString)
Create and initialize the command object
Dim command As New SqlCommand("SP_GetBB", connection)
command.CommandType = CommandType.StoredProcedure
Open the connection
connection.Open()
Return a SqlDataReader to the calling function
Return command.ExecuteReader(CommandBehavior.CloseConnection)
End Function

Can anyone tell me how to convert the above to return a Dataset
I have got this far but am not sure how to finish:

Public Class Catalog
Public Shared Function SP_GetBB() As System.Data.DataSet
Create the connection object
Dim connection As New SqlConnection(ConnectionString)
Create and initialize the command object
Dim command As New SqlCommand("SP_GetBB", connection)
command.CommandType = CommandType.StoredProcedure.........
...................................

many thanks

martin
 
Dim ds as New DataSet
Dim da as New DataAdapter

da.SelectCommand = cmd

da.Fill(ds)

Notice that the data adapter opens and closes the connection. Remember to clean up your objects too.
 
bri189a said:
Dim ds as New DataSet
Dim da as New DataAdapter

da.SelectCommand = cmd

da.Fill(ds)

Notice that the data adapter opens and closes the connection. Remember to clean up your objects too.

many thanks for your help with this

martin
 
Back
Top