Dataset output to Label

Question

please excuse me as there may be a different and better way to do this if so please feel free but heres what i am trying to do. Any helps would be great!

Using vs2005

ok folks, i am currently trying to use a dataset that pulls data from sql server database and wish to show the final results in a label.

Database Name: miniCMS
From Table: Page
Column: PageID that equals 1

Hope this helps you answer my question.

Please point me in the right direction or even show me how to do this.

Thanks in advanced