Parameters passing to STORED PROCEDURE

Results 1 to 3 of 3

Thread: Parameters passing to STORED PROCEDURE

  1. #1
    pari Guest

    Default Parameters passing to STORED PROCEDURE

    how do i pass parameters to a stored proc...<BR>i have three values frm a form how do i pass these to the stored proc whic is an insert query.<BR>plz help<BR>thnx in adv<BR>pari

  2. #2
    Join Date
    Dec 1969
    Posts
    1,435

    Default RE: Parameters passing to STORED PROCEDURE

    You first create a parameter object using Command.CreateParameter, set it&#039s datatype, direction and value, and then append it to the Parameters collection of your Command object using Command.Parameters.Append(objParam). Rinse and repeat as needed.<BR><BR>Dunc

  3. #3
    Join Date
    Dec 1969
    Posts
    7

    Default RE: Parameters passing to STORED PROCEDURE

    Hi Duncan, <BR><BR>See my post of today on using this technique with a Text datatype as the input parameter.<BR><BR>Maybe you can help.<BR>David

Posting Permissions

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