How to insert if statement in sql query at vb.net?

Question

How to insert if/else in the query?

This is my sqlcommand query :

 sqlcommand ("select Machine_Code,Machine_Name,Status from
 Machine_Master where '" & combolinecode.Text & "' = Line_Code" )

I wanna change the value of Status from 1 => active and 0 => not active.

Gordon Linoff · Accepted Answer · 2014-06-06 11:16:57Z

1

You can do this with the ANSI standard case statement in almost all databases:

select Machine_Code, Machine_Name,
       (case when Status = 1 then 'active' else 'not active' end) as status
from Machine_Master
where '" & combolinecode.Text & "' = Line_Code";

I fear that if you are using VBA you might be using Access, which has its own way:

select Machine_Code, Machine_Name,
       iif(Status = 1, "active", "not active") as status
from Machine_Master
where '" & combolinecode.Text & "' = Line_Code";

edited Jun 6, 2014 at 11:16

answered Jun 6, 2014 at 3:13

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

souslov · Accepted Answer · 2015-06-26 00:51:02Z

0

You can use case :

select Machine_Code
     , Machine_Name
     , (case when Status = 1 then 'active' else 'not active' end) as Status
from Machine_Master 
where '" & combolinecode.Text & "' = Line_Code

edited Jun 26, 2015 at 0:51

answered Jun 6, 2014 at 3:11

souslov

44.7k11 gold badges92 silver badges113 bronze badges

Collectives™ on Stack Overflow

How to insert if statement in sql query at vb.net?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related