I get it. Then you correctly assume that you would need to iterate
through the Datatable and modify the relevant column's values.
Something like:
---
foreach (DataRow dr in dsprocoverpay.Tables[0].Rows)
{
string oldValue = dr["MyColumnName"]; // "###-######"
string newValue = oldValue.Replace("-", "");
dr["MyColumnName"] = newValue; // "#########"
}
---
On Mar 17, 7:52 pm, Kyle Blankenship <[email protected]>
wrote:
> Currently, binding to the datagrid is for testing purposes only so
> that I can see the values in the dataset. The issue is that the data
> is being uploaded via a vendor, who have added the "-" into the
> string. I need to strip out that "-" so that it conforms with our
> systems. The vendor is unable to remove the "-" prior to uploading
> the .csv.
>
