Re: OleDbDataReader

Article View: be.comp.programming

Article #5567

Back to be.comp.programming Previous Next

#5567

From: billyke
Date: Sat, 03 May 2003 11:31

32 lines
1951 bytes

> Dim sSQLStatement As String = _
>
> "INSERT INTO tblPersoneel values(pers_Code, pers_Naam, pers_Voornaam,
> pers_Uurloon, pers_Indienstname, pers_Afd_Code)"
>
>
>
> Dim sConnection As New OleDb.OleDbConnection _
>
> ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DB\dbPersoneel.mdb")
>
> Dim objCommand As New OleDb.OleDbCommand(sSQLStatement, sConnection)
>
> Try
>
> sConnection.Open()
>
> 'De opdracht van OleDb.OleDbDataReader kan niet uitgevoerd worden.
>
> 'Er wordt mij steets verteld dat er parameters onbreken.
>
> 'Wat ik ook probeer het lukt niet.
>
> Dim objDataReader As OleDb.OleDbDataReader = objCommand.ExecuteReader()
>
>
>

Christian,

De SQL code van het Insert-statement is invalid, voor de rest zou alles
moeten werken lijkt me.

Technical Details

Message-ID: <b909d4$4p8$1@reader11.wxs.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.ndsoftwarenet.com!aotearoa.belnet.be!news.belnet.be!newsfeed.wxs.nl!textnews.wxs.nl!not-for-mail

References:

<r%Lsa.72726$t_2.6583@afrodite.telenet-ops.be> <b902v3$r8$1@reader11.wxs.nl> <PDMsa.72760$t_2.6810@afrodite.telenet-ops.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,8304d649f693abf3
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2003-05-03 04:34:27 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.ndsoftwarenet.com!aotearoa.belnet.be!news.belnet.be!newsfeed.wxs.nl!textnews.wxs.nl!not-for-mail
From: "billyke" <gert.verstappen@gmx.net>
Newsgroups: be.comp.programming
Subject: Re: OleDbDataReader
Date: Sat, 3 May 2003 13:31:23 +0200
Organization: Planet Internet
Lines: 34
Message-ID: <b909d4$4p8$1@reader11.wxs.nl>
References: <r%Lsa.72726$t_2.6583@afrodite.telenet-ops.be> <b902v3$r8$1@reader11.wxs.nl> <PDMsa.72760$t_2.6810@afrodite.telenet-ops.be>
NNTP-Posting-Host: u212-239-201-175.adsl.pi.be
X-Trace: reader11.wxs.nl 1051961572 4904 212.239.201.175 (3 May 2003 11:32:52 GMT)
X-Complaints-To: abuse@planet.nl
NNTP-Posting-Date: 3 May 2003 11:32:52 GMT
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

Reply to Parent Message