title: How to retrieve column value of sql server table and store it in label.Text of c# ASP.Net
body: <p>My question is </p>
  
  <p>Suppose I have a Column "fname" whose value is 'Nikhil' in table "profile".</p>
  
  <p>How to retrieve column value of sql server table and store it in label.Text of c# ASP.Net.</p>
  
  <p>I mean what should be the code if I want label text to be "fname" value that is "Nikhil"</p>
  
  <p>Connection is already done properly because I am able to display table data in Gridview.</p>
  
  <p>label1.Text = ?; // I want fname here</p>
  
  <p>Regards,</p>
  
  <p>Nikhil</p>