how do I set datatypes in vb.net app to match data types in the sql 1

[seminewbee2005]

I designed a db with 4 related tables. Now I am designing a vb.net table that will be saving data to those tables. I am new to vb.net but the data types seem to be different.


I am using int 4 byte as datatype as identity column for primary keys in table. But Vb.Net in the dataset1.xds chooses short datatype. Is this correct. I have varchar for strings in sql and vb.net wants to use string datatype, is that kosker

field sql datatype what vb.net is choosing

Prim Key int 4 byte short 16 bit (ok makes sense)
Location varchar20 string

will it automatically choose correction for:
bit
datetime
small money

I am new to vb.net any tips as far as the matching datatypes in a vb.net app corresponding to the field of sql would be greatly appreciated.

 

[chrissie1]

Everything is fine the sqlclient will make all the neccessary adjusments to make it work. do not worry about a thing.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[seminewbee2005]

that what I like to hear!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thanks Chrissie1