stored procedure into dataset

[cmsbuffet]

I have a stored procedure

GetZipcodesForDistance( _
                Application("outputTextBox"), _
                 Application("radiusTextBox"))

I would like to assign the query result of the procedure GetZipcodesForDistance into a data set zipcodedistance. I have a for loop to display the rows of the data set.

For Each rowDistance In zipcodedistance.Rows
                If rowDistance(1) = Application("outputTextBox") Then
            Page.Response.Write(" " & rowDistance(1) & " ")
                    End if
Next

However, I cannot find a method to assign each row of the query to each row of data set. Any hints?

Thanks.

 

[cmsbuffet]

I am trying to call the procedure above and to populate DataSet with the results of the procedure query. Thanks.

 

[ZenRaven]

You can insert the results from a stored procedure into a table with an Insert-Exec statement

INSERT #temp
EXEC MyProc(Param1, Param2)

You have to create the temp table with the correct number and type of column definitions beforehand. Is this what you're looking for? From what you've written it looks like you may actually be asking a vb question.