title: Display data in table from SQL Server database
body: <p>I want to manually create a table in asp.net to display data from a mssql database. I have set up a connection like this: </p>
  
  <pre><code>SqlConnection connection = new SqlConnection("server = servername; uid = username; pwd = password; database = database;");
   connection.Open();
  </code></pre>
  
  <p>So I need to know a simple way to use this connection to display data in a table. I then want to be able to edit the data in this database, as well as add new data.</p>