OleDbType? in MS-Access

[joe_pool_is]

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?

[HJB417]

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 don't know what the DbType should be in that scenario (DbType.DateTime or DbType.String).

[Joe Mamma]

One think to note' date=' when storing DateTime objects, you must store it in the parameter object as a string. [/quote']

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 don't 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.