private void BuildDataTables()
{
DataTable dataTable = new DataTable(TableName);
DataColumnCollection myColumns = dataTable.Columns;
myColumns.Add(FIELD_ID, typeof(System.Int64));
myColumns.Add(FIELD_COMPANY_NAME, typeof(System.String));
myColumns.Add(FIELD_TEL, typeof(System.String));
myColumns.Add(FIELD_SEMAT, typeof(System.Int32));
myColumns.Add(FIELD_OFFICER, typeof(System.String));
myColumns.Add(FIELD_ADDRESS, typeof(System.String));
myColumns.Add(FIELD_FAX, typeof(System.String));
myColumns.Add(FIELD_ACTIVE, typeof(System.Boolean));
myColumns.Add(FIELD_DESCRIPTION, typeof(System.String));
myColumns.Add(FIELD_RADIF, typeof(System.Int32));
DataTable viewDataTable = dataTable.Copy();
viewDataTable.TableName = VIEW_QUALIFIRE + viewDataTable.TableName;
viewDataTable.Columns.Add(VIEW_FIELD_REFFERED_USER_NAME, typeof(System.String));
viewDataTable.Columns.Add(VIEW_FIELD_SEMAT, typeof(System.String));
this.Tables.Add(dataTable);
this.Tables.Add(viewDataTable);
}
private void BuildDataTables()
{
DataTable dataTable = new DataTable(TableName);
DataColumnCollection myColumns = dataTable.Columns;
myColumns.Add(VIEW_FIELD_ID, typeof(System.Int64));
myColumns.Add(FIELD_RADIF, typeof(System.Int32));
DataTable viewDataTable = dataTable.Copy();
viewDataTable.TableName = VIEW_QUALIFIRE + viewDataTable.TableName;
viewDataTable.Columns.Add(VIEW_FIELD_USER_ID, typeof(System.Int32));
viewDataTable.Columns.Add(VIEW_FIELD_USERNAME, typeof(System.String));
viewDataTable.Columns.Add(VIEW_FIELD_CUR_LETTER_ALL, typeof(System.String));
viewDataTable.Columns.Add(VIEW_FIELD_CUR_LETTER_MARKED, typeof(System.String));
viewDataTable.Columns.Add(VIEW_FIELD_RATE_DEC_ALL, typeof(System.String));
viewDataTable.Columns.Add(VIEW_FIELD_RATE_DEC_MARKED, typeof(System.String));
viewDataTable.Columns.Add(VIEW_FIELD_RATE_DEC_ORAL_ALL, typeof(System.String));
viewDataTable.Columns.Add(VIEW_FIELD_RATE_DEC_ORAL_MARKED, typeof(System.String));
viewDataTable.Columns.Add(VIEW_FIELD_CHEQUE_HAS_REMAINDER, typeof(System.String));
viewDataTable.Columns.Add(VIEW_FIELD_CHEQUE_WHITHOUT_ANS, typeof(System.String));
this.Tables.Add(dataTable);
this.Tables.Add(viewDataTable);
}
private void CreateTable(DataTable dt, string[] Fileds, string[] Types, DataColumnCollection dtColumn)
{
for (int i = 0; i < Fileds.Length; i++)
{
DataColumn Column = new DataColumn();
//该列的数据类型
Column.DataType = Type.GetType(Types[i]);
//该列得名称
Column.ColumnName = Fileds[i];
//该列得默认值
switch (Types[i])
{
case "System.Double":
Column.DefaultValue = 0;
dtColumn.Add(Fileds[i], typeof(double));
break;
case "System.DateTime":
Column.DefaultValue = DateTime.Now;
dtColumn.Add(Fileds[i], typeof(DateTime));
break;
default:
Column.DefaultValue = "";
dtColumn.Add(Fileds[i], typeof(string));
break;
}
dt.Columns.Add(Column);
}
}
private void BuildTable()
{
this.m_recordSet = new DataTable(this.Entity.Table);
this.m_oldRecordSet = new DataTable(this.Entity.Table);
DataColumnCollection columns = this.m_recordSet.Columns;
DataColumnCollection oldColumns = this.m_oldRecordSet.Columns;
foreach (KeyValuePair <string, FieldMapAttribute> de in this.m_fields)
{
bool flag = de.Value.DbType == TimDbType.DateTime;
if (flag)
{
columns.Add(de.Value.DbField, typeof(DateTime));
oldColumns.Add(de.Value.DbField, typeof(DateTime));
}
else
{
bool flag2 = de.Value.DbType == TimDbType.Float;
if (flag2)
{
columns.Add(de.Value.DbField, typeof(double));
oldColumns.Add(de.Value.DbField, typeof(double));
}
else
{
columns.Add(de.Value.DbField);
oldColumns.Add(de.Value.DbField);
}
}
}
}
public static object GETLIST(object obj)
{
DataSet dstmp = new DataSet();
if (dstmp.Tables.Contains("TAB_NM"))//已经存在该表的话，删除掉
{
dstmp.Tables.Remove("TAB_NM");
}
//创建虚拟数据表
DataTable table = new DataTable("TAB_NM");
//获取列集合,添加列
DataColumnCollection columns = table.Columns;
columns.Add("col_id", typeof(String));
columns.Add("opr_date", typeof(DateTime));
//添加一行数据
for (int i = 1; i < 5; i++)
{
DataRow row = table.NewRow();
row["col_id"] = "id" + i;
row["opr_date"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
table.Rows.Add(row);
}
dstmp.Tables.Add(table); //把信息表放入DataSet中
obj = dstmp;
return(obj);
}
}//end default constructor
private void AddColumns()
{
DataColumnCollection cols = this.Columns;
// Idenfity column
DataColumn roomid = cols.Add("RoomID", typeof(Int32));
roomid.AllowDBNull = false;
roomid.AutoIncrement = true;
roomid.AutoIncrementSeed = -1;
roomid.AutoIncrementStep = -1;
// Add other column
cols.Add("RoomTypeID", typeof(Int32));
cols.Add("RoomType", typeof(String)).Caption = "Loại Phòng";
cols.Add("TicketID", typeof(Int32));
cols.Add("OwnerID", typeof(Int32));
cols.Add("Owner", typeof(String)).Caption = "Người Đứng Tên Thuê";
cols.Add("RoomNumber", typeof(String)).Caption = "Số Phòng";
cols.Add("Beds", typeof(Int32)).Caption = "Số Giường";
cols.Add("Price", typeof(Decimal)).Caption = "Đơn Giá";
cols.Add("Quantity", typeof(Int32)).Caption = "Số Lượng Phòng Đã Đăng Ký";
// Add primary colummn
this.PrimaryKey = new DataColumn[] { cols["RoomID"] };
}//end method IniColumns
public void Clear()
{
DataTable Table = new DataTable("test_table");
DataTable Table2 = new DataTable("test_table2");
DataSet Set = new DataSet();
Set.Tables.Add(Table);
Set.Tables.Add(Table2);
DataColumnCollection Cols = Table.Columns;
DataColumnCollection Cols2 = Table2.Columns;
Cols.Add();
Cols.Add("testi");
Cols.Clear();
Assert.AreEqual(0, Cols.Count, "test#01");
Cols.Add();
Cols.Add("testi");
Cols2.Add();
Cols2.Add();
DataRelation Rel = new DataRelation("Rel", Cols [0], Cols2 [0]);
Set.Relations.Add(Rel);
try {
Cols.Clear();
Assert.Fail("test#02");
} catch (Exception e) {
Assert.AreEqual(typeof(ArgumentException), e.GetType(), "test#03");
// Never premise English.
//Assert.AreEqual ("Cannot remove this column, because it is part of the parent key for relationship Rel.", e.Message, "test#04");
}
}
private static void CreateTableStructure(ObjectInfo info, DataTable table)
{
DataColumnCollection columns = table.Columns;
foreach (var item in info.Attributes)
{
columns.Add(item.LocalName);
}
if (info.Content != null)
{
columns.Add(ObjectInfo.CONTENT_NAME);
}
else
{
var elements = info.Elements.CreateOrderPropertyInfoList();
foreach (var item in elements)
{
if (item.IsSingle)
{
string localName = item.Content.LocalName;
columns.Add(localName);
}
}
}
}
[Fact] // Add (String)
public void Add3_ColumnName_Null()
{
DataTable table = new DataTable();
DataColumnCollection cols = table.Columns;
DataColumn col;
col = cols.Add((string)null);
Assert.Equal(1, cols.Count);
Assert.Equal("Column1", col.ColumnName);
Assert.Same(table, col.Table);
col = cols.Add((string)null);
Assert.Equal(2, cols.Count);
Assert.Equal("Column2", col.ColumnName);
Assert.Same(table, col.Table);
cols.RemoveAt(1);
col = cols.Add((string)null);
Assert.Equal(2, cols.Count);
Assert.Equal("Column2", col.ColumnName);
Assert.Same(table, col.Table);
cols.Clear();
col = cols.Add((string)null);
Assert.Equal(1, cols.Count);
Assert.Equal("Column1", col.ColumnName);
Assert.Same(table, col.Table);
}
public void Clear()
{
DataTable table = new DataTable("test_table");
DataTable table2 = new DataTable("test_table2");
DataSet set = new DataSet();
set.Tables.Add(table);
set.Tables.Add(table2);
DataColumnCollection cols = table.Columns;
DataColumnCollection cols2 = table2.Columns;
cols.Add();
cols.Add("testi");
cols.Clear();
Assert.Equal(0, cols.Count);
cols.Add();
cols.Add("testi");
cols2.Add();
cols2.Add();
DataRelation rel = new DataRelation("Rel", cols[0], cols2[0]);
set.Relations.Add(rel);
// Cannot remove this column, because it is part of the parent key for relationship Rel.
Assert.Throws <ArgumentException>(() => cols.Clear());
}
public void AddExceptions()
{
DataTable table = new DataTable("test_table");
DataTable table2 = new DataTable("test_table2");
DataColumnCollection cols = table.Columns;
DataColumn c = null;
Assert.Throws <ArgumentNullException>(() => cols.Add(c));
c = new DataColumn("test");
cols.Add(c);
// Column 'test' already belongs to this or another DataTable.
Assert.Throws <ArgumentException>(() => cols.Add(c));
// Column 'test' already belongs to this or another DataTable.
Assert.Throws <ArgumentException>(() => table2.Columns.Add(c));
DataColumn c2 = new DataColumn("test");
// A DataColumn named 'test' already belongs to this DataTable.
Assert.Throws <DuplicateNameException>(() => cols.Add(c2));
// EvaluateException : Invalid number of arguments: function substring().
Assert.ThrowsAny <InvalidExpressionException>(() => cols.Add("test2", typeof(string), "substring ('fdsafewq', 2)"));
}
public void CopyTo()
{
DataTable table = new DataTable("test_table");
DataColumnCollection cols = table.Columns;
cols.Add("test");
cols.Add("test2");
cols.Add("test3");
cols.Add("test4");
DataColumn[] array = new DataColumn[4];
cols.CopyTo(array, 0);
Assert.Equal(4, array.Length);
Assert.Equal("test", array[0].ColumnName);
Assert.Equal("test2", array[1].ColumnName);
Assert.Equal("test3", array[2].ColumnName);
Assert.Equal("test4", array[3].ColumnName);
array = new DataColumn[6];
cols.CopyTo(array, 2);
Assert.Equal(6, array.Length);
Assert.Equal("test", array[2].ColumnName);
Assert.Equal("test2", array[3].ColumnName);
Assert.Equal("test3", array[4].ColumnName);
Assert.Equal("test4", array[5].ColumnName);
Assert.Null(array[0]);
Assert.Null(array[1]);
}
public void CopyTo()
{
DataTable Table = new DataTable("test_table");
DataColumnCollection Cols = Table.Columns;
Cols.Add("test");
Cols.Add("test2");
Cols.Add("test3");
Cols.Add("test4");
DataColumn [] array = new DataColumn [4];
Cols.CopyTo(array, 0);
Assert.AreEqual(4, array.Length, "test#01");
Assert.AreEqual("test", array [0].ColumnName, "test#02");
Assert.AreEqual("test2", array [1].ColumnName, "test#03");
Assert.AreEqual("test3", array [2].ColumnName, "test#04");
Assert.AreEqual("test4", array [3].ColumnName, "test#05");
array = new DataColumn [6];
Cols.CopyTo(array, 2);
Assert.AreEqual(6, array.Length, "test#06");
Assert.AreEqual("test", array [2].ColumnName, "test#07");
Assert.AreEqual("test2", array [3].ColumnName, "test#08");
Assert.AreEqual("test3", array [4].ColumnName, "test#09");
Assert.AreEqual("test4", array [5].ColumnName, "test#10");
Assert.IsNull(array [0], "test#11");
Assert.IsNull(array [1], "test#12");
}
static private DataTable CreateDataTable(esDataRequest request)
{
DataTable dataTable = new DataTable();
DataColumnCollection dataColumns = dataTable.Columns;
esColumnMetadataCollection cols = request.Columns;
if (request.SelectedColumns == null)
{
esColumnMetadata col;
for (int i = 0; i < cols.Count; i++)
{
col = cols[i];
dataColumns.Add(new DataColumn(col.Name, col.Type));
}
}
else
{
foreach (string col in request.SelectedColumns.Keys)
{
dataColumns.Add(new DataColumn(col, cols[col].Type));
}
}
return(dataTable);
}
[Test] // Add (String)
public void Add3_ColumnName_Null()
{
DataTable table = new DataTable();
DataColumnCollection cols = table.Columns;
DataColumn col;
col = cols.Add((string)null);
Assert.AreEqual(1, cols.Count, "#A1");
Assert.AreEqual("Column1", col.ColumnName, "#A2");
Assert.AreSame(table, col.Table, "#A3");
col = cols.Add((string)null);
Assert.AreEqual(2, cols.Count, "#B1");
Assert.AreEqual("Column2", col.ColumnName, "#B2");
Assert.AreSame(table, col.Table, "#B3");
cols.RemoveAt(1);
col = cols.Add((string)null);
Assert.AreEqual(2, cols.Count, "#C1");
Assert.AreEqual("Column2", col.ColumnName, "#C2");
Assert.AreSame(table, col.Table, "#C3");
cols.Clear();
col = cols.Add((string)null);
Assert.AreEqual(1, cols.Count, "#D1");
Assert.AreEqual("Column1", col.ColumnName, "#D2");
Assert.AreSame(table, col.Table, "#D3");
}
public static DataTable GetTitleTextLinkTable(string Input)
{
DataTable dt = new DataTable();
DataColumnCollection column = dt.Columns;
column.Add("title");
column.Add("word");
column.Add("link");
string[] vs = Regex.Split(Input, @"\r\n");
foreach (string v in vs)
{
if (!String.IsNullOrEmpty(v) && v.Contains("|"))
{
DataRow nrow = dt.NewRow();
nrow["title"] = v.Split('|')[0].Replace("[", "");
nrow["word"] = v.Split('|')[1].Replace("[", "");
nrow["link"] = v.Split('|')[2].Replace("]", "").Replace("{$}", "=").Replace("{^}", "&");
dt.Rows.Add(nrow);
}
}
return(dt);
}
}//end default constructor
private void AddColumn()
{
DataColumnCollection cols = this.Columns;
// Identify column
DataColumn customerId = cols.Add("CustomerID", typeof(Int32));
customerId.AllowDBNull = false;
customerId.AutoIncrement = true;
customerId.AutoIncrementSeed = -1;
customerId.AutoIncrementStep = -1;
customerId.ReadOnly = true;
customerId.Caption = "Mã Khách Hàng";
// Add other columns
cols.Add("RoomNumber", typeof(String)).Caption = "Số Phòng";
cols.Add("RoomID", typeof(Int32)).ColumnMapping = MappingType.Hidden;
cols.Add("GroupID", typeof(Int32)).ColumnMapping = MappingType.Hidden;
cols.Add("CountryID", typeof(Int32)).Caption = "Mã Quốc Gia";
cols.Add("LastName", typeof(String)).Caption = "Họ Khách Hàng";
cols.Add("FirstName", typeof(String)).Caption = "Tên Khách Hàng";
cols.Add("SocialID", typeof(String)).Caption = "CMND";
cols.Add("PassPort", typeof(String)).Caption = "Hộ Chiếu";
cols.Add("Phone", typeof(String)).Caption = "Điện Thoại";
// Add primary column
this.PrimaryKey = new DataColumn[] { cols["CustomerID"] };
}//end method AddColumn
private DataTable MakeColumns(DataTable dt)
{
DataColumnCollection columns = dt.Columns;
columns.Add("Id", typeof(String));
columns.Add("ModifiedAfter", typeof(DateTime));
return(dt);
}
private DataTable MakeColumns(DataTable dt)
{
DataColumnCollection columns = dt.Columns;
columns.Add("MonthEnding", typeof(DateTime));
columns.Add("NumMonths", typeof(Int16));
return(dt);
}
private DataTable MakeColumns(DataTable dt)
{
DataColumnCollection columns = dt.Columns;
columns.Add("CultureId", typeof(Int16));
columns.Add("SystemId", typeof(Byte));
return(dt);
}
private DataTable MakeColumns(DataTable dt)
{
DataColumnCollection columns = dt.Columns;
columns.Add("tzInfo", typeof(string));
columns.Add("SystemId", typeof(Byte));
return(dt);
}
private void FillData()
{
var descriptions = new List <string>()
{
"Across all our software products and services, our focus is on helping our customers achieve their goals. Our key principles – thoroughly understanding our customers' business objectives, maintaining a strong emphasis on quality, and adhering to the highest ethical standards – serve as the foundation for everything we do."
};
// Products table
var productsDataTable = new DataTable("Products");
DataColumnCollection productsColumns = productsDataTable.Columns;
// Add columns
productsColumns.Add("Name");
productsColumns.Add("Size", typeof(float));
productsColumns.Add("Weight", typeof(float));
productsColumns.Add("Quantity", typeof(uint));
productsColumns.Add("Description");
DataRowCollection productsRows = productsDataTable.Rows;
// Add rows
productsRows.Add("Gadget", 120f, 900f, 2, descriptions[s_rnd.Next(descriptions.Count)]);
productsRows.Add("Widget", 20f, 20f, 25, descriptions[s_rnd.Next(descriptions.Count)]);
productsRows.Add("Doohickey", 74f, 90f, 100, descriptions[s_rnd.Next(descriptions.Count)]);
DataTableCollection tables = _dataSet.Tables;
tables.Add(productsDataTable);
// Data table
var dataDataTable = new DataTable("Data");
DataColumnCollection dataColumns = dataDataTable.Columns;
// Add columns
dataColumns.Add("ID", typeof(int));
dataColumns.Add("Product");
dataColumns.Add("Country", typeof(Country));
dataColumns.Add("Color", typeof(DrawColor));
dataColumns.Add("Price", typeof(decimal));
dataColumns.Add("Change", typeof(decimal));
dataColumns.Add("History", typeof(int[]));
dataColumns.Add("Discount", typeof(decimal));
dataColumns.Add("Rating", typeof(int));
dataColumns.Add("Active", typeof(bool));
dataColumns.Add("Date", typeof(DateTime));
tables.Add(dataDataTable);
// Creating relation between products and data
_dataSet.Relations.Add("Products",
dataColumns["Product"], productsColumns["Name"], false);
_flexGrid.DataSource = _dataSet;
_flexGrid.DataMember = "Data";
_flexGrid.Cols.Remove("Products");
}
private DataTable MakeColumns(DataTable dt)
{
DataColumnCollection columns = dt.Columns;
columns.Add("Active", typeof(String));
columns.Add("UsrGroupId", typeof(Int32));
columns.Add("CompanyId", typeof(Int32));
return(dt);
}
private void _createDataTable()
{
shadow_datatable = new DataTable();
DataColumnCollection sc = shadow_datatable.Columns;
sc.Add(new DataColumn("id", Type.GetType("System.Int32")));
sc.Add(new DataColumn("storage_id", Type.GetType("System.Int32")));
sc.Add(new DataColumn("crf", Type.GetType("System.Array")));
sc.Add(new DataColumn("hash", Type.GetType("System.Int32")));
}
public void ToStringTest()
{
DataTable Table = new DataTable("test_table");
DataColumnCollection Cols = Table.Columns;
Cols.Add("test");
Cols.Add("test2");
Cols.Add("test3");
Assert.Equal("System.Data.DataColumnCollection", Cols.ToString());
}
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
if (!IsPostBack)
{
DataTable dt1 = new DataTable("Employee"), dt2 = new DataTable("Department");
DataColumnCollection dc1 = dt1.Columns, dc2 = dt2.Columns;
dc1.Add("EmployeeID", typeof(int));
dc1.Add("Name", typeof(string));
dc1.Add("DepartmentID", typeof(int));
dc2.Add("DepartmentID", typeof(int));
dc2.Add("Name", typeof(string));
//dt1.PrimaryKey=new DataColumn[] {dc1["EmployeeID"]};
//dt2.PrimaryKey=new DataColumn[] {dc2["DepartmentID"]};
dt2.DisplayExpression = dt1.DisplayExpression = "DepartmentID";
DataRow dr = dt1.NewRow();
dr.ItemArray = new object[] { 1, "rags", 10 };
dt1.Rows.Add(dr);
dr = dt1.NewRow();
dr.ItemArray = new object[] { 2, "rags1", 10 };
dt1.Rows.Add(dr);
dr = dt1.NewRow();
dr.ItemArray = new object[] { 3, "rags3", 10 };
dt1.Rows.Add(dr);
dr = dt1.NewRow();
dr.ItemArray = new object[] { 5, "rags5", 11 };
dt1.Rows.Add(dr);
dr = dt1.NewRow();
dr.ItemArray = new object[] { 4, "rags4", 11 };
dt1.Rows.Add(dr);
dt1.AcceptChanges();
dr = dt2.NewRow();
dr.ItemArray = new object[] { 10, "dept1" };
dt2.Rows.Add(dr);
dr = dt2.NewRow();
dr.ItemArray = new object[] { 11, "dept2" };
dt2.Rows.Add(dr);
dr = dt2.NewRow();
dr.ItemArray = new object[] { 12, "dept3" };
dt2.Rows.Add(dr);
dt2.AcceptChanges();
DataSet dst = new DataSet("CompanyDS");
dst.Tables.AddRange(new DataTable[] { dt1, dt2 });
dst.Relations.Add("DeptEmp", dc2["DepartmentID"], dc1["DepartmentID"]);
DropDownList1.DataSource = dt2;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "DepartmentID";
DropDownList1.DataBind();
//strl.Attributes.Add("onclick","alert()");
Session["dst"] = dst;
//dst.WriteXml(Server.MapPath("XML/xmlfile1.xml"),XmlWriteMode.WriteSchema);
BindGrid();
}
}
private void BuildDataTables()
{
DataTable dataTable = new DataTable(TableName);
DataColumnCollection myColumns = dataTable.Columns;
myColumns.Add(FIELD_ID, typeof(System.Int64));
myColumns.Add(FIELD_NAME, typeof(System.String));
myColumns.Add(FIELD_FAMILY, typeof(System.String));
myColumns.Add(FIELD_USERNAME, typeof(System.String));
myColumns.Add(FIELD_PASSWORD, typeof(System.String));
myColumns.Add(FIELD_USER_TYPE, typeof(System.Int64));
myColumns.Add(FIELD_ACTIVE, typeof(System.Int16));
myColumns.Add(FIELD_LETTER_PATTERN_ID, typeof(System.Int64));
myColumns.Add(FIELD_RADIF, typeof(System.Int32));
DataTable viewDataTable = dataTable.Copy();
viewDataTable.TableName = VIEW_QUALIFIRE + viewDataTable.TableName;
viewDataTable.Columns.Add(VIEW_FIELD_USERTYPE_DESC, typeof(System.String));
viewDataTable.Columns.Add(VIEW_FIELD_S_FULLNAME, typeof(System.String));
this.Tables.Add(dataTable);
this.Tables.Add(viewDataTable);
}
private void BulidStreamData()
{
DataTable newTable = new DataTable(STREAM_TABLE);
DataColumnCollection columns = newTable.Columns;
columns.Add(NAME_FIELD, typeof(string));
columns.Add(NUM_FIELD, typeof(int));
columns.Add(MODULES_NAME_FIELD, typeof(string));
this.Tables.Add(newTable);
}
private static DataTable PrepareDataColumns <T>(IEnumerable <T> dynObjects) where T : IDictionary <string, object>
{
DataTable dataTable = new DataTable();
DataColumnCollection tableColumns = dataTable.Columns;
Dictionary <string, int> pendingColumns = new Dictionary <string, int>();
int newWeight, oldWeight;
foreach (var dynObj in dynObjects)
{
foreach (var p in dynObj)
{
if (pendingColumns.TryGetValue(p.Key, out oldWeight))
{
newWeight = WeighNumericType(p.Value);
if (newWeight > oldWeight) // More compatible numeric type
{
tableColumns[p.Key].DataType = p.Value.GetType().GetNonNullableType();
pendingColumns[p.Key] = newWeight;
}
else if (newWeight < 0) // Non-numeric
{
tableColumns[p.Key].DataType = p.Value.GetType().GetNonNullableType();
pendingColumns.Remove(p.Key);
}
}
else if (!tableColumns.Contains(p.Key))
{
newWeight = WeighNumericType(p.Value);
if (newWeight == 0) // Null
{
tableColumns.Add(p.Key);
}
else
{
tableColumns.Add(p.Key, p.Value.GetType().GetNonNullableType());
}
if (newWeight >= 0) // Null or numeric, need to be determined by more iteration
{
pendingColumns.Add(p.Key, newWeight);
}
}
}
if (pendingColumns.Count == 0)
{
break;
}
}
return(dataTable);
}
[Fact] // this [String]
public void Indexer2_Name_Empty()
{
DataTable dt = new DataTable();
DataColumnCollection cols = dt.Columns;
cols.Add(string.Empty, typeof(int));
cols.Add(null, typeof(bool));
DataColumn column = cols[string.Empty];
Assert.Null(column);
}
