Quote Originally Posted by Craig Gemmill
str = "insert into edt values('a','" & DateTime.Now.ToShortDateString() & "')"

In the future, look into using parameterized queries.
thanks a lot.. for ur reply senor... kaumudi