Click here to Skip to main content
15,867,838 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.

C#
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);
Posted
Comments
aarif moh shaikh 24-Sep-15 1:11am    
just remove (object) before DateTime.Now
DamithSL 24-Sep-15 1:12am    
i think OP has issue with parameter order. pls check my answer below.
aarif moh shaikh 24-Sep-15 4:04am    
yes... Thanks

1 solution

incorrect parameter order in column names; column names given as IssuerDateTime,IssuerBINFrom but parameter given as @issuerBINFrom, @issuerDateTime. try as below
SQL
sqlcmd2 ="insert into MC_TestPOM (IssuerBIN, IssuerCurrencyID, IssuerCountryName, IssuerCountryName2, IssuerCountryName3, IssuerBankName, IssuerBINFrom,IssuerDateTime ) VALUES (@issuerBIN, @issuerCurrencyID, @issuerCountryName, @issuerCountryName2, @issuerCountryName3, @issuerBankName, @issuerBINFrom, @issuerDateTime)";
 
Share this answer
 
Comments
Real_Criffer 24-Sep-15 1:14am    
Thank you you save me i didn't notice that i have fix it like 2 hour ><'
DamithSL 24-Sep-15 1:15am    
You are welcome!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900