Posted on: 4/8/2011 12:04:31 PM | Views : 573

This is my Insert statment and I keep getting this error message for TypeID and I have no idea why.  It's spelled correctly.  I'm using @TypeID because a value is actually going to be passed in and that's why it's not specific in the Insert statement.  For testing, I made @TypeID = 1.  Thanks in advance.
 
 
Dim ds2 As New SqlDataSource ds2.ConnectionString = ConfigurationManager.ConnectionStrings("CroftDBConnectionString").ConnectionString ds2.InsertCommandType = SqlDataSourceCommandType.Text ds2.InsertCommand = "INSERT INTO AllocationOnePercents (TypeID, ClientID, Autex, SortOrder, MoxyOrderID) VALUES (@TypeID,@ClientID,@Autex,@SortOrder,@MoxyOrderID)" ds2.InsertParameters.Add("MoxyOrderID", MoxyOrderIDTB.Text) ds2.InsertParameters.Add("TypeID", "1") ds2.InsertParameters.Add("SortOrder", "ZZZZZZZZ") For Ea ...

Go to the complete details ...