Article View: be.comp.programming
Article #1962Re: MS SQL en stored procedures.
From: BadMotherfucker
Date: Tue, 09 Nov 2004 19:40
Date: Tue, 09 Nov 2004 19:40
15 lines
1476 bytes
1476 bytes
> Weet je ook hoe je deze best aanroept vanuit VB.Net?
> Heb jij hier ervaring mee?
Een klein voorbeeldje uit een applicatie (stored procedure geeft geen
records terug)
Dim scanupdate As SqlClient.SqlCommand
scanupdate = New SqlClient.SqlCommand("delete from TsysLastscan where
CFGNAME = " + "'" + section + "'" + " and computername = " + "'" +
mycomputer.Computername + "'", sqlcon)
scanupdate.CommandType = CommandType.Text
scanupdate.ExecuteNonQuery()
Technical Details
Message-ID:
<41911d5a$0$15717$ba620e4c@news.skynet.be>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!fr.ip.ndsoftware.net!skynet.be!newspost001!tjb!not-for-mailReferences:
<7olhd.6280$BS6.491548@phobos.telenet-ops.be> <1099304763.197020@seven.kulnet.kuleuven.ac.be> <8mohd.6452$6_7.511069@phobos.telenet-ops.be>Show Full Headers
Complete Article Headers
X-Google-Thread: fcea4,1682e28c91f69f08 X-Google-Attributes: gidfcea4,public X-Google-Language: DUTCH,ASCII-7-bit Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!fr.ip.ndsoftware.net!skynet.be!newspost001!tjb!not-for-mail From: "BadMotherfucker" <invalid@invalid.com> Newsgroups: be.comp.programming References: <7olhd.6280$BS6.491548@phobos.telenet-ops.be> <1099304763.197020@seven.kulnet.kuleuven.ac.be> <8mohd.6452$6_7.511069@phobos.telenet-ops.be> Subject: Re: MS SQL en stored procedures. Date: Tue, 9 Nov 2004 20:40:57 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original Lines: 17 Message-ID: <41911d5a$0$15717$ba620e4c@news.skynet.be> Organization: -= Belgacom Usenet Service =- NNTP-Posting-Host: 85f90ae8.news.skynet.be X-Trace: 1100029275 news.skynet.be 15717 81.241.210.18:1403 X-Complaints-To: usenet-abuse@skynet.be