Jump to content
Xtreme .Net Talk

Recommended Posts

Posted

What is this first parameter if I'm using DataAdapter and specify "use existing SQL stored procedure"?

 

Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))

 

Where or how should I then set .parameters(0).value = "blah" and stuff? Is this Return Value param(0) and the next one param(1) or I should just ignore the first one and then actualy the second created parameter is param(0)?

Confusing...

Posted

anywho :) I solved the problem (there was some type error Int and String :rolleyes: ). But the thing is that I commented-out this parameter above, and renumbered param(0).value as if that parameter never existed.

It works just fine.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...