Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx_beginners thread: How Update using SP ??


Message #1 by "Nick" <nick@g...> on Fri, 12 Jul 2002 10:34:28 +0700
This is a multi-part message in MIME format.

------=_NextPart_000_0042_01C2298F.B397D710
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi..
I want to know how the tag for update , delete using SQL Store 
Procedure, i don't understand how to place the parameters, please some 
one tell me.. and give me some samples
thanks



Message #2 by "Carole D Sullivan" <carolesullivan@e...> on Mon, 15 Jul 2002 16:01:24
Connection can be opened after Parameters are set.

Set a parameter for each stored procedure argument that you have.

conPWA.Open()
     'delete all previous PWAF records from this session
     SqlDeleteCommand1.Parameters("@Original_PWAF_SessionID").Value = 
Session.SessionID

        SqlDeleteCommand1.ExecuteReader()

        conPWA.Close()

Carole Sullivan 


> This is a multi-part message in MIME format.

------=_NextPart_000_0042_01C2298F.B397D710
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi..
I want to know how the tag for update , delete using SQL Store 
Procedure, i don't understand how to place the parameters, please some 
one tell me.. and give me some samples
thanks




  Return to Index