private void btOk_Click(object sender, EventArgs e) { //SqlConnection Conn = DB.Connection(); //SqlCommand Comm = Conn.CreateCommand(); DBApp db = new DBApp(); db.openConnection(); SqlCommand Comm = db.Conn.CreateCommand(); if (Terminal > 0) { Comm.CommandText = "UPDATE Terminais SET TRM_DESCRICAO = @DESCRICAO, TRM_IP = @IP, " + "TRM_PORTA = @PORTA, TRM_GRUPO = @GRUPO, TRM_FABRICANTE = @FABRICANTE, " + "TRM_RAZAOSOCIAL = @RAZAOSOCIAL, TRM_CNPJ = @CNPJ, TRM_CPF = @CPF, TRM_ENDERECO = @ENDERECO, TRM_NUMERO = @NUMERO, TRM_SERIAL = @SERIAL " + "WHERE TRM_IND = " + Terminal.ToString(); } else { Comm.CommandText = "INSERT INTO Terminais (TRM_DESCRICAO, TRM_IP, TRM_PORTA, TRM_GRUPO, " + "TRM_FABRICANTE, TRM_RAZAOSOCIAL, TRM_CNPJ, TRM_CPF, TRM_ENDERECO, TRM_NUMERO, TRM_SERIAL) VALUES (@DESCRICAO, " + "@IP, @PORTA, @GRUPO, @FABRICANTE, @RAZAOSOCIAL, @CNPJ, @CPF, @ENDERECO, @NUMERO, @SERIAL)"; } Comm.Parameters.Add(new SqlParameter("@DESCRICAO", edDescricao.Text)); Comm.Parameters.Add(new SqlParameter("@IP", edIp.Text)); Comm.Parameters.Add(new SqlParameter("@PORTA", edPorta.Text)); Comm.Parameters.Add(new SqlParameter("@GRUPO", Grupo)); Comm.Parameters.Add(new SqlParameter("@FABRICANTE", "TRIX")); Comm.Parameters.Add(new SqlParameter("@RAZAOSOCIAL", edRazaoSocial.Text)); Comm.Parameters.Add(new SqlParameter("@CNPJ", edCnpj.Text)); Comm.Parameters.Add(new SqlParameter("@CPF", edCpf.Text)); Comm.Parameters.Add(new SqlParameter("@ENDERECO", edEndereco.Text)); Comm.Parameters.Add(new SqlParameter("@NUMERO", edNumero.Text)); Comm.Parameters.Add(new SqlParameter("@SERIAL", edSerial.Text)); Comm.ExecuteNonQuery(); db.closeConnection(); //Conn.Close(); this.Close(); }