Go through this link
http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/
Search for pivot table on google.
If you are using datset then
lblTest.Text= ds.Tables[0].Rows[3]["fn"].ToString();
If using datatable
lblTest.Text = table.Rows[3]["fn"].ToString();
If using datareader
DataReader dr = cmd.ExecuteReader();
int temp =0;
while(rdr.Read())
{
temp = temp+1;
if(temp ==3)
{
lblTest.Text = dr["fn"].Tostring();
}
}