tableadapter convert or something else  
Author Message
doubletrouble





PostPosted: Visual Basic Express Edition, tableadapter convert or something else Top

hi,
for a task at school I need to make a program that calls up data from the database with a barcodescanner, th problem is that the fill of my tableadapter needs an integer but the barcode number is to big to be an integer

any one got some advice



Visual Studio Express Editions41  
 
 
ReneeC





PostPosted: Visual Basic Express Edition, tableadapter convert or something else Top

How large is the number and how much flexibility do you have in the design of your database



 
 
Bruno Yu - MSFT





PostPosted: Visual Basic Express Edition, tableadapter convert or something else Top

doubletrouble,

The TableAdapter object is filled by dataset, I suggest you to redesign your DataTable in DataSet, firstly make the barcode number to string, then convert it to integer in your memory datatable.

Actually, there is soomething wrong with your database. I suggest you to change the certain data type for your field if it is possible.