public void Salvar(Genero genero) { //1- Forma de Inserir os Dados //conexaoSql.command.CommandText = $"INSERT INTO Genero (Nome) values('{genero.Descricao}')"; conexaoSql.command.CommandText = $"INSERT INTO Genero (Nome) values(@nome)"; conexaoSql.command.Parameters.AddWithValue("@nome", genero.Descricao); conexaoSql.AbrirConexao(); conexaoSql.command.ExecuteNonQuery(); }
private void button1_Click(object sender, EventArgs e) { try { ConexaoSqlServer conn = new ConexaoSqlServer(); conn.AbrirConexao(); MessageBox.Show("Conectou"); conn.FecharConexao(); MessageBox.Show("Desconectou"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }