I have dealt w/ SQL as back-end many times before, but this local CE database is driving me crazy. I have a dataset (CsDbDataSet) with my table (ServiceMonitor) all set up. I have the dataset configured for CRUD and everything looks just peachy there. The problem is that I cannot write directly to the table and have it show up. I don't get any kind of error, but when I run a SELECT statement on the table, I receive no data. Am I missing something?

I am using the direct database access methods used here: http://msdn.microsoft.com/en-us/libr...(v=vs.80).aspx

Insert Method I am trying to use:
Code:
Dim ta As New CsDbDataSetTableAdapters.ServiceMonitorTableAdapter
ta.InsertRecord("Test", Now.ToString, "TestSvc", "TestSvcVer", "TestSvcStat", "TestNote", "TestProgram")
InsertRecord I am trying to use from XSD
Code:
INSERT INTO [ServiceMonitor] ([StoreID], [DateTimeStamp], [ServiceName], [ServiceVersion], [ServiceStatus], [Notes], [ProgramAndVersion]) VALUES (@StoreID, @DateTimeStamp, @ServiceName, @ServiceVersion, @ServiceStatus, @Notes, @ProgramAndVersion)