private void btnBuscar_Click(object sender, EventArgs e) { if (rbMatricula.Checked == true) { SqlConnection SqlCon = new SqlConnection(); SqlCon.ConnectionString = Conexion.ConexionDB; SqlCon.Open(); try { if (txtBuscar.Text == string.Empty) { errorIcono.SetError(txtBuscar, "Ingrese la matricula"); } else { this.dataListado.DataSource = NUsuario.BuscarMatricula(this.txtBuscar.Text); string SqlSelectQuery = "SELECT * FROM Usuarios WHERE matricula = " + (txtBuscar.Text); SqlCommand cmd = new SqlCommand(SqlSelectQuery, SqlCon); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { txtIdUser.Text = (dr["idUsuario"].ToString()); txtMatricula.Text = (dr["matricula"].ToString()); txtNombre.Text = (dr["nombre"].ToString()); txtApellido.Text = (dr["apellidos"].ToString()); txtcbCarrera.Text = (dr["carrera"].ToString()); txtcbSexo.Text = (dr["sexo"].ToString()); txtcbTipoUsuario.Text = (dr["tipousuario"].ToString()); txtEmail.Text = (dr["email"].ToString()); } SqlCon.Close(); // } } catch (Exception ex) { MessageBox.Show(ex.Message + ex.StackTrace); } } else { this.dataListado.DataSource = NUsuario.BuscarNombreCompleto(this.txtBuscar.Text); } }
private void txtMatricula_TextChanged(object sender, EventArgs e) { this.dataListado.DataSource = NUsuario.BuscarMatricula(this.txtMatricula.Text); }