OleDbType? in MS-Access

J

joe_pool_is

Well-known member
Joined
Jan 18, 2004
Messages
451
Location
Texas
I have a MS Access database with the entries formatted differently: Text, Memo, Hyperlink, Date/Time, Yes/No.

How would I create OleDbType parameters to match these?
 
I think setting the DbType will do the trick. Yes/No -> DbType.Boolean, everything else is a string.
One think to note, when storing DateTime objects, you must store it in the parameter object as a string. I dont know what the DbType should be in that scenario (DbType.DateTime or DbType.String).
 
HJB417 said:
One think to note, when storing DateTime objects, you must store it in the parameter object as a string.
Click to expand...
No. . . use a DBType.DateTime. using string defeats the reason for using the parameters. If you simply assign a System.DateTime to a DBType.DateTime you dont have to worry about locale.

Most of the time, I find, you can get away without having to specify the Data type. Play around with them. It should be simple to figure it out. When I get to work I will hunt down a translation utility. Something tells me I posted it already on this forum.
 
Back
Top