private void AddDataTableColumns(DataTable dataTable, XapDataReader dr) { for (int x = 0; x <= dr.FieldCount - 1; x++) { DataColumn column = new DataColumn(dr.GetName(x), dr.GetFieldType(x)); dataTable.Columns.Add(column); } }
private void AddDataRow(DataTable dataTable, XapDataReader dr) { object obj = null; Type t = null; DataRow dataRow = dataTable.NewRow(); for (int i = 0; i <= dr.FieldCount - 1; i++) { obj = dr.GetValue(i); t = dr.GetFieldType(i); if (obj == null || string.IsNullOrEmpty(obj.ToString())) { dataRow[i] = t.GetDefaultValue(); } else { dataRow[i] = dr.GetValue(i); } } dataTable.Rows.Add(dataRow); }