run stored procedure?

[Guest]

I have been able to send input into a stored procedure I think, as shown below. Just wondering how to get the
output and actually call the procedure?
Me.SqlDataAdapter1.SelectCommand().Parameters("@EndDate").Value() = "1/6/2003"
Me.SqlDataAdapter1.SelectCommand().Parameters("@StartDate").Value() = "1/1/2003"
Also I could not find the value property of the parameters the wizard was suposed to create.
Thanks Paul.

 

[William Ryan]

Here's how to call a Stored Proc with Params....
http://www.knowdotnet.com/articles/storedprocsvb.html

As far as getting data back, Read Retrieving the Gazoutas: Understanding SQL
Server Return Codes and Output Parameters
http://www.betav.com/msdn_magazine.htm By Bill Vaughn.

HTH,

BIll

I have been able to send input into a stored procedure I think, as shown

below. Just wondering how to get the

output and actually call the procedure?
Me.SqlDataAdapter1.SelectCommand().Parameters("@EndDate").Value() = "1/6/2003"

Me.SqlDataAdapter1.SelectCommand().Parameters("@StartDate").Value() =
"1/1/2003"