procedury przechowywane

Article View: alt.pl.comp.lang.csharp

Article #799

Back to alt.pl.comp.lang.csharp Previous Next

#799

From: rozrabiak
Date: Thu, 01 Apr 2004 15:18

14 lines
1251 bytes

Witam.
W jaki sposob moge uzyc procedure osadzona na serwerze SQL ?

SqlCommand1.CommandType = CommandType.StoredProc;
SqlCommand1.CommandText = "mojaprocedura";
SqlCommand1.ExecuteNonQuery();

Zostaje zwrocony TYLKO jeden rekord, a powinien zwrocic ich 200! Gdy 
uruchamiam ja w innym programie dziala, natomiast pod C# nie za bardzo..
Co mam mu zrobic zeby zadzialalo?

pozdrawiam i dziekuje za pomoc, grzes.

PS: potrzebuje wypelnic nia dataSet-a.

Technical Details

Message-ID: <c4hbta$5dm$1@news.onet.pl>

Path:

mbox-mo1.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!nntp.idg.pl!newsfeed.gazeta.pl!news.onet.pl!not-for-mail

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!nntp.idg.pl!newsfeed.gazeta.pl!news.onet.pl!not-for-mail
From: rozrabiak <br...@maila.pl>
Newsgroups: alt.pl.comp.lang.csharp
Subject: procedury przechowywane
Date: Thu, 01 Apr 2004 17:18:42 +0200
Organization: news.onet.pl
Lines: 14
Sender: 35426783@pro.onet.pl@ez223.neoplus.adsl.tpnet.pl
Message-ID: <c4hbta$5dm$1@news.onet.pl>
NNTP-Posting-Host: ez223.neoplus.adsl.tpnet.pl
Mime-Version: 1.0
X-Trace: news.onet.pl 1080832746 5558 83.30.7.223 (1 Apr 2004 15:19:06 GMT)
X-Complaints-To: ab...@onet.pl
NNTP-Posting-Date: 1 Apr 2004 15:19:06 GMT
User-Agent: Mozilla Thunderbird 0.5a (Windows/20040128)
X-Accept-Language: pl, en-us, en
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit