public List <Comments> selectComments(string idPlanet) { MySqlCommand sql; sql = new MySqlCommand( "SELECT * FROM comments" + " WHERE idPlanet = @idPlanet"); sql.Parameters.Add(new MySqlParameter("@idPlanet", idPlanet)); ConexaoBanco banco = new ConexaoBanco(); banco.Connect(); MySqlDataReader reader = banco.Search(sql); List <Comments> com = new List <Comments>(); while (reader.Read()) { Comments comment = new Comments(); comment.comment = reader.GetString("comment"); comment.date = reader.GetString("date"); comment.name = reader.GetString("name"); comment.idPlanet = reader.GetString("idPlanet"); com.Add(comment); } reader.Close(); banco.Disconnect(); return(com); }
public void InsertComment(Comments coment) { MySqlCommand sql; sql = new MySqlCommand( "INSERT INTO comments(idPlanet, comment, name, date)" + " VALUE (@idPlanet, @comment, @name, @date)"); sql.Parameters.Add(new MySqlParameter("@idPlanet", coment.idPlanet)); sql.Parameters.Add(new MySqlParameter("@comment", coment.comment)); sql.Parameters.Add(new MySqlParameter("@name", coment.name)); sql.Parameters.Add(new MySqlParameter("@date", coment.date)); ConexaoBanco banco = new ConexaoBanco(); banco.Connect(); banco.Exec(sql); banco.Disconnect(); }