public static void buscaListBox(ListBox lst, string busca) { lst.Items.Clear(); conexao conexao = new conexao(); try { conexao.conectar(); MySqlCommand cmd = new MySqlCommand("SELECT NOME_ALUNO,PRONTUARIO_ALUNO FROM ALUNO WHERE NOME_ALUNO LIKE ? ", conexao.bdConn); cmd.Parameters.AddWithValue("@NOME_ALUNO", busca + "%"); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.Default); string texto; while (dr.Read()) { texto = dr[0].ToString(); texto = texto + "\t" + dr[1].ToString(); lst.Items.Add(texto); } } catch (Exception e) { MessageBox.Show("Ocorreu o seguinte erro: " + e.Message, "ERRO"); } finally { conexao.desconectar(); } }
private void btnExcluir_Click(object sender, EventArgs e) { DialogResult iResposta = MessageBox.Show("Deseja excluir este aluno?", "Confirma Exclusao", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (iResposta == DialogResult.Yes) { try { conexao conexao = new conexao(); conexao.conectar(); MySqlCommand cmd = new MySqlCommand("call deletarAluno(?)", conexao.bdConn); cmd.Parameters.AddWithValue("@id_aluno", txtId.Text); cmd.ExecuteReader(CommandBehavior.SingleRow); conexao.desconectar(); carregaListBox(lstAlunos); inicial(); } catch (Exception ex) { MessageBox.Show("Ocorreu o seguinte erro: " + ex.Message, "ERRO"); } } else { carregaListBox(lstAlunos); inicial(); } }
private void exibeDados(int prontuario, string nome) { conexao conexao = new conexao(); conexao.conectar(); MySqlCommand cmd = new MySqlCommand("SELECT * FROM ALUNO WHERE NOME_ALUNO=? AND id_aluno=?", conexao.bdConn); cmd.Parameters.AddWithValue("@NOME_ALUNO", nome); cmd.Parameters.AddWithValue("@id_aluno", prontuario); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleRow); if (dr.Read()) { txtId.Text = Convert.ToString(dr[("ID_ALUNO")]); txtNome.Text = Convert.ToString(dr[("NOME_ALUNO")]); txtProntuario.Text = Convert.ToString(dr[("PRONTUARIO_ALUNO")]); txtCurso.Text = Convert.ToString(dr[("CURSO_ALUNO")]); txtEmail.Text = Convert.ToString(dr[("EMAIL_ALUNO")]); txtCelular.Text = Convert.ToString(dr[("CELULAR_ALUNO")]); txtTelefone.Text = Convert.ToString(dr[("TELEFONE_ALUNO")]); } dr.Close(); conexao.desconectar(); }
public void carregaListBox(ListBox lst) { lst.Items.Clear(); idAluno = 0; conexao conexao = new conexao(); try { conexao.conectar(); MySqlCommand cmd = new MySqlCommand("SELECT * FROM ALUNO where status_aluno <> 2", conexao.bdConn); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.Default); string texto; while (dr.Read()) { texto = dr[0].ToString(); texto = texto + "\t" + dr[1].ToString(); lst.Items.Add(texto); } } catch (Exception e) { MessageBox.Show(Convert.ToString(e)); } finally { conexao.desconectar(); } }
private int nRep() { int i = 0; conexao conexao = new conexao(); conexao.conectar(); MySqlCommand cmd = new MySqlCommand("select count(id_republica) from republica", conexao.bdConn); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.Default); if (dr.Read()) { i = Convert.ToInt32(dr[0]); } conexao.desconectar(); return(i); }
public static void carregaListBox(ListBox lst) { conexao conexao = new conexao(); try { conexao.conectar(); MySqlCommand cmd = new MySqlCommand("SELECT NOME_ALUNO FROM ALUNO", conexao.bdConn); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.Default); while (dr.Read()) { lst.Items.Add(dr["NOME_ALUNO"]); } } catch (Exception e) { MessageBox.Show(Convert.ToString(e)); } finally { conexao.desconectar(); } }
private void btnExcluir_Click(object sender, EventArgs e) { DialogResult iResposta = MessageBox.Show("Deseja excluir esta Republica?", "Confirma Exclusao", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (iResposta.ToString() == "Yes") { conexao conexao = new conexao(); conexao.conectar(); MySqlCommand cmd = new MySqlCommand("call deletarRepublica(?);", conexao.bdConn); cmd.Parameters.AddWithValue("@id_republica", txtId.Text); cmd.ExecuteReader(CommandBehavior.SingleRow); conexao.desconectar(); carregaListBox(lstRepublica); inicial(); } else { carregaListBox(lstRepublica); inicial(); } }
private void btnAssociar_Click(object sender, EventArgs e) { conexao conexao = new conexao(); conexao.conectar(); MySqlCommand cmd; try { cmd = new MySqlCommand("call inseriRelacao(?,?)", conexao.bdConn); cmd.Parameters.AddWithValue("@aluno_id_aluno", txtAluno.Text); cmd.Parameters.AddWithValue("@republica_id_republica", txtRepublica.Text); cmd.ExecuteReader(CommandBehavior.SingleRow); } catch (Exception ex) { MessageBox.Show("Ocorreu o seguinte erro: " + ex.Message, "ERRO"); } finally { conexao.desconectar(); inicial(); } }
private void exibeDadosRep(int id) { conexao conexao = new conexao(); conexao.conectar(); MySqlCommand cmd = new MySqlCommand("SELECT * FROM REPUBLICA WHERE id_republica=?", conexao.bdConn); cmd.Parameters.AddWithValue("@id_republica", id); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleRow); if (dr.Read()) { txtNomeRep.Text = dr["NOME_REPUBLICA"].ToString(); txtAlunoResp.Text = dr["alunoResponsavel_republica"].ToString(); txtCapacidade.Text = dr["CAPACIDADE_REPUBLICA"].ToString(); txtVagas.Text = dr["VAGAS_REPUBLICA"].ToString(); txtTipo.Text = dr["TIPO_REPUBLICA"].ToString(); txtAluguel.Text = dr["preco_republica"].ToString(); txtDescricao.Text = dr["descricao_republica"].ToString(); txtRepublica.Text = dr["id_republica"].ToString(); } dr.Close(); conexao.desconectar(); }