Forums - C# Corner

Forum guidelines
Mukesh

Mukesh

  • 1.6k
  • 104
  • 5.9k

How to use condition for row invisible and visible

May 10 2017 3:01 AM
SELECT uniquiID,
CountryFlag,
EventImage
,CONVERT(varchar(50), StartDate) as StartDate
,CONVERT(varchar(50), EndDate) as EndDate
,EventName
,Description
,CountryCode
,Remark
,Flag
FROM TradefairData
 
this my table-
and my flag column value is -   Null
                                                   0
                                                   1
                                                   Null
                                                   0
                                                  1
 
Then i Want to Know how to Use case when flag=1 then 3rd and 6th row invisible when flag=0 then all row visible else all row visible please help me
 uniquiID is my uniqueId Column
 
 

Answers (6)

X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now