running a storec proc in vb.net?

[Brian Henry]

How would i execute this stored proc in vb.net?

this is how i do it in sql... how would i do this in ado.net with vb.net?
thanks!
exec dbo.updateAolCount nameText,"12/27/2003"
(2 paramaters there)

thanks!

 

[Val Mazur]

Hi Brian,

Check next KBs with an example how to call stored procedures with parameters

http://support.microsoft.com/default.aspx?scid=kb;en-us;308049&Product=adonet

http://support.microsoft.com/default.aspx?scid=kb;en-us;321902&Product=adonet

 

[Brian Henry]

thanks, just found them as u posted that hehe

Hi Brian,

Check next KBs with an example how to call stored procedures with parameters
http://support.microsoft.com/default.aspx?scid=kb;en-us;308049&Product=adonet
http://support.microsoft.com/default.aspx?scid=kb;en-us;321902&Product=adonet

--
Val Mazur
Microsoft MVP
Check Virus Alert, stay updated
http://www.microsoft.com/security/incident/blast.asp