CODEWITHSUNDEEP
c#winformstextboxbarcode
Haider Khattak
Haider Khattak

Reputation: 577

text box is giving error with differnt bar codes

i am using a barcode reader. when i place the cursor on the textbox1 and scan the barcode of an item it is copied in the textbox1. when other items barcodes are scanned i usually get error like "Invalid column name 'C902SA20K'." it only accepts the first one barcode which was entered in the textbox for the first time. when the barcode is entered in different textboxes other than the textbox1 only the first letter or alphabet is scanned and provides with the error "The conversion of the nvarchar value '8736900083240' overflowed an int column."

how can i make it accept all the barcodes.

Upvotes: 2

Views: 186

Answers (1)

Vivek Jain
Vivek Jain

Reputation: 3889

It seems as if the column or field that gets the value 8736900083240, is either int or is cast to int. This value is too big to be stored in an int field. An int32 field can store a max of 2147483647 and an unsigned int32 can store a max of 4294967295. You may like to use a long or a suitably sized data type for 8736900083240 value.

Upvotes: 1

Related Questions