title: Connect with OleDbConnection
body: <p>I am trying to connect to a database with two tables.  However, after I try and log in, I have an error.  The error says there is no row at spot zero.  I think this is because of my connection:</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Web;
  using System.Web.UI;
  using System.Web.UI.WebControls;
  using System.Data;
  using System.Data.OleDb;
  
  namespace Project3
  {
  
  public partial class _Default : System.Web.UI.Page
  {
  
      protected void Page_Load(object sender, EventArgs e)
      {
  
      }
  
      protected void login_Click(object sender, EventArgs e)
      {
          OleDbConnection connect = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\parodeghero\\Documents\\Visual Studio 2010\\Projects\\Project3\\Project3\\App_Data\\QA.mdb;Persist Security Info=True");
          //set up connection string
          OleDbCommand command = new OleDbCommand("select * from Employee where Login=@login", connect);
          OleDbParameter param0 = new OleDbParameter("@login", OleDbType.VarChar);
  
          param0.Value = employeeID.Text;
          command.Parameters.Add(param0);
  
          //middle tier to run connect
          OleDbDataAdapter da = new OleDbDataAdapter(command);
  
          DataSet dset = new DataSet();
  
          da.Fill(dset);
  
          //problem line
         if (dset.Tables[0].Rows[0]["Password"].ToString().Equals(password.Text))
          {
  </code></pre>