C#

string SQL="UPDATE [references] SET  name=?,address=?,zip_code=?,date=? WHERE referenceID = 1115224993"

OleDbCommand cmd=new OleDbCommand(...);
...
cmd.Parameters.Add("date", OleDbType.Date).Value=DateTime.Today;
...

Dalek Dave wrote:

I like that!

string SQL="UPDATE tableName SET anInt=@anInt, aString=@aString, anotherInt=@anInt, aDate=@aDate WHERE ..."
OleDbCommand cmd=new OleDbCommand(...);
cmd.Parameters.Add("@anInt", OleDbType.Int).Value=12;
cmd.Parameters.Add("@aString", OleDbType.VarChar).Value="abc";
// no need to give the third parameter as it re-uses the first one
cmd.Parameters.Add("@aDate", OleDbType.Date).Value=DateTime.Today;

Luc Pattyn wrote:

Do you have any reference?

Peter_in_2780 wrote:

Do I smell a Tip/trick or article in the making?

Peter_in_2780 wrote:

Good to see you again

Luc Pattyn wrote:

those stupid OleDbTypes/SqlTypes enums the parameters need.

cmd.Parameters.Add("@aDate", OleDbType.Date).Value=DateTime.Today;

                                 ^
                                 |
                                 |
                                 |

protected virtual System.Data.IDbDataParameter
AddParameter
(
    string Name
,
    object Value
)
{
    System.Data.IDbDataParameter result = this.command.CreateParameter() ;

    result.ParameterName = Name ;

    result.Value = Value ;

    this.command.Parameters.Add ( result ) ;

    return ( result ) ;
}

Luc Pattyn wrote:

interfaces here, it allowed me to reduce my code

Luc Pattyn wrote:

Access doesn't want to store DateTime

protected override System.Data.IDbDataParameter
AddParameter
(
    string Name
,
    object Value
)
{
    System.Data.OleDb.OleDbParameter result =
        (System.Data.OleDb.OleDbParameter) base.AddParameter ( Name , Value ) ;

    if ( Value is System.DateTime )
    {
        result.OleDbType = System.Data.OleDb.OleDbType.Date ;
    }

    return ( result ) ;
}

Luc Pattyn wrote:

I'm good now