selamlar
com.ExecuteNonQuery(); dedıgımde aldıgım hata "Ölçüt ifadesinde veri türü uyuşmazlığı." bir turlu çözemedım neydne kaynaklı
OleDbCommand com = new OleDbCommand("insert into STOCK_SALES(CAID,FICHENO,SALESDATE,BARCODE,SALESPRICE,PRICEVAT,UNIT,CDATE,CUSERID,STATUS) values(?,?,?,?,?,?,?,?,?,?)");
com.CommandType = System.Data.CommandType.Text;
com.Parameters.AddWithValue("CAID", DropDownList1.SelectedValue);
com.Parameters.AddWithValue("FICHENO",txtFisNo.Text );
com.Parameters.AddWithValue("SALESDATE", Convert.ToDateTime(txtTarih.Text));
com.Parameters.AddWithValue("BARCODE",GridUrunSatis.Rows[i].Cells[0].Text);
com.Parameters.AddWithValue("SALESPRICE",Convert.ToDecimal(GridUrunSatis.Rows[i].Cells[2].Text));
com.Parameters.AddWithValue("PRICEVAT", Convert.ToInt32(GridUrunSatis.Rows[i].Cells[3].Text.Replace("%", "")));
com.Parameters.AddWithValue("UNIT", Convert.ToInt32(GridUrunSatis.Rows[i].Cells[4].Text));
com.Parameters.AddWithValue("CDATE", DateTime.Now);
com.Parameters.AddWithValue("CUSERID", Session["Id"]);
com.Parameters.AddWithValue("STATUS", 0);
com.Connection = CmTrClass.baglanti;
CmTrClass.baglanti.Open();
com.ExecuteNonQuery();
CmTrClass.baglanti.Close();DB: