Re: ComboBox aan DataGrid linken

Article View: be.comp.programming

Article #4699

Back to be.comp.programming Previous Next

#4699

From: Robrecht Jacques
Date: Mon, 07 Jul 2003 08:07

25 lines
1833 bytes

Christian wrote:
> Bijde tabellen beschikken over het veld HRID, dat in de tabel Acteurs
> de Pimaire- en in de tabel Films de Foreign key is.
> Nu probeer ik de ComboBox aan de DataGrid te linken dmv het veld
> HRID, maar zonder resultaat. Ik bedoel, dat ik graag zou verkrijgen
> dat wanneer ik een naam in de ComboBox kies, enkel de films van deze
> in de DataGrid te zien zijn. Kan iemand me aub wat advies geven?

Iets als:

1. cmbBox is je combobox met alle auteursnamen
2. dbADatabase is je database met je 3 tabellen
3. gridFilms is je DataGrid

private sub cmbBox_Click()
  dim rsFilms as recordset
  set rsFilms = new recordset
  rsFilms.open "SELECT * FROM Films AS f WHERE f.HRID='" & cmbBox & "'", _
               dbADatabase
  me.gridFims.datasource = rsFilms
end sub

Maar dan als VB.NET ipv gewoon VB (ken geen .net).

Robrecht

Technical Details

Message-ID: <3f092aec$0$282$ba620e4c@reader1.news.skynet.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!skynet.be!skynet.be!louie!tlk!not-for-mail

References: <q3YNa.9357$7h.12526@afrodite.telenet-ops.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,d2b63799d46e6847
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2003-07-07 01:11:01 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!skynet.be!skynet.be!louie!tlk!not-for-mail
From: "Robrecht Jacques" <Robrecht.Jacques@advalvas.be>
Newsgroups: be.comp.programming
References: <q3YNa.9357$7h.12526@afrodite.telenet-ops.be>
Subject: Re: ComboBox aan DataGrid linken
Date: Mon, 7 Jul 2003 10:07:19 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Lines: 27
Message-ID: <3f092aec$0$282$ba620e4c@reader1.news.skynet.be>
Organization: -= Belgacom Usenet Service =-
NNTP-Posting-Host: 80.201.19.98
X-Trace: 1057565420 reader1.news.skynet.be 282 80.201.19.98:1024
X-Complaints-To: usenet-abuse@skynet.be

Reply to Parent Message