c dataTable merges a simple instance of two columns into a new column

  • 2020-05-19 05:34:37
  • OfStack


public static DataTable UniteDataTableColumns(DataTable dt, String newColumnName, string ColumnName1, string ColumnName2)
        {
            // Summary expression 
            string expression = "";                             
            expression = String.Format("{0}+'('+{1}+')'", ColumnName1, ColumnName2);           
            // Add summary column 
            System.Type myDataType = System.Type.GetType("System.String");
            DataColumn dcCol = new DataColumn(newColumnName, myDataType, expression, MappingType.Attribute);
            // Add merged columns 
            dt.Columns.Add(dcCol);
            return dt;
        }

Related articles: