How dataset save to sqlce?

[simoms]

It'll do, what's the problem?

From your post, I assume that you are already at least a little familiar with ADO. Do you have a database already?

NO, the database not exist..
Now, I change the method, it is using programe to create the database, then save the table to data set, finally using dataset create the xml...It work..but not the best solution..
I have the question is writing the sql command, hope can help,
why it cant work?
Dim mycommand1 As New SqlCeCommand("select * from Appointments where Day > " & date.today.today & "", cn)

I just want to compare the Day, if expired then not show in datagrid.