How To Change DataType of a DataColumn in a DataTable?

by

You cannot change the DataType after the Datatable is filled with data. However, you can clone the Data table, change the column type and load data from previous data table to the cloned table as shown below.

DataTable dtCloned = dt.Clone();
dtCloned.Columns[0].DataType = typeof(Int32);
foreach (DataRow row in dt.Rows) 
{
    dtCloned.ImportRow(row);
}

More Related Contents:

  1. How to create a new object instance from a Type
  2. String was not recognized as a valid DateTime ” format dd/MM/yyyy”
  3. How do you convert a DataTable into a generic list?
  4. Generics in C#, using type of a variable as parameter [duplicate]
  5. Casting a variable using a Type variable
  6. Why should I use int instead of a byte or short in C#
  7. How to compare 2 dataTables
  8. C# – Fill a combo box with a DataTable
  9. How to calculate the sum of the datatable column in asp.net?
  10. Using IsAssignableFrom with ‘open’ generic types
  11. .NET : How do you get the Type of a null object?
  12. Thread safety for DataTable
  13. DataTable to JSON [duplicate]
  14. Determine if a type is static
  15. What are the differences between value types and reference types in C#? [duplicate]
  16. Performing Math operations on decimal datatype in C#?
  17. How to switch between “possible” type of an object? [duplicate]
  18. Convert DataTable to JSON with key per row
  19. What to do when bit mask (flags) enum gets too large
  20. dynamic vs object type
  21. Returning DataTables in WCF/.NET
  22. How do I use SELECT GROUP BY in DataTable.Select(Expression)?
  23. C#: Oracle Data Type Equivalence with OracleDbType
  24. How to Read text file to DataTable [closed]
  25. How to convert DataTable to class Object?
  26. Using various types in a ‘using’ statement (C#)
  27. How can I convert a DataTable to an XML file in C#?
  28. Build c# Generic Type definition at runtime
  29. How do you Sort a DataTable given column and direction?
  30. get the Type for a object declared dynamic

Leave a Comment