private int GetTableRows() { int rows; using(MySqlConnection con = new MySqlConnection(CONNECTION_STRING)) using(MySqlCommand cmd = new MySqlCommand()) { con.Open(); cmd.Connection = con; cmd.CommandText = "SELECT * FROM myTable"; rows = int.Parse(cmd.ExecuteScaler().ToString()); } return rows; }