asp.net problem autonumber?

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

Guest
I want to add clients in my database.
I've done autonumber in the database (access)
why does visual studio take this not into account?

if I do klantid += 1 then it gives number 1
if I do klantid += 8 then it gives number 8

I want just an autonumber but what do I type??


Protected Sub cmdversturen_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdversturen.Click

Dim klantid As Integer = 0
Dim naam As String = txtNaam.Text
Dim voornaam As String = txtVoornaam.Text
Dim gebruikersnaam As String = txtgebruikersnaam.Text
Dim wachtwoord As String = txtwachtwoord.Text


klantid += 8

serviceKlant.invoegenklant(klantid, naam, voornaam, gebruikersnaam, wachtwoord)

Response.Redirect("ingelogd.aspx")
End Sub


thanks in advance
 
Because you haven't provided any means in the logic to know what the current max is, not that it would matter anyway because you cannot explicitly define an auto increment identity field anyway. All you have to do is remove the klantid references and it should work. For example:

Dim klantid As Integer = 0 'DELETE
Dim naam As String = txtNaam.Text
Dim voornaam As String = txtVoornaam.Text
Dim gebruikersnaam As String = txtgebruikersnaam.Text
Dim wachtwoord As String = txtwachtwoord.Text


klantid += 8 'DELETE

Change
serviceKlant.invoegenklant(klantid, naam, voornaam, gebruikersnaam, wachtwoord)

To (and update subsequent logic accordingly)
serviceKlant.invoegenklant(naam, voornaam, gebruikersnaam, wachtwoord)
 
Back
Top