Thanks, I used the following foreach loop to correct the value:
foreach (DataRow dr in dsprocoverpay.Tables[0].Rows)
{
dr[0] = dr[0].ToString().Replace("-", "");
}
Thanks for the suggestion.
On Mar 18, 1:23 am, Cerebrus <[email protected]> wrote:
> 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.
To unsubscribe from this group, send email to
dotnetdevelopment+unsubscribegooglegroups.com or reply to this email with the
words "REMOVE ME" as the subject.
