Populating a dataset with a stored procedure

My previews comment has some errors
Try this
        Dim MySqlDataReader As SqlDataReader
        Dim MyConnection As SqlConnection
        Dim MyCommand As SqlCommand
        Dim MyConnectionString As String = "Your connection string here"

        Dim StartDate As Date
        Dim EndDate As Date

        ' Assign the values of the textboxes

        MyConnection = New SqlConnection(MyConnectionString)
        MyCommand = New SqlCommand("MyStoreProcedure", MyConnection)

        MyCommand.CommandType = CommandType.StoredProcedure

        MyCommand.Parameters.Add(New SqlParameter("@StartDate", SqlDbType.DateTime))
        MyCommand.Parameters("@StartDate ").Value = StartDate

        MyCommand.Parameters.Add(New SqlParameter("@EndDate", SqlDbType.DateTime))
        MyCommand.Parameters("@EndDate").Value = EndDate

        MySqlDataReader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection)

More info
http://www.dotnetjunkies.com/quickstart/aspplus/doc/webdataaccess.aspx#storedprocs

You can create a SqlDataAdapter instead of an sqlCommand and then use it to fill a dataset. But if you are just showing the data, it is more efficient to use the sqlCommand and the sqlDatareader

using sqlDataAdapter and dataset

        Dim MyCommand As SqlDataAdapter
Dim DS As DataSet
        MyCommand = New SqlDataAdapter("MyStoreProcedure", MyConnection)

        MyCommand.SelectCommand.CommandType = CommandType.StoredProcedure

        MyCommand.SelectCommand.Parameters.Add(New SqlParameter("@StartDate", SqlDbType.DateTime))
        MyCommand.SelectCommand.Parameters("@StartDate").Value = StartDate

        MyCommand.SelectCommand.Parameters.Add(New SqlParameter("@EndDate", SqlDbType.DateTime))
        MyCommand.SelectCommand.Parameters("@EndDate").Value = EndDate

        DS = New DataSet
        MyCommand.Fill(DS, "Sales")

To populate a dataset with a stored procedure given the 2 parameters with SQLClient could be done the following way

Imports System.Data.SqlClient

Public Class Sample

  Public Shared Sub Main()
            Dim nwindConn As SqlConnection = New SqlConnection("data source= YourServerName ;initial catalog= YourDataBaseName ;persist security info=False;user id=YourUserName;packet size=4096;password= YourPassword")
   
            Dim cmdSQL as New SqlClient.SqlCommand
            Dim SqlParam as New SqlClient.SqlParameter
            Dim sqlDA As New SqlClient.SqlDataAdapter

            nwindConn.Open()

            cmdSQL.Connection = sqlLazarus
            cmdSQL.CommandType = CommandType.StoredProcedure
            cmdSQL.CommandText = "YourStoredProcedureNameHere"

            sqlParam = cmdSQL.Parameters.Add("@StartDate", sqlDbType.DateTime)
            sqlParam.Direction = ParameterDirection.Input
            sqlParam.Value = "YourDateTimeValueInput"

            sqlParam = cmdSQL.Parameters.Add("@EndDate", sqlDbType.DateTime)
            sqlParam.Direction = ParameterDirection.Input
            sqlParam.Value = "YourDateTimeValue2ndInput"

            sqlDA.SelectCommand = cmdSQL

            Dim dsDataSet As New DataSet
            sqlDA.Fill(dsDataSet, "YourDataSet")
  End Sub
End Class

'That's about it... the dataset would be filled with the rows retrieved from the stored procedure.

Hope that helps

[DataSet - VB.NET]

Imports System.Data
Imports System.Data.SqlClient

' Assume you have string variables contain the following:
' sConnStr - a connection string
' sStoredProcName - stored procedure name
' startDate - start date
' endDate - endDate

' Create instance of SqlConnection object
Dim oConn As SqlConnection = new SqlConnection(sConnStr)
oConn.Open()

' Create instance of SqlCommand object
Dim cmd As New SqlCommand()

' Associate the connection with the command
cmd.Connection = oConn

' Set the command type
cmd.CommandType = CommandType.StoredProcedure

' Set the command text (stored procedure name or SQL statement)
cmd.CommandText = sStoredProcName

' Add parameters to the command
cmd.AddParameter("@StartDate", SqlDbType.DateTime).Value = startDate
cmd.AddParameter("@EndDate", SqlDbType.DateTime).Value = endDate

' Create instance of DataSet object
Dim ds As New DataSet()

// Create Instance of SqlDataAdapter
Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)

' Fill the DataSet
da.Fill(ds)

The dataset contains the resultset generated by the command

wow.. so many experts have posted answer here..

Also, I recommend you eat something light first. Some toast would be good. ADO .NET can make your stomach hurt.

Haha, toast...  Good suggestion.  Hey, this is working great, thanks for all of the help!  I have one more question to get this working.  I'm using the datareader (but I don't think it matters...).  Since I'm creating this datareader/dataset in code, the object (MySqlDataReader) obviously doesn't show up in the solution explorer pane.  How can I actually add these fields to my report?  I know a simple (and probably a poor) solution.  I could modify the SP to dump the data into a temp table, then create a dataset from that temp table and fill it after the code to fire the sp with the parameters executes.  Somehow I doubt that is the recommended ado.net way of doing this.  Any suggestions?  I think i'm going to have to split the points here b/c you guys have all been so helpful.  Thanks so much