DataView.RowFilter?
-
Can I use the RowFilter of a DataView to populate it with only the enteries in the specified coloum that start with a certian letter? tia
gadgetfbi wrote: Can I use the RowFilter of a DataView to populate it with only the enteries in the specified coloum that start with a certian letter? Confused by the statement. The "in the specified column that starts with". The column starts with a certian letter or the data in the column starts with a certain letter? If it is the latter and you only want to filter the rows by a given column that has data starting with a certian letter you would: myDataView.RowFilter = "substring(myColumn,1,1)='B'" Where myColumn is the column you wish to filter by and 'B' is the letter you wish to match. Rocky Moore <><
-
gadgetfbi wrote: Can I use the RowFilter of a DataView to populate it with only the enteries in the specified coloum that start with a certian letter? Confused by the statement. The "in the specified column that starts with". The column starts with a certian letter or the data in the column starts with a certain letter? If it is the latter and you only want to filter the rows by a given column that has data starting with a certian letter you would: myDataView.RowFilter = "substring(myColumn,1,1)='B'" Where myColumn is the column you wish to filter by and 'B' is the letter you wish to match. Rocky Moore <><
-
yeh, thanks. I wasnt sure if I could use string operators in the filter expression. I need to read more. Rob
Yeah, they have a lot of functionality in there filters and sorting ability in DataSets. Makes for a lot less work! Rocky Moore <><