My Table Record
id Staff_ID DeptID
256 1049 7
257 1049 1
258 1049 4
i want above DeptID wise reterived check box (true) checked ticked.
Thanks
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abhishek KumarPosted Oct 10, 2014, 9:18 AM
In Designer code you need to
from databse you need to provide the result for DeptID as bit
I have added an example like below.
select CAST(CASE deptID WHEN isnull(deptID,'') THEN 0 ELSE 1 END AS BIT) as deptID from [dbo].[Students]
Hope this will help.
Abhishek
Nirmal KumarCPosted Oct 11, 2014, 7:16 AM
Rajeev RanjanPosted Oct 10, 2014, 7:19 AM