Hi. I sort of at a stand still right now with a datagrid. I have a bit column in my database and if the field = 0, in the datagrid it needs to display No and if the field = 1, it should display Yes. I'm having a hard time with this. Could someone help me?

You can do it one of 2 ways. The first way would be to use a case statement in your SQL:

SELECT
     case <bitcolumn>
       when 1 then 'Yes'
       else 'No'
     end as <columnName>
From <table>

or you can handle the RowDataBound event of the datagrid and manipulate the value there as the row gets bound to the datasource. Do a google search on how to handle this event if that is the route you want to go.

hth

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

Are you talking about like this? Because it keeps throwing up the error "Incorrect syntax near the keyword 'CASE'."

Select vchCompanynumber, vchAAPNumber, vchCompanyName, vchAAPFirstname, vchAAPLastName, bActive

CASE bActive

WHEN 0 THEN
        "No"
    WHEN 1 THEN
        "Yes"
    END as bActive

from tblAAPInfo

where vchCompanynumber like @conumber or vchAAPNumber like @APNumber or vchCompanyname like @coname or vchAAPfirstname like @first or vchAAPlastname like @last or bactive like @bactive

No. You will want it to look like this:
Select vchCompanynumber, vchAAPNumber, vchCompanyName, vchAAPFirstname, vchAAPLastName,

CASE bActive

WHEN 0 THEN
        "No"
    WHEN 1 THEN
        "Yes"
END as bActive

from tblAAPInfo

Also, I tested this against SQL Server if you are using Access or another RDBMS such as MySQL the syntax may be different.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

Thanks for your help. I got it working.

Glad it worked for you.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========