Select ds.Tables("V_User_Sitedetail").Rows(0)("status").ToString
Case "F"
ds.Tables("V_User_Sitedetail").Rows(0).ToString = "พนักงานประจำ"
Case "P"
ds.Tables("V_User_Sitedetail").Rows(0).ToString = "พนักงานทดลองงาน"
Case "T"
ds.Tables("V_User_Sitedetail").Rows(0).ToString = "ฝึกงาน"
End Select
SELECT CustomerID, Name,
CASE CountryCode
WHEN 'TH' THEN 'Thailand'
WHEN 'EN' THEN 'English'
WHEN 'US' THEN 'United states'
ELSE 'Unknown'
END AS Country
FROM customer