/// <summary>
/// remove col: heatArea, name1.
/// </summary>
///
/// <param name="dt"></param>
private void RemoveColumns(DataTable dt)
{
if (dt != null)
{
DataColumnCollection cols = dt.Columns;
if (cols.Contains("heatArea"))
{
if (cols.CanRemove(cols["heatArea"]))
{
cols.Remove("heatArea");
}
}
if (cols.Contains("Name1"))
{
if (cols.CanRemove(cols["Name1"]))
{
cols.Remove("Name1");
}
}
}
}
//<Snippet1>
private void RemoveColumn(string columnName, DataTable table)
{
DataColumnCollection columns = table.Columns;
if (columns.Contains(columnName))
{
if (columns.CanRemove(columns[columnName]))
{
columns.Remove(columnName);
}
}
}
public void CanRemove()
{
DataTable table = new DataTable("test_table");
DataTable table2 = new DataTable("test_table_2");
DataColumnCollection cols = table.Columns;
DataColumn c = new DataColumn("test1");
cols.Add();
// MSDN says that if C doesn't belong to Cols
// Exception is thrown.
Assert.False(cols.CanRemove(c));
cols.Add(c);
Assert.True(cols.CanRemove(c));
c = new DataColumn();
c.Expression = "test1 + 2";
cols.Add(c);
c = cols["test2"];
Assert.False(cols.CanRemove(c));
c = new DataColumn("t");
table2.Columns.Add(c);
DataColumnCollection Cols2 = table2.Columns;
Assert.True(Cols2.CanRemove(c));
DataSet Set = new DataSet();
Set.Tables.Add(table);
Set.Tables.Add(table2);
DataRelation Rel = new DataRelation("Rel", table.Columns[0], table2.Columns[0]);
Set.Relations.Add(Rel);
Assert.False(Cols2.CanRemove(c));
Assert.False(cols.CanRemove(null));
}
public void CanRemove()
{
DataTable Table = new DataTable("test_table");
DataTable Table2 = new DataTable("test_table_2");
DataColumnCollection Cols = Table.Columns;
DataColumn C = new DataColumn("test1");
Cols.Add();
// LAMESPEC: MSDN says that if C doesn't belong to Cols
// Exception is thrown.
Assert.False(Cols.CanRemove(C));
Cols.Add(C);
Assert.True(Cols.CanRemove(C));
C = new DataColumn();
C.Expression = "test1 + 2";
Cols.Add(C);
C = Cols["test2"];
Assert.False(Cols.CanRemove(C));
C = new DataColumn("t");
Table2.Columns.Add(C);
DataColumnCollection Cols2 = Table2.Columns;
Assert.True(Cols2.CanRemove(C));
DataSet Set = new DataSet();
Set.Tables.Add(Table);
Set.Tables.Add(Table2);
DataRelation Rel = new DataRelation("Rel", Table.Columns[0], Table2.Columns[0]);
Set.Relations.Add(Rel);
Assert.False(Cols2.CanRemove(C));
Assert.False(Cols.CanRemove(null));
}
/// <summary>
///
/// </summary>
private void RemoveID()
{
if (dt != null)
{
DataColumnCollection cols = dt.Columns;
if (cols.Contains("id"))
{
if (cols.CanRemove(cols["id"]))
{
cols.Remove("id");
}
}
}
}
// <Snippet1>
private void RemoveColumnByName(string columnName)
{
// Get the DataColumnCollection from a DataTable in a DataSet.
DataColumnCollection columns =
ds.Tables["Suppliers"].Columns;
if (columns.Contains(columnName))
{
if (columns.CanRemove(columns[columnName]))
{
columns.Remove(columnName);
}
}
}