OleDbDataAdapter datAd = new OleDbDataAdapter(); datAd.SelectCommand = new OleDbCommand(); datAd.SelectCommand.Connection = conn; datAd.SelectCommand.CommandText = "SELECT NOVI.GBR FROM NOVI WHERE NOVI.GBR NOT IN (SELECT Avtobusi.Garbr FROM Avtobusi) UNION (select Avtobusi.Garbr from Avtobusi,NOVI where Avtobusi.Sloboden=true)"; datAd.SelectCommand.ExecuteNonQuery();
_dataset.Clear(); datAd.Fill(_dataset, "NOVI");
comboBox1.DataSource = _dataset.Tables["NOVI"]; comboBox1.DisplayMember = "GBR";