CODEWITHSUNDEEP
sqlvb.net
user3713568
user3713568

Reputation: 1

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

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.

Upvotes: 0

Views: 2111

Answers (2)

potashin
potashin

Reputation: 44581

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

Upvotes: 0

Gordon Linoff
Gordon Linoff

Reputation: 1269563

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";

Upvotes: 1

Related Questions