title: Bind a record from dataset or datatable to a label
body: <p>Guys i want to print two records returned from a database to a label. I use dataset , browse through the column however could't bind as label does not have a datasource. Below is my code.</p>
  
  <pre><code>        SqlDataAdapter adp = new SqlDataAdapter();
          adp.SelectCommand = cmd;
          DataSet ds = new DataSet();
          adp.Fill(ds);
  
  
  
      if (ds.Tables[0].Rows.Count &gt; 0)
      {
          lblClient.Enabled = true;
          lblClient.Text = Convert.ToString(ds.Tables[0].Columns[0]);
          lblBranch.Text = Convert.ToString(ds.Tables[0].Columns["Bname"]);
  
  
      }
      connection.Close();
  </code></pre>
  
  <p>when i tried the above. It returns only the column name (i.e the string specified). Any alternative would be appreciated.</p>