VB.Net SQL Database

Posted on 2010-01-04
Medium Priority
Last Modified: 2013-12-20
Hi Guys,

I am trying to create a database for a program I am creating in VB.Net 2008 Express. One of the columns in the table needs to be an auto number. What data type should I set the column to so that I can achieve this?

Question by:lfaulkneruk
LVL 11

Accepted Solution

ICaldwell earned 1000 total points
ID: 26173680
When you say auto number I am thinking you want the database to auto assign it, is this correct?

I would create it as an integer, primary key and set the column to to auto increment...

Assisted Solution

rdoran0928 earned 1000 total points
ID: 26174624
The specifics vary with the DBMS you use.  For SQL Server an "auto increment" column needs to have Identity Specification set to Yes.

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month16 days, 6 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question