SQL Question

[Mike]

I'm pulling a data from a column of my SQL DB.The column values are Yes and
No,
what i need to is the value is Yes then write out Helper if its No write
Need Help in my grid

How can i do that?

would this work

SQL = "select RD as type from HelperTable"

if Type = "Yes" then
type = "Helper"
else
type = "Need help"
end if

would this work or no

 

[[MSFT]]

Hi Mike,

You may get the data with SqlDataReader in ADO.NET. Here is a sample:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q308656
HOW TO: Open a SQL Server Database by Using the SQL Server .NET Data
Provider with Visual Basic .NET

Luke
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

 

[Dan Brussee]

SELECT CASE
WHEN Type = 'Yes' THEN 'Helper'
WHEN Type = 'No' THEN 'Need help'
END as Type
FROM HelperTable

 

[Mike]

I can open the database with no problem. So this didn't help

 

[Mike]

thanks, I'll give this a shot

SELECT CASE
WHEN Type = 'Yes' THEN 'Helper'
WHEN Type = 'No' THEN 'Need help'
END as Type
FROM HelperTable