Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void txtBusca_TextChanged(object sender, EventArgs e)
- {
- if(comboBox1.Text == "Ativo")
- {
- string strSelect = "SELECT * FROM Produto WHERE Nome LIKE (@Nome)";
- using (MySqlConnection conn = new MySqlConnection("server=127.0.0.1;database=ProdPacote; Uid=root; pwd=1234;"))
- {
- MySqlDataAdapter da = new MySqlDataAdapter(strSelect, conn);
- //Passagem por parĂ¢metros.
- da.SelectCommand.Parameters.AddWithValue("@Nome", txtBusca.Text + "%");
- DataSet ds = new DataSet();
- da.Fill(ds, "Nome");
- dataGridView1.DataSource = ds.Tables["Nome"];
- }
- }
- string strSelect = "SELECT * FROM Produto WHERE Nome LIKE (@Nome) AND Activos=true";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement