Data types in VB.net do not match up with ones in MSDE

I am trying to match my data type in vb to the data structure I am setting up in MSDE.  I am using ASP.net WebMatrix to create the database in MSDE.  In my vb.net program I Dim my variables to Int16, Boolean, and String.  What should I match them to in MSDE.  All I have to choose from is Int, Number, VarChar, Char, no Boolean exist.

Thanks
Kenny
kwh3856Asked:
Who is Participating?
 
DJ_Back-QConnect With a Mentor Commented:
Int16 = Int
Boolean = Bit (this will be either 0 or 1, convert it using ctype)
String = VarChar


Andre,

MCSD
0
 
DJ_Back-QCommented:
Also depending on the version you have, there is also a text field type now, you can use this instead of varchar or nvarchar.
0
 
DJ_Back-QCommented:
Ho and once again, Int16 would also fit in smallint (I always forget about this type)
0
 
kwh3856Author Commented:
Thanks....I appreciate the quick response.

Kenny
0
 
DJ_Back-QCommented:
Always glad to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.