mysql if else for asp.net gridview

Question

I am trying to figure out a way to do this:

If (blah = 0 then 'Yes' else if blah = 1 then 'no' else 'maybe')

in mysql. I am trying to do this since I inserted all my data into a gridview via:

    Dim strSQL As String
    strSQL = "SELECT id, billing_first_name, billing_last_name, billing_email, billing_address, billing_city, billing_state, billing_zip, " & _
                "total, price_mode, process_status, 1 as num_of_items " & _
             "FROM orders " & _
             "ORDER BY created_on DESC, processed_on DESC LIMIT 0, 20;"

    Dim dtReader As MySqlDataReader
    objCmd = New MySqlCommand(strSQL, objConn)
    dtReader = objCmd.ExecuteReader()

    grdView.DataSource = dtReader
    grdView.DataBind()

If I can do the if/then/else somewhere in vb.net code above instead of in the database then that would be nice as well. I'm more used to doing it that way with normal query code.

I can currently do this with only if and then else, not if, elseif and then else.

SELECT IF(process_status = 1, 'SUCCEEDED', 'blah') as message, id,...

Thanks!

Icarus · Accepted Answer · 2012-08-13 19:19:52Z

1

In SQL, that's done like this:

select 
      case blah when 1 then 'yes' 
                when 0 then 'no' 
      else 'maybe' end as blah ,
      columnb  ,
      columnc
from table

answered Aug 13, 2012 at 19:19

Icarus

64k14 gold badges102 silver badges116 bronze badges

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

Comments

Guerra · Accepted Answer · 2012-08-13 19:27:47Z

1

SELECT field1,field2,field3,
CASE field3
WHEN 0
THEN 'YES'
WHEN 1
THEN 'NO'
ELSE
'MAYBE'
END AS blah
FROM table

answered Aug 13, 2012 at 19:27

Guerra

2,7882 gold badges24 silver badges32 bronze badges

Comments

spencer7593 · Accepted Answer · 2012-08-13 19:34:33Z

1

A terser alternative to a CASE expression is to nest two IF functions in an expression, e.g.

SELECT If(blah=0,'Yes',IF(blah=1,'no','maybe')) AS blah

answered Aug 13, 2012 at 19:34

spencer7593

109k15 gold badges122 silver badges148 bronze badges

Collectives™ on Stack Overflow

mysql if else for asp.net gridview

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related