Thanks a lot!! Great code, this is the version in C# only changing the column type:
DataTable dtOriginalTable = dataSet.Tables[0];
DataTable dtResults = new DataTable();
foreach (DataColumn dc in dtOriginalTable.Columns)
{
dtResults.Columns.Add(dc.ColumnName);
}
foreach (DataColumn dc in dtResults.Columns)
{
if (dc.ColumnName == "Incident Priority")
{
dc.DataType = System.Type.GetType("System.String");
}
}
foreach (DataRow drow in dtOriginalTable.Rows)
{
dtResults.Rows.Add(drow.ItemArray);
}