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 ...