here is my solution, i haven't tried it now but i've used it earlier. hope so this will work for you
string cmd = "SELECT COUNT(EventName) as count FROM EventTb";
con.open();
sqlCommand sqlcmd = new sqlCommand(cmd);
lblNumberOfPlyers.Text = sqlcmd.ExecuteScalar();
con.close();