473,394 Members | 1,755 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,394 software developers and data experts.

BindingSource.Filter = "Col1='" & sumtymsnullsumtymsnot & "'"

nev
251 100+
Does anyone know how to do that? In my real project actually, I filter on two fields like this...

bindingsource.filter = "col1='" & var1 & "' AND col2='" & var2 & "'"

wherein var1 or var2 may contain a null value. Its just the same as if I want to show all records with null values.

Any ideas?
Nov 6 '07 #1
2 6379
Murugs
18
Try the below code.
dv.RowFilter = "(Isnull(col1,'Null Column') = 'Null Column' or Isnull(col2,'Null Column') = 'Null Column') or (col1='TEST' and col2='TEST')";
Hope it will solve ur problem.

Cheers,
Murugs.
Nov 6 '07 #2
nev
251 100+
Try the below code.
dv.RowFilter = "(Isnull(col1,'Null Column') = 'Null Column' or Isnull(col2,'Null Column') = 'Null Column') or (col1='TEST' and col2='TEST')";
Hope it will solve ur problem.

Cheers,
Murugs.
thanks for the input.
Jan 28 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Brad Kent | last post by:
Anyone out there have any tricks or scripts to take some text of unknown length and display it in two (or more) columns of equal height? The text may or may not contain "hard-coded" linebreaks or...
10
by: KENNY L. CHEN | last post by:
Dear experts, I have two tables in my Oracle 8i database: TEST (COL1,COl2,REC_NO) and TEST1 (COL1,COL2,REC_NO). Both tables are unique-indexed on (COL1,COL2,REC_NO). I think the following...
6
by: Dave | last post by:
I have a stored procedure in sql 2000 that requires steps to be fully completed before moving to the next command in the procedure. I have tried to place the word "GO" after each statement. When I...
12
by: Emi Lu | last post by:
Hello all, I have a question about "date" & "timestamp" types in PostgreSQL. I want to setup the default value '0000-00-00' and "0000-00-00 00:00:00" for them. However, it seems that PostgreSQL...
13
by: andro | last post by:
Hi everybody! I have several tables from which I want to exract the SAME value (along with other referenced data). All the values are in the same column within the tables. How can I achieve...
0
by: plue | last post by:
Hi, the requirement is to show a table's column at first or second position depending on css. my idea is to put the information twice into the table, as first and third column hiding one of them...
10
by: giannis | last post by:
How can i know ("see") the next record using the BindingSource without move to the next record ?
2
by: MohamedSaleh | last post by:
HI all I have the following problem Table SOURCE has columns <char COL1, integar COL2> and has rows {A,1}, {A,2,}, {,A,3}, {B,1}, {B,2},, {C,1},
5
by: stmfc | last post by:
i dont know why pl/sql block below returns no data found error. do you have any idea about it? declare c1 varchar2(80); c2 varchar2(80); begin execute immediate 'select col2 from table1 where...
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: 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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

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.