To write a record to a label you will need a SqlDataReader and you can do whatever you like while stepping through the reader object. Well, that is the fastest way anyway.
From a dataset loop through it like this:
for (int i = 0; i < dSet.Tables["tblCMS"].Rows.Count; i++)
int lngPrimaryKeyId =
lblWelcome.Text = lngPrimaryKeyId.ToString();
But remember, this is to loop through each item. But from the above, I am sure you can figure out to just get the first item. Which will not be done in a loop.
PS. The above is in C#. My VB skills are long bug forgotten. Good luck