Thanks Shawn, I'm already using a DataView and I've looked at the Filter method but that only seems to allow me to filter on existing columns.
I need to take the lat/lon of an origin and a destination then calculate the mileage between them. After performing the calculation I need to do one of two things: 1. if it is in the chosen radius then add a miles column to the dataset/datview and put the record into the grid 2. In it outside the radisu then discard the record from the grid. I'll keep working on both problems but am welcome to solutions if you have any. Marshall Harrison -----Original Message----- From: Shawn Wildermuth [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 2:31 PM To: [EMAIL PROTECTED] Subject: Re: [DOTNET] Datagrid problem I can't remember off the top of my head how to do #1 (but it can be done), but #2 can be done with a DataView. Thanks, Shawn Wildermuth [EMAIL PROTECTED] > -----Original Message----- > From: dotnet discussion [mailto:[EMAIL PROTECTED]] > On Behalf Of Marshall Harrison > Sent: Monday, April 29, 2002 1:38 PM > To: [EMAIL PROTECTED] > Subject: [DOTNET] Datagrid problem > > > I'm binding a DataGrid to a DataView and I have two small problems: > > 1. After retrieving the data I need to programtically adjust > the data in a column. To be exact I need to convert a string > date in YYYYMMDD format to a proper date format. I can't seem > to find a way to do this? > > 2. After retrieving the data I need to programtically decide > if the record should be included in the grid. Is there a way > to do this? I looked at DataGrid.OnItemCreated but all the > examples I found were dealing with the header text. Besides > it seems as if this fires too late (i.e. when the row is > bound)and I need to keep the row from binding. > > Thanks in advance. > > Marshall Harrison > > You can read messages from the DOTNET archive, unsubscribe > from DOTNET, or subscribe to other DevelopMentor lists at > http://discuss.develop.com. > You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
