IxiRancid Posted November 3, 2005 Posted November 3, 2005 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... Quote
IxiRancid Posted November 3, 2005 Author Posted November 3, 2005 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. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.