Select Count() if else

abcastermans

21y3.7k.NET

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

abcastermans21y ago
Thanks, I've tried the first one and it worked. Bye, ABC
yasser_822721y ago
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