hello every one,plz help me.

Question

1.00/5 (1 vote)

See more:

there are 4 columns(A,B,C,D) in SQL Table and 3 string in 3 different variable @abc, @bcd and @cda, stored from 3 textboxes.
and the sql statement is

C#

SqlDataAdapter da = new SqlDataAdapter("select * from Table where (A=@abc OR A=@bcd OR A=@cda) AND (B=@abc OR B=@bcd OR B=@cda) AND (C=@abc OR A=@bcd OR A=@cda) AND (C=@abc OR C=@bcd OR C=@cda) AND (D=@abc OR D=@bcd OR D=@cda)", cn);
DataSet ds = new DataSet();
da.Fill(ds, "stk");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "stk";

The problem is that if there No related string(@abc,@bcd,@cda) data is present in Column B(for Ex.), its not show the data in gridview.
i want the SQL statement which show data in gridview, if there No data present in any one column.

Posted 14-Dec-14 20:12pm

Member 10861672

Updated 14-Dec-14 20:44pm

Marcin Kozub

v2

Add a Solution

Comments

Agent__007 15-Dec-14 3:13am

I am not sure I get your issue, but I think you need to add SqlParameters and their values to your SqlDataAdapter instance. Refer: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter%28v=vs.110%29.aspx URL for details.

Praveen Kumar Upadhyay 15-Dec-14 3:17am

I think your query is wrong. As you have mentioned that you have 4 columns and comparing with 3 string variable. As per the query you have mentioned, you condition is never gonna true, because 4 columns will never match with 3 Textbox variables. These variable will either match with A,B,C or B,C,D or any other 3 combination but will not match with all 4 columns.
Please correct me if I am wrong.

Member 10861672 15-Dec-14 6:31am

Is there are no any query in SQL for that condition.

Praveen Kumar Upadhyay 15-Dec-14 6:39am

There are condition, but before that look at your query. What you are specifying the condition is totally wrong.
You are checking that if column A is matching with any textbox, column B is matching with any Textbox, similarly for C and D. Now how come 3 Textbox can be compared for 4 column value and that too also with OR condition.

You please tell your scenario what you want to do

Shweta N Mishra 15-Dec-14 3:40am

you need to elaborate your question details a little more, Put your table sample record and expected result in you question too.

Shweta N Mishra 15-Dec-14 6:56am

i do not see your table which you are trying to post.

Use Improve question option and post your table data.

Member 10861672 15-Dec-14 11:44am

|-----D--------|---W----|---X---|------Z--------|------AA-------|----------AB-------------|-AC--|---------AD------------|
!______________!________!_______!_______________!_______________!_________________________!_____!_______________________!
|S.B.I. ATM----|Bhilai--|Durg---|Smriti Nagar---|Junwani Road---|Infront Of Jaika Bakery--|ATM--|State Bank Of India ATM|
|Axis Bank ATM-|Bhilai--|Durg---|Shop No 106----|Smriti Nagar---|CHPL Complex-------------|ATM--|Axis Bank ATM----------|
|S.B.I.ATM-----|Bhilai--|Durg---|Khursipar Gate-|G.E. Road------|Bansi Bazaar-------------|ATM--|State Bank Of India ATM|
|AXIS ATM------|Bhilai--|Durg---|Khursipar Gate-|G.E. Road------|Bansi Bazaar-------------|ATM--|Axis Bank ATM----------|
|B.O.I.ATM-----|Bhilai--|Durg---|Khursipar Gate-|G.E. Road------|Bansi Bazaar-------------|ATM--|Bank Of India ATM------|
|H.D.F.C.ATM---|Bhilai--|Durg---|Khursipar Gate-|G.E. Road------|Bansi Bazaar-------------|ATM--|H.D.F.C. ATM-----------|

The above table is ABC.
and the Query is

SELECT D,W,X,Z,AA,AB,AC,AD
FROM ABC WHERE (D LIKE 'S.B.I.%' OR
D LIKE 'ATM%' OR
D LIKE 'BHILAI%' OR
D LIKE 'G.E.%') AND (W LIKE 'S.B.I.%' OR
W LIKE 'ATM%' OR
W LIKE 'BHILAI%' OR
W LIKE 'G.E.%') AND (X LIKE 'S.B.I.%' OR
X LIKE 'ATM%' OR
X LIKE 'BHILAI%' OR
X LIKE 'G.E.%') AND (Z LIKE 'S.B.I.%' OR
Z LIKE 'ATM%' OR
Z LIKE 'BHILAI%' OR
Z LIKE 'G.E.%') AND (AC LIKE 'S.B.I.%' OR
AC LIKE 'ATM%' OR
AC LIKE 'BHILAI%' OR
AC LIKE 'G.E.%')

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shweta N Mishra · Answer 1 · 2014-12-15T05:55:00

Try this

SQL

SELECT D,W,X,Z,AA,AB,AC,AD
FROM ABC WHERE (D LIKE 'S.B.I.%' OR
D LIKE 'ATM%' OR
D LIKE 'BHILAI%' OR
D LIKE 'G.E.%') or(W LIKE 'S.B.I.%' OR
W LIKE 'ATM%' OR
W LIKE 'BHILAI%' OR
W LIKE 'G.E.%') or(X LIKE 'S.B.I.%' OR
X LIKE 'ATM%' OR
X LIKE 'BHILAI%' OR
X LIKE 'G.E.%') or(Z LIKE 'S.B.I.%' OR
Z LIKE 'ATM%' OR
Z LIKE 'BHILAI%' OR
Z LIKE 'G.E.%') or (AC LIKE 'S.B.I.%' OR
AC LIKE 'ATM%' OR
AC LIKE 'BHILAI%' OR
AC LIKE 'G.E.%')

Or looking at your column values if you know what those textboxes are going to contain then accordingly put them in condition, e.g. 1st textbox will have values to be searched in column D , 2nd text box value will have values to be searched for column W and so on

SQL

SELECT D,W,X,Z,AA,AB,AC,AD
FROM ABC WHERE (D LIKE 'S.B.I.%') AND (
W LIKE 'BHILAI%')

and so on

juwelw · Answer 2 · 2014-12-15T07:24:00

SqlDataAdapter da = new SqlDataAdapter(@"select * from Table where (A=@abc OR A=@bcd OR A=@cda) AND (B=@abc OR B=@bcd OR B=@cda) AND (C=@abc OR A=@bcd OR A=@cda) AND (C=@abc OR C=@bcd OR C=@cda) AND (D=@abc OR D=@bcd OR D=@cda)", cn);
DataSet ds = new DataSet();
da.Fill(ds, "stk");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "stk";

mr47_p · Answer 3 · 2014-12-14T20:17:00

Solution 1

use left outer join and fK for your tables.

Posted 14-Dec-14 20:17pm

mr47_p

Comments

Praveen Kumar Upadhyay 15-Dec-14 3:06am

There is no join operation in the query if you see.

Member 10861672 15-Dec-14 3:20am

sir! can u plz tell me the modified query of above...cz i don't know about left outer join and fK.

mr47_p 24-Dec-14 5:49am

without join its not a proffesional work

Tomas Takac 15-Dec-14 3:24am

How does it solve the problem?

hello every one,plz help me.

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0