title: create login page in asp.net
body: <p>it has been many many years since i last touched asp.net and visual studio and i have completely forgotten all about it, but unfortunately i have been tasked to create a "simple" web portal so i need help... lots of help!</p>
  
  <p>i am using sql server 2012 as my db.</p>
  
  <p>name of the db is <code>DB1</code>.</p>
  
  <p>username and password data has already been populated in <code>Table1(username, password)</code>.</p>
  
  <p>i believe i have somehow managed to setup the connection to the db.
  <br/>
  <br/></p>
  
  <p><strong>web.config</strong></p>
  
  <pre><code>&lt;configuration&gt;
    &lt;connectionStrings&gt;
      &lt;add name="CapstoneConnectionString1" connectionString="Data Source=PC1\SQLEXPRESS;Initial Catalog=DB1;Integrated Security=True"
        providerName="System.Data.SqlClient" /&gt;
    &lt;/connectionStrings&gt;
    &lt;system.web&gt;
      &lt;compilation debug="true" strict="false" explicit="true" targetFramework="4.5"/&gt;
      &lt;httpRuntime targetFramework="4.5"/&gt;
    &lt;/system.web&gt;
  &lt;/configuration&gt;
  </code></pre>
  
  <p><br/><br/>
  so in my login.aspx page, how do i...</p>
  
  <p>Q1. read the data from user input text fields?</p>
  
  <p>Q2. how do i connect to the db on the aspx page so that i can perform sql query?</p>
  
  <p>Q3. how do i perform the username/password validation?</p>