Use the SQL time field in asp.net/c #

The SQL statements in access are different from those in SQL Server. When I changed the SQL Server database to an Access database, I encountered some small setbacks and summarized them for reference.

Assume that there is a table article, and the article has the field edittime, which is of the "date/time" type. Take modifying edittime as an example.

Void Update ( Int Narticleid, String Strtitle, datetime timeedit)
{
Stringbuilder strsql =   New Stringbuilder ();
Strsql. append ( " Update article set Title = @ strtitle, edittime = @ timeedit where ArticleID = @ narticleid; " );
Oledbparameter [] arparas =   New Oledbparameter [ 3 ];
Arparas [ 0 ] =   New Oledbparameter ( " @ Strtitle " , Strtitle );
Arparas [ 1 ] =   New Oledbparameter ( " @ Timeedit " , Oledbtype. date );
Arparas [ 1 ]. Value = Timeedit;
Arparas [ 2 ] =   New Oledbparameter ( " @ Narticleid " , Narticleid );

Accesshelper. executesql (strsql. tostring (), arparas );
}

 

The key one is to set oledbparameter to oledbtype. Date.