I hope someone can help, i've spent more then two days trying to get this to work. I have re-worked the code many times. I have a aspx page the user enters info, i create the sql connection, command object, add parameters, execute, a recrod gets added to
the sql table but all the values are null. I have the fields set to null for the sake of troubleshooting. I have verified that I can get at the values I don't understand why thye are not getting assigned to the parameters and passed to SQL Server.
Here is the code:
Dim mycon As SqlConnection
Dim myCmd As SqlCommand
Dim mySQL As String = ""
Dim iDVSID As Integer = 0
Dim iRtn As Integer = 10
mySQL = ConfigurationManager.ConnectionStrings("DVSConnectionString").ConnectionString
mycon = New SqlConnection(mySQL)
myCmd = New SqlCommand
myCmd.CommandType = SqlDataSourceCommandType.StoredProcedure
myCmd.CommandText = "usp_InsertDVSLog" ...
Go to the complete details ...