Results 1 to 5 of 5

Thread: Adding Parameters to Stored Procedures

Threaded View

  1. Jul 23rd, 2004, 09:42 AM #1
    stevegreen
    stevegreen is offline

    Thread Starter
    New Member
    Join Date
    Jul 2004
    Posts
    12

    Adding Parameters to Stored Procedures

    Hello
    I'm a bit of a beginer with VB.net and am having some bother adding parameters to a stored procedure I need to execute. I want to execute a stored procedure that in SQL I can do using

    exec sp_spaceused Customer

    Not sure how to do this in VB.net. To get the stored proc running I'm doing the following

    cStored.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc
    cStored.CommandText = "sp_spaceused"
    cStored.ActiveConnection = cConnection

    recRS = cStored.Execute

    Can someone please tell me how I add the Customer parameter.

    Cheers

    Steve
    Last edited by stevegreen; Jul 23rd, 2004 at 10:08 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width