Using stored procedure to fill dataset

Not that I am aware of. Why do you need to do this?

Uhm, a bit of confusion here. Sure you can use a stored procedure to fill a dataset, but you'll still use a SqlDataAdapter. You'll just use a SqlCommand for a stored procedure as the SelectCommand. If the stored procedure returns multiple result sets you need to set up TableMappings before calling Fill.

Rune

You have two ways of doing the same -
1.Add the following code in the stored procedure

CREATE PROCEDURE sp_TBL1 AS
select * from TBL1;
GO

Drag a DataGrid control from the toolbox to the form & add the following code to the Load event of the form

Dim DA As New SqlDataAdapter("SelData", SqlConnection1)
'SelData - Stored Proc
DA.SelectCommand.CommandType = CommandType.StoredProcedure
DA.TableMappings.Add("TBL1", "DS")
Dim DS As New DataSet ' Change this name to match .xsd file name.
DA.Fill(DS, "DS")
DataGrid1.DataSource = DS
DataGrid1.DataMember = "DS"

2. Use an ORM framework to simply drag and drop it in. I use DevForce Express and that works well for me.