I need to save number as decimal in my "amount" column. How can I do it please. I inform that the type of my column is currency.
conn.Open();
OleDbCommand comm = new OleDbCommand();
comm.Connection = conn;
connstr = "SELECT COUNT(*) FROM Test WHERE [Dat] = @dat";
comm.CommandText = connstr;
comm.Parameters.Clear();
comm.Parameters.AddWithValue("@dat", data.Value);
int numRecords = (int)comm.ExecuteScalar();
if (numRecords == 0)
{
//connstr = "INSERT INTO Test([dat],[amount])VALUES(@date,@amount)";
comm.CommandText = connstr;
comm.Parameters.Clear();
comm.Parameters.AddWithValue("@dat", date.Value);
comm.Parameters.AddWithValue("@amount", txtAmount.Text);
if (MessageBox.Show("Are you sure to save?", "Janela de gravação", MessageBoxButtons.YesNo) == DialogResult.Yes)
comm.ExecuteNonQuery();
}
else
{
MessageBox.Show("There no product", dtFluxoCaixa.Text);
}
conn.Close();