string user = lblUsername.Text;
            string pass = lblPass.Text;
            string myConn = "datasource=localhost;database=posbase;port=3306;username=root;password=root;";
            MySqlConnection Conn = new MySqlConnection(myConn);
            Conn.Open();
            //i had 2 make a pun to make this work!!
            string croofname = "";
            string croolname = "";
            MySqlCommand getme = new MySqlCommand();
            getme.CommandText = "select * from accounttbl where userid = ?userid";
            getme.Connection = Conn;
            getme.Parameters.AddWithValue("?userid", user.Trim());
            MySqlDataReader read;

            read = getme.ExecuteReader();
            while (read.Read())
            {
                croofname = read.GetString("fname").ToString();
                croolname = read.GetString("lname").ToString();
            }
            Conn.Close();
            Conn.Open();

            MySqlCommand cmd = new MySqlCommand();
            cmd.CommandText = "Select userid, pass, usertype from accounttbl where userid = ?userid and pass =?password";
            cmd.Parameters.AddWithValue("?userid", user.Trim());
            cmd.Parameters.AddWithValue("?password", pass.Trim());
            cmd.Connection = Conn;


            MySqlCommand cmd2 = new MySqlCommand();
            cmd2.Connection = Conn;
            cmd2.CommandText = "update posbase.usersession set user=?user WHERE id=?id";
            cmd2.Parameters.AddWithValue("?user", user.Trim());
            cmd2.Parameters.AddWithValue("?id", 1);
            cmd2.ExecuteNonQuery();
            MySqlCommand cmd3 = new MySqlCommand();
            cmd3.Connection = Conn;
            cmd3.CommandText = "insert into loginhistory(user, time, date, crewname) value(?user, ?time, ?date, ?crewname)";
            cmd3.Parameters.AddWithValue("?user", user.Trim());
            cmd3.Parameters.AddWithValue("?time", DateTime.Now.ToShortTimeString());
            cmd3.Parameters.AddWithValue("?date", DateTime.Now.ToShortDateString());
            cmd3.Parameters.AddWithValue("?crewname", croofname + " " + croolname);
            cmd3.ExecuteNonQuery();