Conversion failed when converting date and/or time from character string.
i always got above error when i try to insert new rows to db
i think i did everything correctly but i have no clue why it can'.
Can anyone help?
Here is my code.
sqlcmd2 = "insert into MC_TestPOM (IssuerBIN,IssuerCurrencyID,IssuerCountryName,IssuerCountryName2,IssuerCountryName3"
+ ",IssuerBankName,IssuerDateTime,IssuerBINFrom)"
+ "VALUES (@issuerBIN, @issuerCurrencyID, @issuerCountryName, @issuerCountryName2, @issuerCountryName3, @issuerBankName, @issuerBINFrom," + "@issuerDateTime" + ")";
Database database = this.getDatabase();
DbCommand sqlStringCommand = getDatabase().GetSqlStringCommand(sqlcmd2);
database.AddInParameter(sqlStringCommand, "issuerBIN", DbType.String, BinNo);
database.AddInParameter(sqlStringCommand, "issuerCurrencyID", DbType.Int16, Cur.currencyID);
database.AddInParameter(sqlStringCommand, "issuerCountryName", DbType.String, Cur.A3);
database.AddInParameter(sqlStringCommand, "issuerCountryName2", DbType.String, Cur.A2);
database.AddInParameter(sqlStringCommand, "issuerCountryName3", DbType.String, Cur.CountryName);
database.AddInParameter(sqlStringCommand, "issuerBankName", DbType.String, Bankname);
database.AddInParameter(sqlStringCommand, "issuerBINFrom", DbType.String, Frombankname);
database.AddInParameter(sqlStringCommand, "issuerDateTime", DbType.DateTime,(object)DateTime.Now);
getDatabase().ExecuteNonQuery(sqlStringCommand);