teejayniles
New Member
Hi, how do get Aggregate function values from a database and set the an asp.net label equal to it. I have been trying to use the GetString function in the sqldatareader, with no luck. Do i use ado.net, and select the sum that way and set it equal to the label.text?once your datareader is open:<BR>dim somevariable as string<BR>while datareader.read<BR> if not datareader.isdbnull(indexhere) then<BR> somevariable = somevariable & datareader.getstring(indexhere).tostring (if not already a string)<BR> End if<BR>End While<BR><BR>label.text = somevariable<BR><BR>And remember, you can use html in the label.