run stored procedure?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
Paul said:
I have been able to send input into a stored procedure I think, as shown
Click to expand...
below. Just wondering how to get the
output and actually call the procedure?
Me.SqlDataAdapter1.SelectCommand().Parameters("@EndDate").Value() = "1/6/2003"
Click to expand...
Me.SqlDataAdapter1.SelectCommand().Parameters("@StartDate").Value() =
"1/1/2003"
 
Back
Top