MyDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second, DateTime.Now.Millisecond);
dtDay = MyDate.ToString("MM/dd/yyyy");
dtTime= MyDate.ToString("hh:mm:ss tt");

comm.CommandText = "INSERT INTO tblData(DTE,TME) VALUES(#"dtDay"#,#"dtTime"#)";

i want to separate date and time in the database
i have a message data type mismatch

anyone can solve this?

tnx...