} // Action[Click]: btnLogIn
private void textUsername_TextChanged(object sender, EventArgs e)
{
try
{
if (!Integrity.NoSpaceOnly(textUsername.Text.Trim()))
{
textUsername.Text = textUsername.Text.Substring(0, textUsername.Text.Trim().Length - 1);
textUsername.Select(textUsername.Text.Trim().Length, 1);
}
TextBox t = sender as TextBox;
if (t != null)
{
try
{
int resultCount = 0;
string sql = "SELECT strUsername " +
"FROM tblStaff " +
"WHERE strUsername LIKE '%" + textUsername.Text.Trim() + "%';";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
List <string> listCollect = new List <string>();
AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
while (reader.Read())
{
//listCollect.Add(reader.GetString("strUsername"));
collection.Add(reader.GetString("strUsername"));
resultCount++;
}
reader.Close();
collection.AddRange(listCollect.ToArray());
textUsername.AutoCompleteCustomSource = collection;
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
}
catch (Exception)
{
}
}
