Using StoredProcedure

IxiRancid

Well-known member
Joined
Jun 16, 2004
Messages
104
Location
Europe
What is this first parameter if Im 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...
 
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.
 
Back
Top