I have a gridview that I am wanting to divide one column by another from the code behind. The code works properly but the grid does not display the proper numbers it only displays 0 or 1 etc. I am trying to have it show the percentage for ex. if i have 16 tickets and 6 closed my avg in the grid should...
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
cgreene.gsu
on
07-24-2008, 12:00 AM
Filed under: (SELECT condition, .NET 2.0, asp .NET 2.0, asp.net 2.0, asp.net2.0, asp.net2.0(c#), c#, Datagrid, gridview, join, SELECT, Select * from tablename where column1 = (), Select * from tablename where column1 in (), selectparameters, count(), Count(*), COUNT(condition) AS total FROM [JCM].[dbo].[jcmresults] GROUP BY condition), calculated column concatenation, 2 select statement problem