Guest User

Untitled

a guest
Oct 23rd, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.85 KB | None | 0 0
  1. public void InvokeDataGridAddress()
  2. {
  3. switch (ComboBoxSelection.Text)
  4. {
  5. case "NASLOV":
  6. comboBoxValue = "SELECT * FROM [cbu_naslovi] WHERE [ADDRESS] LIKE '%" + search.Text + "%' COLLATE Latin1_general_CI_AI";
  7. break;
  8. case "LASTNIK":
  9. comboBoxValue = "SELECT [cbu_naslovi].* FROM [cbu_deli], [cbu_naslovi] WHERE [cbu_deli].LASTNIK LIKE '%" + search.Text + "%' COLLATE Latin1_general_CI_AI AND [cbu_deli].IDX = [cbu_naslovi].ID";
  10. break;
  11. case "OBJEKT":
  12. comboBoxValue = "SELECT * FROM [cbu_naslovi] WHERE [SO] LIKE '%" + search.Text + "%'";
  13. break;
  14. case "PARCELA":
  15. comboBoxValue = "SELECT * FROM [cbu_naslovi] WHERE [P1] LIKE '%" + search.Text + "%' OR [P2] LIKE '%" + search.Text + "%' OR [P3] LIKE '%" + search.Text + "%' OR [P4] LIKE '%" + search.Text + "%' OR [P5] LIKE '%" + search.Text + "%' OR [P6] LIKE '%" + search.Text + "%' OR [P7] LIKE '%" + search.Text + "%' OR [P8] LIKE '%" + search.Text + "%' OR [P9] LIKE '%" + search.Text + "%' OR [P10] LIKE '%" + search.Text + "%' OR [P11] LIKE '%" + search.Text + "%' OR [P12] LIKE '%" + search.Text + "%' OR [P13] LIKE '%" + search.Text + "%' OR [P14] LIKE '%" + search.Text + "%' OR [P15] LIKE '%" + search.Text + "%' OR [P16] LIKE '%" + search.Text + "%' OR [P17] LIKE '%" + search.Text + "%'";
  16. break;
  17. }
  18. comboBoxValue = comboBoxValue + " ORDER BY [ULICA] ASC, [OBMOCJE] ASC, LEN ([HS]) ASC, [HS] ASC, [HID] ASC";
  19. SqlCommand cmd = new SqlCommand
  20. {
  21. CommandText = comboBoxValue,
  22. Connection = con
  23. };
  24. Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;
  25. SqlDataAdapter da = new SqlDataAdapter(cmd);
  26. dtAddress.Clear();
  27. da.Fill(dtAddress);
  28. dg_address.ItemsSource = dtAddress.DefaultView;
  29. Mouse.OverrideCursor = System.Windows.Input.Cursors.Arrow;
  30. }
Add Comment
Please, Sign In to add comment