Home All Groups Group Topic Archive Search About

displaying table count in label

Author
21 Mar 2006 5:52 PM
zoom14151
I have a project that I need to display the incident count from a
table. I have the connection, command, adapter and dataset. The dataset
has one column "2005" The connection is to a Oracle database. I can
preview the data in the dataset but I can't figure out to display it in
a labels text.

Author
21 Mar 2006 6:49 PM
jminond
You need to try to get the the value in the dataset.... lets say your
xommand returns one record set with only your value ( like an execute
scalar )
myLabel.Text = MyDS.Tables[0].rows[0]["2005"].ToString();

Let's say your command returns multiple recordsets and tables ( so that
you actually have a reason for needeing a dataset in the first place )
you would fetch it differnetlyu

myLabel.Text =
MyDS.Tables[RecordsetNumberContainintdata].rows[0]["2005"].ToString();

So if your command has
select * from whatever
select * from elsewhere
select val as 2005 from my table
then
RecordsetNumberContainintdata = 2

AddThis Social Bookmark Button