Hai Friend I Have A Question On C#Windows And Sql Server Combination On Datagridview

Question

1.00/5 (1 vote)

See more:

, +

i have a table like

id status statusid complaintto
1 open 14 employee
1 pending 15 administration
1 closed 16 xyz
2 open 14 employe
2 pending 15 administration
2 closed 16 xyz
3 open 14 employe
3 pending 15 administration
3 pending 15 xyz

i don't want to show id closed

3rd id record will be shown

thankx

Posted 27-Feb-15 18:01pm

Parazival

Add a Solution

2 solutions

Solution 1

Not Clear but,If you don't want to show the record with closed status,do like this,

SQL

SELECT id,status,statusid,complaintto from Table where status!='closed'

Or if you want to omit status,then just leave status from the query.

SQL

SELECT id,statusid,complaintto from Table where status!='closed'

Edit:2
You may get it from two way by using where clause.

SQL

select distinct a.id from #table1 as a inner join
 (select id,count(id) as Count1 from #Table1 where status!='closed' group by id) as b
  on a.id=b.id and b.Count1=3

Or simply do like this,
select id from #table1 where statusid!=16 and ID=3 and status='pending' and complaintto='xyz'

Posted 27-Feb-15 18:22pm

Rajesh waran

Updated 27-Feb-15 19:21pm

v3

Comments

Parazival 28-Feb-15 0:30am

it will show

id status statusid complaintto
1 open 14 employee
1 pending 15 administration
2 open 14 employe
2 pending 15 administration
3 open 14 employe
3 pending 15 administration
3 pending 15 xyz

but i want answer like

id
3

Parazival 28-Feb-15 0:33am

i mean if any id(1,2,3) have (16)

that id should not show to me

Rajesh waran 28-Feb-15 1:21am

I have updated my solution.Have a look.

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)

Schatak · Accepted Answer · 2015-02-27T18:55:00

Solution 2

try this:
exclude the id which are having closed status and then select the rest
you can use self joins too.

SQL

SELECT * FROM [Sample] where id not in
(
    SELECT id from [sample] where statusid = 16 -- for closed
)

Posted 27-Feb-15 18:55pm

Schatak

Updated 27-Feb-15 18:56pm

v2

Comments

Parazival 28-Feb-15 1:25am

my 5+ niceeeee answer awesome.............

i got the answer

thanks friend

Schatak 28-Feb-15 2:56am

Good, then accept the solution :P

Parazival 28-Feb-15 6:57am

where can i dowload the xml full material

thankx

Schatak 2-Mar-15 23:58pm

which xml?