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: selectparameters, .NET 2.0, asp.net 2.0, c#, calculated column concatenation, count(), Count(*), COUNT(condition) AS total FROM [JCM].[dbo].[jcmresults] GROUP BY condition), Datagrid, asp.net2.0, asp.net2.0(c#), Select * from tablename where column1 = (), (SELECT condition, gridview, asp .NET 2.0, join, 2 select statement problem, SELECT, Select * from tablename where column1 in ()