Member Avatar for BiplabDH

auto generate number in data base creates negative numbers in vb.net how to make it working perfectly.i am using vb.net using databindings please help me

  • 2 Contributors
  • 4 Replies
  • 362 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by BiplabDH

Recommended Answers

All 4 Replies

Member Avatar for Reverend Jim

What database are you using? What are the settings for the auto-generate column?

Member Avatar for BiplabDH

i am using ms access 2003 database. i am just using the autogenarate column directly from access as invoice number in vb.net when i am adding any data it automatically shows negative numbers like -1,-2,-3 and so on why this happenning i just dont understand

Member Avatar for Reverend Jim

For an auto increment field in Access you should have

Field Size: Long Integer
New Values: Increment

does that match what you have? What is the value of that column in the first database record?

Edited by Reverend Jim
Member Avatar for BiplabDH

Field Size: Long Integer
New Values: Increment both are ok in my database i have a products table having data irst column is

1 Invoice No=autonumber which is auto incremented then
2 product name=text,
3 name=text ,
4 date of issue=date/time,
5 quantity=text,
6 price=text
7 grand total=text

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.