error converting data type varchar to numeric c#

[vixyv]

SqlConnection connn = new Sql Connection(conString);

connn.Open();

if (connn.State == System.Data.ConnectionState.Open)

{

string q = "Insert into CashIn values ('" + cidTP.Value.ToString("yyy-MM-dd") + "','" + tbtr.Text.ToString() + "')";

SqlCommand cmd = new SqlCommand(q, connn);

cmd.ExecuteNonQuery();

}

Continue reading...