/ A lambda function for converting the value

More specifically it creates a new one and transfers the data to it Instead of cloning the entire table and importing all the data it just clones the column, parses the value and then deletes the original. I created an extension function which allows changing the column type of a DataTable. SomeDt.ConvertColumnTypeTo('ColumnName', raw => raw.ToString()) Assume ColumnName is an int column which we want to convert to a string one. This way, usage is a lot more straightforward, while also customizable: DataTable someDt = CreateSomeDataTable() Public static void ConvertColumnTypeTo(this DataTable dt, string columnName, Func valueConverter)ĭataColumn dc = new DataColumn(columnName + '_new', newType) ĭr = valueConverter(dr) / Converter function that converts existing values to the new type. / Converts a column in a DataTable to another type using a user-defined converter function.

Clone the entire DataTable - with generics and extensibility, so I can define my own conversion function. I combined the efficiency of Mark's solution - so I do not have to. Of course using whatever type you desire, as long as each value in the column can actually be converted to the new type. It can then be called like this: MyTable.ConvertColumnType('M圜olumnName', typeof(int)) Give the new column the old column's name Get and convert the values of the old column, and insert them into the newĭr = Convert.ChangeType(dr, newType) Add the new column which has the new type, and move it to the ordinal of the old column Using (DataColumn dc = new DataColumn(columnName + '_new', newType)) Public static void ConvertColumnType(this DataTable dt, string columnName, Type newType) Old post, but I thought I'd weigh in, with a DataTable extension that can convert a single column at a time, to a given type: public static class DataTableExt

Como configurar o ac3 filter