Comments by seundaniel (Top 4 by date)

Here on the click of the button...
private void btnClock_Click(object sender, EventArgs e)
{
lblSecure.Text = txbClock.Text;
if (lblSecure.Text != txbClock.Text)
try
{
con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Client Manager\SPORT.mdb");
con.Open();
str1 = "INSERT INTO Log SELECT ID, UName, PhoneNumber FROM Client WHERE ID = '" + txbClock.Text + "'";
comd = new OleDbCommand(str1, con);
Int32 recordsAffected = comd.ExecuteNonQuery();
//String name = rdr.ToString();
txbClock.Clear();
txbClock.Focus();
if (recordsAffected.ToString() == "0")
MessageBox.Show("Not a member yet or Incorrect Clock-In Details.");
else
if (recordsAffected.CompareTo() = lblSecure.Text)
comd.Cancel();

}
catch (Exception ce)
{
MessageBox.Show(ce.Message);
MessageBox.Show(ce.StackTrace);
MessageBox.Show(ce.Source);

}