Select all
using (var cnx = new OleDbConnection(new AdministradorDAO().conexao))
{
var sql =
@"insert into usuarios(matricula, nome, senha, nivel, maleta, email)
values (:matricula, :nome, :senha, :nivel, :maleta, :email)";
using (var cmd = new OleDbCommand(sql, cnx))
{
cnx.Open();
cmd.Parameters.AddWithValue("matricula", txt_matricula.Text);
cmd.Parameters.AddWithValue("nome", txt_nome.Text);
cmd.Parameters.AddWithValue("senha", txt_senha.Text);
cmd.Parameters.AddWithValue("nivel", DropDownList_nivel.Text);
cmd.Parameters.AddWithValue("maleta", txt_maleta.Text);
cmd.Parameters.AddWithValue("email", txt_email.Text);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (cnx.State == ConnectionState.Open) cnx.Close();
}
}
}
When doing the insert directly on the bank, it adds perfectly. Could anyone help me?
Select all
insert into actweb.usuarios (matricula, nome, senha, nivel, maleta, email) values ('TESTE', 'Frederico', 'TESTE', 1, 7000, 'daerror@error.com.br');