1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27:
| string sucher_r = ""; string sucher_a = ""; if (checkBox9.Checked) { sucher_r = " AND artdesaufttrags = 'Rechnung'"; } if (checkBox10.Checked) { sucher_a = " AND artdesaufttrags = 'Angebot'"; }
if (checkBox10.Checked && checkBox9.Checked ) { sucher_a = " AND (artdesaufttrags = 'Angebot' OR artdesaufttrags = 'Rechnung')"; sucher_r = ""; } try {
string connstring = String.Format("Server={0};Port={1};User Id={2};Password={3};Database={4};", Form1.tbHost, Form1.tbPort, Form1.tbUser, Form1.tbPass, Form1.tbDataBaseName);
NpgsqlConnection conn = new NpgsqlConnection(connstring);
conn.Open();
string sql = "select * from auftrag where (sqlpos BETWEEN ' 1 'AND ' 100')" + sucher_a + sucher_r +";"; |