i m inserting values in access database but value is not ptresent in database

[arvindmishra]

i m inserting values in access database it displays message value is inserted but value is not ptresent in database.

I m using following code

OleDbConnection cnn = new OleDbConnection();
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\medical.mdb";
cnn.Open();
string str = "insert into medicin(medicinename,companyname,quantity,price,mf gdate,expirydate,orderingdate,deliverydate) values('" + comboBox1.Text + "','" + comboBox2.Text + "','" + textBox1.Text + "','" + textBox2.Text + "','" + dateTimePicker1.Value + "','" + dateTimePicker2.Value + "','" + dateTimePicker3.Value + "','" + dateTimePicker4.Value + "')";
OleDbCommand cmd = new OleDbCommand(str, cnn);
OleDbDataAdapter da = new OleDbDataAdapter(str, cnn);
DataSet ds = new DataSet();
da.Fill(ds, str);
//showDataInGrid();
MessageBox.Show("Record saved!");

[jkmyoung]

You have to actually run the command!
http://msdn.microsoft.com/en-us/libr...ry(VS.71).aspx