Mine

DataRow slDataRow = slDataTable.NewRow();

                                foreach (DataColumn slColName in slDataTable.Columns)
                                {

                                    if (myReader[slColName.ToString()] is DateTime)
                                    {

                                       

                                        TimeSpan ts = ((DateTime) myReader[slColName.ToString()] - new DateTime(1970, 1, 1, 0, 0, 0));
                                        slDataRow[slColName] = ts.TotalSeconds;

                                    }
                                    else
                                    {

                                        slDataRow[slColName] = myReader[slColName.ToString()];

                                    }

                                }

                                slDataSet.Tables[table].Rows.Add(slDataRow);

                                // slCommand.CommandText = "insert into countries (iso_id, country, cnt, update_date) values (@iso_id, @country, @cnt, @update_date);";
                                slAdap.InsertCommand = 

                                // invalid insert command...
                                slAdap.Update(slDataSet, table);