TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
hey_mr_art
NA
17
0
Why do I get a 0 value for my @@identity field?
Jun 5 2004 1:54 AM
Good Day, I have a form that retrieves the next available auto-number value of a field in MSACCESS 2000 every time it loads, unfortunately it returns a 0 value. Here is my code: connection.Open(); int newid; OleDbCommand command = new OleDbCommand("Select @@identity From IssuanceHeader", connection); newid = (int) command.ExecuteScalar(); txtIssuanceNo.Text = newid.ToString(); connection.Close(); Is there something wrong?
Reply
Answers (
4
)
Looking for some advise
plz, How Can I Connect to data's Access?