title: Get data from SQL Server database into label
body: <p>In my ASP.Net webpage, I have a label and need the label's text to be retrieved from my database.</p>
  
  <p>I have no problem writing to my database, but it seems trying to retieve the data again is a mission...</p>
  
  <p>What I need is to get the data from the <code>Price</code> column in my database, from the table <code>Tickets</code>, from the record where the <code>ConcertName</code> data is the same as my webpage's title, or a string associated with my webpage.</p>
  
  <p>I have tried many tutorials already, but all just throw me errors, so I decided to try one last place before I just give in and make my labels static.</p>
  
  <p>In case it helps, I have tried the following:</p>
  
  <p><a href="http://www.daniweb.com/web-development/aspnet/threads/149283/displaying-data-from-database-to-textbox" rel="nofollow noreferrer">First Try</a></p>
  
  <p><a href="http://forums.asp.net/t/1368431.aspx" rel="nofollow noreferrer">Second Try</a></p>
  
  <p><a href="https://stackoverflow.com/questions/6178694/how-to-display-database-data-in-textbox">Third Try</a></p>
  
  <p><a href="https://stackoverflow.com/questions/5792167/how-to-get-data-to-textbox-from-the-database">Fourth Try</a></p>