SqlCommand comm = new SqlCommand();
comm.Connection = ConnectionName;
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = "StoredProcedureName";
SqlDataReader dr;
dr = comm.ExecuteReader();
if (dr.HasRows == true)
{
dr.Read();
Label1.Text = dr["DataField"].ToString();
dr.Close();
}