Select Count() if else

Question

Hello I have a question: I have a Count() query it is shown in a datagrid. But how can you make the datagrid to shown that when a value is less then 4 is says to less os an ohter sentence? I hope someone can help me because i been searching for this answer for a week now. Thanks ABC

abcastermans · Answer

Thanks I've tried the first one and it worked. Bye ABC

yasser_8227 · Answer

Hi If you are using MS SQL Server then you can modify your query to return 'to less' if count() is less than 4: select CASE When count(*) < 1 Then 'To Less' ELSE cast(count(*) as varchar) END as 'Count' from test or you can use ItemDataBound event of DataGrid to progamatically change the value at runtime for each row. On more info on ItemDataBound and how to do this check this out: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwebuiwebcontrolsdatagridclassitemdataboundtopic.asp http://www.csharphelp.com/archives3/archive570.html http://www.codeproject.com/aspnet/ItemCreated.asp Cheers Yasser