Esempio n. 1
0
        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();
        }
Esempio n. 2
0
 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);
     }
 }