How do I solve this error?

See more:

SQL

C#3.5

Attempting to save transaction details by query . at the press of the save button i get this error msg...."Implicit conversion from data type datetime to decimal is not allowed. Use the CONVERT function to run this query".

i checked the values for errors such as a unsuitable datatype, but they all were saved to the datetime datatype accordingly. checked the database that too was in the datetime datatype.

What could the problem be for this error?

What I have tried:

code in getter setter class;

public DateTime transaction_date { get; set; }

code in saving the value for variable, transaction_ date;

transaction.transaction_date = DateTime.Now;

The Query to insert value into database.

string sql = "INSERT INTO [transaction] (Dea_Cust_id, Grandtotal,transaction_date,  tax, discount) VALUES (@Dea_Cust_id,@transaction_date, @Grandtotal, @tax, @discount); SELECT @@IDENTITY;";

cmd.Parameters.AddWithValue("@transaction_date", transaction.transaction_date);