I Have a reg page where user can reg.
But now I have problems with insert.
What is the problem here.
Can someone help me
The table where I want to store values are named login and have columns(UID=Identity, Username, Password, Active, Email, Activationcode)
Dim loConn as SqlConnection
Dim myCommand as SqlCommand
Dim InsertCmd as String
loConn = New SqlConnection("Server=******; database=****; UID=****; PWD=*******")
insertCmd = "insert into Login values (@Username, @Password, @email, @Activationcode);"
myCommand = New SqlCommand(InsertCmd, loConn)
myCommand.Parameters.Add(New SqlParameter("@UID", SqlDBType.int))
myCommand.Parameters("@UID").Direction = ParameterDirection.Output
myCommand.Parameters.Add(New SqlParameter("@Username", SqlDbType.nVarChar, 50))
myCommand.Parameters("@Username").value = Username.value
myCommand.Parameters.Add(New SqlParameter("@Password", SqlDbType.nVarChar, 50))
myCommand.Parameters("@Password").value = Password.value
myCommand.Parameters.Add(New SqlParameter("@email", SqlDbType.nVarChar, 50))
myCommand.Parameters("@email").value = email.value
myCommand.Parameters.Add(New SqlParameter("@Active", SqlDbType.int))
myCommand.Parameters("@Active").value = "0"
myCommand.Parameters.Add(New SqlParameter("@Activationcode", SqlDbType.nVarChar, 50))
myCommand.Parameters("@Activationcode").value = activecode.value
myCommand.Connection.open()
myCommand.ExecuteNonQuery()
myCommand.Connection.Close()

Your INSERT cmd states:

"insert into Login values (@Username, @Password, @email, @Activationcode);"

You then attempt the following, without declaring @Active in your INSERT statement:

myCommand.Parameters("@Active").value = "0"
myCommand.Parameters.Add(New SqlParameter("@Activationcode", SqlDbType.nVarChar, 50))

This should surely give you an error as @Active is not declared in your SQL statement.

- A.Kahtava