title: Microsoft Database mdb Form Login
body: <p>I am trying to get the Form to place the login information to login to the student account using their ID and password from the <code>DATABASE</code> code</p>
  
  <p>How do I add the <code>studentiD</code> and <code>Password</code> to the form and get it to execute?</p>
  
  <p>Here is the database :</p>
  
  <p><a href="http://puu.sh/haOqn/39fcca19a5.png" rel="nofollow">http://puu.sh/haOqn/39fcca19a5.png</a></p>
  
  <p>Student Class: </p>
  
  <pre><code>    class Student : Person
      {
          private int iD;
          private String password;
          private String eMail;
          private double gpa;
          private String message;
  
  
          public Student() : base()
          {
              this.iD = 0;
              this.password = "";
              this.eMail = "";
              this.gpa = 0;
          }
          public Student(int i, String pa, String eM, int gp) : base()
          {
              this.iD = i;
              this.password = pa;
              this.eMail = eM;
              this.gpa = gp;
              InsertDB();
          }
          public Student(int iD)
          {
              SelectDB(iD);
          }
          //++++++++++++++++  DATABASE Data Elements +++++++++++++++++
          public System.Data.OleDb.OleDbDataAdapter OleDbDataAdapter;
          public System.Data.OleDb.OleDbCommand OleDbSelectCommand;
          public System.Data.OleDb.OleDbCommand OleDbInsertCommand;
          public System.Data.OleDb.OleDbCommand OleDbUpdateCommand;
          public System.Data.OleDb.OleDbCommand OleDbDeleteCommand;
          public System.Data.OleDb.OleDbConnection OleDbConnection;
          public string cmd;
  
          public void DBSetup()
          {
              // +++++++++++++++++++++++++++  DBSetup function +++++++++++++++++++++++++++
              // This DBSetup() method instantiates all the DB objects needed to access a DB, 
              // including OleDbDataAdapter, which contains 4 other objects(OlsDbSelectCommand, 
              // oleDbInsertCommand, oleDbUpdateCommand, oleDbDeleteCommand.) And each
              // Command object contains a Connection object and an SQL string object.
              OleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter();
              OleDbSelectCommand = new System.Data.OleDb.OleDbCommand();
              OleDbInsertCommand = new System.Data.OleDb.OleDbCommand();
              OleDbUpdateCommand = new System.Data.OleDb.OleDbCommand();
              OleDbDeleteCommand = new System.Data.OleDb.OleDbCommand();
              OleDbConnection = new System.Data.OleDb.OleDbConnection();
  
  
              OleDbDataAdapter.DeleteCommand = OleDbDeleteCommand;
              OleDbDataAdapter.InsertCommand = OleDbInsertCommand;
              OleDbDataAdapter.SelectCommand = OleDbSelectCommand;
              OleDbDataAdapter.UpdateCommand = OleDbUpdateCommand;
  
  
              OleDbConnection.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Reg"+
              "istry Path=;Jet OLEDB:Database L" + 
              "ocking Mode=1;Data Source=c:\\RegistrationMDB.accdb;J" + 
              "et OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:System datab" + 
              "ase=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=S" + 
              "hare Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet " + 
              "OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repai" + 
              "r=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";
  
          }
  
          public void SelectDB(int id) 
          { 
              //++++++++++++++++++++++++++  SELECT +++++++++++++++++++++++++
              DBSetup();
              cmd = "Select * from Students where ID = " + iD;
              OleDbDataAdapter.SelectCommand.CommandText = cmd;
              OleDbDataAdapter.SelectCommand.Connection = OleDbConnection;
              Console.WriteLine(cmd);
              try  {
                      OleDbConnection.Open();
                      System.Data.OleDb.OleDbDataReader dr;
                      dr = OleDbDataAdapter.SelectCommand.ExecuteReader();
  
                      dr.Read();
                      id=iD;
                      setPassword(dr.GetValue(1)+"");
                      setEMail(dr.GetValue(2)+"");
  
                      setGpa(Double.Parse(dr.GetValue(3)+""));
              }
              catch (Exception ex) 
              {
                  Console.WriteLine(ex);
              }
              finally 
              {
                  OleDbConnection.Close();
              }                    
          }
  
          public void InsertDB() 
          {
              // +++++++++++++++++++++++++++  INSERT +++++++++++++++++++++++++++++++
  
              DBSetup();
              cmd = "INSERT into Students values(" + getID() + "," +
                               "'" + getPassword() + "'," +
                               "'" + getEMail() + "'," +
                              "'" + getGpa() +  ")";
  
              OleDbDataAdapter.InsertCommand.CommandText = cmd;
              OleDbDataAdapter.InsertCommand.Connection = OleDbConnection;
              Console.WriteLine(cmd);
              try  
              {
                  OleDbConnection.Open();
                  int n = OleDbDataAdapter.InsertCommand.ExecuteNonQuery();
                  if (n==1)
                      Console.WriteLine("Data Inserted");
                  else
                      Console.WriteLine("ERROR: Inserting Data");
              }
              catch (Exception ex) 
              {
                  Console.WriteLine(ex);
              }
              finally 
              {
                  OleDbConnection.Close();
              }                
          }
          public void updateDB() 
          {
              //++++++++++++++++++++++++++  UPDATE  +++++++++++++++++++++++++
  
              cmd = "Update Students set ID = '" + getID() + "'," + 
                          "Password = '" + getPassword() +    "', " +
                          "Email = '" + getEMail() + "', " +
                           "GPA = " + getGpa();
  
              OleDbDataAdapter.UpdateCommand.CommandText = cmd;
              OleDbDataAdapter.UpdateCommand.Connection = OleDbConnection;
              Console.WriteLine(cmd);
              try  
              {
                  OleDbConnection.Open();
                  int n = OleDbDataAdapter.UpdateCommand.ExecuteNonQuery();
                  if (n==1)
                      Console.WriteLine("Data Updated");
                  else
                      Console.WriteLine("ERROR: Updating Data");
              }
              catch (Exception ex) 
              {
                  Console.WriteLine(ex);
              }
              finally 
              {
                  OleDbConnection.Close();
              }                    
          }
  
          public void deleteDB() 
          {
              //++++++++++++++++++++++++++  DELETE  +++++++++++++++++++++++++
  
              cmd = "Delete from Students where ID = " + getID();
              OleDbDataAdapter.DeleteCommand.CommandText = cmd;
              OleDbDataAdapter.DeleteCommand.Connection = OleDbConnection;
              Console.WriteLine(cmd);
              try  
              {
                  OleDbConnection.Open();
                  int n = OleDbDataAdapter.DeleteCommand.ExecuteNonQuery();
                  if (n==1)
                      Console.WriteLine("Data Deleted");
                  else
                      Console.WriteLine("ERROR: Deleting Data");
              }
              catch (Exception ex) 
              {
                  Console.WriteLine(ex);
              }
              finally 
              {
                  OleDbConnection.Close();
              }                    
          }
  
  
  
  
  
          public void setID(int iD)
          {
              this.iD = iD;
          }
  
          public void setPassword(String password)
          {
              this.password = password;
          }
  
  
          public void setEMail(String eMail)
          {
              this.eMail = eMail;
          }
          public void setGpa(double gpa)
          {
              this.gpa = gpa;
          }
  
          public int getID()
          {
              return iD;
          }
  
  
          public String getPassword()
          {
              return password;
          }
  
  
  
          public String getEMail()
          {
              return eMail;
          }
  
          public double getGpa()
          {
              return gpa;
          }
          public String getMessage()
          {
              return this.message;
          }
  
          public void displays()
          {
              System.Console.WriteLine("ID =  "+ getID());
              System.Console.WriteLine("Password =   "+ getPassword());
              System.Console.WriteLine("Email =  " + getEMail());
              System.Console.WriteLine("GPA =  " + getGpa());            
          }
      }
  </code></pre>
  
  <p>The Form:</p>
  
  <pre><code>namespace Students
  {
      public partial class StudentLogin : Form
      {
          public StudentLogin()
          {
              InitializeComponent();
          }
  
          private void Logingo_Click(object sender, EventArgs e)
          {
  
          }
  
          private void textBox1_TextChanged(object sender, EventArgs e)
          {
  
          }
      }
  }
  </code></pre>