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);