Database

OleDbConnection myConn = new OleDbConnection(myConnection);
  OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
  myDataAdapter.SelectCommand = new OleDbCommand(mySelectQuery, myConn);
  OleDbCommandBuilder cb = new OleDbCommandBuilder(myDataAdapter);

  myConn.Open();

  DataSet ds = new DataSet();
  myDataAdapter.Fill(ds, myTableName);

  //code to modify data in DataSet here

  //Without the OleDbCommandBuilder this line would fail
  myDataAdapter.Update(ds, myTableName);

  myConn.Close();

   dataCommand.Connection = dataConnection;	
   dataCommand.CommandText = "SELECT password FROM users WHERE username = 'dash' ";
  try
  {
   object o  = dataCommand.ExecuteScalar();
   if(o == null)
   {
     ...
   }
   else
   {
      string thePwd =(string)o ;
      if(thePwd.Equals("myPwd"))
      {
        ...
      }

   }
  }
  finally
  {
    dataConnection.Close();
    dataConnection.Dispose();
  }
....

try  
{ 
object o  = dataCommand.ExecuteScalar();
if(o == null)//if null then software has been installed already
{
//dataCommand.CommandText = "SELECT password, FROM users_id WHERE username = '"+ fp.Value() +"' ";
//object p  = dataCommand.ExecuteScalar();				
//if (p.ToString() == fp.Value())//verify that the machine has been logged in before
//{
//	LogTransAxs();//log this transaction
//dataConnection.Close(); 
//dataConnection.Dispose();
//	InitializeComponent();//start the program
//	Connection();//load the treeview
//}
//else// did not verify the machine had logged in before
//{
InitializeComponent2();//show the logoff screen/window
dataConnection.Close(); 
dataConnection.Dispose();
}				
else   
{ 
string thePwd =(string)o ;
if(thePwd.Equals("board"))
{						
dataConnection.Close(); //close the Scalar connection
dataConnection.Dispose();
InitializeComponent();//start the program
InitialTransAxs();//log the initial entry to the user_id tbl for use later to verify machine has logged in before
Connection();//load the treeview			
}  
}  
}
catch (Exception e)
{
MessageBox.Show("(003) Sorry you are not authorized to view this material." +e.Message +e.StackTrace);
}
finally 
{ 
dataConnection.Close(); 
dataConnection.Dispose();
}