C#

<small>		DateTime dt = DateTime.Now;
		//CustomStorage.ApplicationStorage dbInfo = new CustomStorage.ApplicationStorage();
		string usename = System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString();
		string sqlSelect = "SELECT password FROM user_id WHERE username = 'dash' ";
		
						
		private void dbConnect()
		{
			dataConnection.ConnectionString = "user ID=blah;Pwd=blah;Initial Catalog=blah;Data Source=blah";
			dataConnection.Open();
			dataCommand.Connection = dataConnection;
		}
		private void InitialTransAxs()
		{
			this.Cursor = Cursors.WaitCursor;
			Fingerprint fp = new Fingerprint();
			//statusBar1.Text="Please Wait";
			string MacID = fp.Value().ToString();
			
			try
			{
				string shostname;
				string result;
				
				result = System.Environment.MachineName;//Retrieve the NetBIOS name.				
				shostname = Dns.GetHostName().ToString();
				//dbConnect();
				dataCommand.CommandText = "insert into user_id (username, password, computer_name, dns_name) values ('" + usename + "', '" + MacID + "', '"+ result +"', '" + shostname + "')";
				//dataCommand.CommandText = "update user_id set password = null where username = 'dash'";
				dataCommand.ExecuteNonQuery();				
				dataCommand.CommandText = "update user_id set password = null where username = 'dash'";
				dataCommand.ExecuteNonQuery();
				//dataConnection.Close();
				this.Cursor = Cursors.Default;
				
			}
			catch (Exception e)
			{
				MessageBox.Show("(001) Sorry Could not connect to the database, please try again later." +e.Message + e.StackTrace);
				
				//myform.Dispose();
			}
			finally 
			{
				
				
				//LoadAccess();
			}
		}
		private void LogTransAxs()
		{
			this.Cursor = Cursors.WaitCursor;
			
			Fingerprint fp = new Fingerprint();
			//statusBar1.Text="Please Wait";
			string MacID = fp.Value().ToString();
			string shostname;
			string result;
			try
			{
				//Retrieve the NetBIOS name.
				result = System.Environment.MachineName;
				shostname = Dns.GetHostName().ToString();
				dataCommand.CommandText = "insert into TransAxs (username, password, computer_name, dns_name, date) values ('" + usename + "', '" + MacID + "', '"+ result +"', '" + shostname + "','"+ dt +"')";
				dataCommand.ExecuteNonQuery();
			}
			catch (Exception es)
			{
			MessageBox.Show("(002) Sorry Could not connect to the database, please try again later." +es.Message +es.StackTrace);
			}
		}

		private void LoadAccess()
		{
			this.Cursor = Cursors.WaitCursor;
			Fingerprint fp = new Fingerprint();
				dbConnect();
				dataCommand.CommandText = sqlSelect;
				
			try  
			{ 
				//if the password = board --then run LoadMACid, 
				//if the password = null     --then run intial2, 
				//if the password = macid --then run intial1
				
				// initialise your stuff
				
				bool loginOk = false;
				bool IdOK = false;
				object o  = dataCommand.ExecuteScalar();
				string thePwd = o as string;
				if( thePwd != null)//if null then software has been installed already
				{ 
					if( thePwd.Equals("board"))
					{
						loginOk = true;
					}
				}
				if(loginOk == true)
				{ 
					InitialTransAxs();//log this transaction
					LogTransAxs();
					InitializeComponent();//start the program
					Connection();//load the treeview
					dataConnection.Close();
					dataConnection.Dispose();
				}
				else if (loginOk == false)
				{
					dataCommand.CommandText = "SELECT password FROM user_id WHERE password = '"+ fp.Value() +"' ";
					object p  = dataCommand.ExecuteScalar();
					if (p != null)
					{
						if (p.Equals(fp.Value().ToString()))
						{
							IdOK = true;
						}
					}
					if (IdOK == true)//verify that the machine has been logged in before
					{
						LogTransAxs();//log this transaction
						InitializeComponent();//start the program
						Connection();//load the treeview
					}
					else
					{
						InitializeComponent2();//show the logoff screen/window
						dataConnection.Close();
						dataConnection.Dispose();
					}				
				}
				else
				{
					InitializeComponent2();//show the logoff screen/window
					dataConnection.Close();
					dataConnection.Dispose();
				}
			}
			catch (Exception e)
			{
				MessageBox.Show("(003) Sorry you are not authorized to view this material." +e.Message +e.StackTrace);
			}
			finally 
			{ 
				dataConnection.Close(); 
				dataConnection.Dispose();
			}
				this.Cursor = Cursors.Default;
			
		</small>