Fortunately, this field cannot be null. However, if it were an issue how would that be handled?
On Mar 19, 7:01 am, Cerebrus <[email protected]> wrote: > Cool ! Just make sure to handle Null values. > > On Mar 18, 6:02 pm, Kyle Blankenship <[email protected]> > wrote: > > > 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.- Hide quoted text - > > > - Show quoted text - To unsubscribe from this group, send email to dotnetdevelopment+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
