Inserting data into access database through asp.net

[aiconan]

I am using following code for inserting data into access database through asp.net (c#) but found error that error in INSERT INTO statement.. here problem is just the date..How can we convert date into format like this #dd-mmm-yyyy#. because it allows this but i m not finding any way to convert date in this format.\[code\]String query = "INSERT INTO order(orderDesc, orderType, orderCost, orderQty, orderContent, orderStatus, orderDate, orderShipDate, orderDeposit) VALUES (@desc,@type,@cost,@qty,@content,@status,@date,@shipdate,@deposit)"; System.Data.OleDb.OleDbCommand cmm = new System.Data.OleDb.OleDbCommand(query,conn); cmm.Parameters.AddWithValue("@desc", ""); cmm.Parameters.AddWithValue("@type", ""); cmm.Parameters.AddWithValue("@cost", 34); cmm.Parameters.AddWithValue("@qty", 2); cmm.Parameters.AddWithValue("@content", ""); cmm.Parameters.AddWithValue("@status", ""); cmm.Parameters.AddWithValue("@date", DateTime.Now.ToOADate()); cmm.Parameters.AddWithValue("@shipdate", DateTime.Now.ToOADate()); cmm.Parameters.AddWithValue("@deposit", 34); cmm.ExecuteNonQuery(); TextBox1.Text = "Success";\[/code\]this static query works:\[code\]String query = "INSERT INTO [ORDER] (orderDesc, orderType, orderCost, orderQty, orderContent, orderStatus, orderDate, orderShipDate, orderDeposit) VALUES ('uhgu', 'sagu', 34.5, 4, 'dsg', 'dgs', #23-Mar-2323# , #23-Mar-2323#, 23)";\[/code\]