Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void InvokeDataGridAddress()
- {
- switch (ComboBoxSelection.Text)
- {
- case "NASLOV":
- comboBoxValue = "SELECT * FROM [cbu_naslovi] WHERE [ADDRESS] LIKE '%" + search.Text + "%' COLLATE Latin1_general_CI_AI";
- break;
- case "LASTNIK":
- 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";
- break;
- case "OBJEKT":
- comboBoxValue = "SELECT * FROM [cbu_naslovi] WHERE [SO] LIKE '%" + search.Text + "%'";
- break;
- case "PARCELA":
- 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 + "%'";
- break;
- }
- comboBoxValue = comboBoxValue + " ORDER BY [ULICA] ASC, [OBMOCJE] ASC, LEN ([HS]) ASC, [HS] ASC, [HID] ASC";
- SqlCommand cmd = new SqlCommand
- {
- CommandText = comboBoxValue,
- Connection = con
- };
- Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;
- SqlDataAdapter da = new SqlDataAdapter(cmd);
- dtAddress.Clear();
- da.Fill(dtAddress);
- dg_address.ItemsSource = dtAddress.DefaultView;
- Mouse.OverrideCursor = System.Windows.Input.Cursors.Arrow;
- }
Add Comment
Please, Sign In to add comment