Hi,
I'm developing a small database using vb.net and MS SQL Server in MS Visual Studio. I developed a data source from the database and dragged a table onto a form in the project using the Data Binding Technique (all code was automatically generated).
My problem is that I'm unable to auto-increment my primary key on my form.
When I click 'add new' on the navigator toolbar on the top, the ID textbox (which holds the primary key), stays empty, as no number enters the textbox, not even -1 as I have seen on other example databases. Therefore I'm not able to save information.
When I add data manually to the database, it increments fine as I have set these properties in the database:
Thanks in advance
I'm developing a small database using vb.net and MS SQL Server in MS Visual Studio. I developed a data source from the database and dragged a table onto a form in the project using the Data Binding Technique (all code was automatically generated).
My problem is that I'm unable to auto-increment my primary key on my form.
When I click 'add new' on the navigator toolbar on the top, the ID textbox (which holds the primary key), stays empty, as no number enters the textbox, not even -1 as I have seen on other example databases. Therefore I'm not able to save information.
When I add data manually to the database, it increments fine as I have set these properties in the database:
- Identity Spec = yes
- Is Identity = yes
- Identity Increment = 1
- identity seed = 1
Thanks in advance