[sqlce] Forum Topics

Hi, I need to compare record using sql ce I have this data, can be thousand rows ID Type Date Time 02-0009 I 01/02/2014 8:00 02-0009 O 01/02/2014 18:00 02-0009 O 01/03/2014 18:00 02-0009 I 01/04/2014 8:00 02-0009 O 01/04/2014 18:00 For every date there should be a 'I' and …

Dear All, I have a small probelm with updating my database. Here are my codes ~~~ vb Module AphidSimVar Dim myCon As SqlCeConnection = New SqlCeConnection("Data Source=|DataDirectory|\AphidModel.sdf") Dim myCmd As SqlCeCommand Dim myAdap As SqlCeDataAdapter Dim myDataSet As DataSet Dim myTable As DataTable Dim myBuilder As SqlCeCommandBuilder Public Sub ShowData() …