private void EditaFornecedor() { SqlConnection con = new SqlConnection(WindowsFormsApp5.Properties.Settings.Default.DuckDuckConnectionString); SqlCommand cmd = new SqlCommand("s_Edita_Dados_Fornecedor", con); cmd.Parameters.AddWithValue("@codigo", codigo); cmd.Parameters.AddWithValue("@empresa", 0); cmd.Parameters.AddWithValue("@nome", TxtNome.Text); cmd.Parameters.AddWithValue("@email", TxtEmail.Text); cmd.Parameters.AddWithValue("@sexo", cboSexo.Text); cmd.Parameters.AddWithValue("@telefone", TxtTelefone.Text); cmd.Parameters.AddWithValue("@celular", TxtCelular.Text); cmd.Parameters.AddWithValue("@CEP", TxtCEP.Text); cmd.Parameters.AddWithValue("@RG", TxtRG.Text); cmd.Parameters.AddWithValue("@CPF", TxtCPF.Text); cmd.Parameters.AddWithValue("@CNPJ", ""); cmd.Parameters.AddWithValue("@IE", ""); cmd.Parameters.AddWithValue("@endereco", TxtEndereco.Text); cmd.Parameters.AddWithValue("@descricao", TxtDescricao.Text); //seta o valor apra inserção da procedure cmd.CommandType = CommandType.StoredProcedure; con.Open(); try { int i = cmd.ExecuteNonQuery(); telacadastro.Atualiza_Lista(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } }
private void button1_Click(object sender, EventArgs e) { testaInsercao(); telacadastro.Atualiza_Lista(); }