473,387 Members | 1,844 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Any way to make DataView to filter for more than one column?

Is there a way to make a DataView Row Filter filter for more than one
column? Thanks!
Nov 20 '05 #1
4 3229
you can use AND, OR, and NOT as boolean operators
"columnName1 LIKE '...' AND columnName2 LIKE '...'"

dominique

"HAN(removethis)twister" <"HAN(removethis)twister"@comcast.net> wrote in
message news:%2****************@TK2MSFTNGP11.phx.gbl...
Is there a way to make a DataView Row Filter filter for more than one
column? Thanks!

Nov 20 '05 #2
Dominique Vandensteen wrote:
you can use AND, OR, and NOT as boolean operators
"columnName1 LIKE '...' AND columnName2 LIKE '...'"

dominique

"HAN(removethis)twister" <"HAN(removethis)twister"@comcast.net> wrote in
message news:%2****************@TK2MSFTNGP11.phx.gbl...
Is there a way to make a DataView Row Filter filter for more than one
column? Thanks!


Thank you!
Nov 20 '05 #3
Han,
In addition to Dominique's comments about using AND.

The only place I know of where the syntax that expressions (such as
RowFilter) in the DataSet OM is documented is the DataColumn.Expression help
topic:

http://msdn.microsoft.com/library/de...ssionTopic.asp

Hope this helps
Jay
"HAN(removethis)twister" <"HAN(removethis)twister"@comcast.net> wrote in
message news:%2****************@TK2MSFTNGP11.phx.gbl...
Is there a way to make a DataView Row Filter filter for more than one
column? Thanks!

Nov 20 '05 #4
maybe you got it from there (i did), the rowfilter property in dataview
refers to that document...
"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
Han,
In addition to Dominique's comments about using AND.

The only place I know of where the syntax that expressions (such as
RowFilter) in the DataSet OM is documented is the DataColumn.Expression help topic:

http://msdn.microsoft.com/library/de...ssionTopic.asp
Hope this helps
Jay
"HAN(removethis)twister" <"HAN(removethis)twister"@comcast.net> wrote in
message news:%2****************@TK2MSFTNGP11.phx.gbl...
Is there a way to make a DataView Row Filter filter for more than one
column? Thanks!


Nov 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Vern | last post by:
The following code retrieves data into a dataset, and then creates a dataview with a filter. This dataview is then attached to a combobox. When the effective date changes, I would like to see the...
2
by: vMike | last post by:
I have dataview which is stored in Cache for about 10 minutes. When a web user makes a selection the cached data is called from cache, sorted, filtered and bound to a datagrid. The cache is not...
2
by: andrew007 | last post by:
I have a question about dataset rowfilter. I have a list of event table in a database. each event has start-date and end-date column. I grab these from db and save to dataset. And then I have to...
1
by: martin1 | last post by:
Hi, All, DataGridView is populated with all coumns from database since i need some columns data for condition statement, after that I want to show rest of column in the DataGridView, so how to...
2
by: Christopher | last post by:
Hi, I am writing a database application and now I need to display some data and I have a question about it. The data is stored in a typed dataset. In my MainForm I have a datagridview. the...
3
by: Mayiko | last post by:
I am try to filter the DataGrid based on user input. I have a text box and a combo box. One contains the column and one contains the value. Private Sub btnSearch_Click(ByVal sender As...
7
nev
by: nev | last post by:
i declared 2 datatables: dim dtt1 as datatable = ds.datatable1 dim dtt2 as datatable = ds.datatable2 dtt1 has firstname, lastname columns dtt2 has firstname column when i filter dtt1 by...
2
by: Duggi | last post by:
Hi I have a dataview dv, in which one of the column is a date time column. I would like to apply filter on this column. The filter should be some thing like "All the rows that has the date...
2
by: Duggi | last post by:
Hi I have a dataview. I would like to apply a filter on the dataview on a column with datatype system.string. I have filter with wild char *. I need to support wild chars * and ? in...
6
by: JLORA3659 | last post by:
Hello, using c# I'm trying to sort a dataview on a column that contains integers. Apparently the option dvTempt.Sort = sFieldName; only sort as strings(or ASCII)...ex 5, 10, 11, 12, 101, 22, 24 is...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.