MySqlConnection con = new MySqlConnection(mysqlcomnnection);
string CommandText = "Select userid as UserID, firstname as FirstName,lastname as LastName from users";
MySqlCommand cmd = new MySqlCommand(CommandText, con);
MySqlDataAdapter sda = new MySqlDataAdapter(cmd);