This message was discovered on ASPFriends.com 'ngfx-sqlclient' list.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.
| hemant mehta |
hi all..
could some one tell me how do i access the stored procedure return value in
ado.net
thanx,
hemant
----- Original Message -----
From: "David L. Penton" <Click here to reveal e-mail address>
To: "ngfx-sqlclient" <Click here to reveal e-mail address>
Sent: Thursday, July 25, 2002 9:26 AM
Subject: [ngfx-sqlclient] RE: Dynamic WHERE Clause
[Original message clipped]
|
|
| |
| |
| William \(Bill\) Vaughn (VIP) |
You need to create a Command object (such as SqlCommand). To this
command, add a Parameter whose direction is set to ReturnValue. Execute
the query and the ReturnValue will appear in the Parameter after rowset
population (once the DataReader is closed).
hth
William (Bill) Vaughn
Author, trainer, mentor
Microsoft Regional Director -- Pacific Northwest
Beta V Corporation
Redmond, Washington USA
www.betav.com
(425) 556-9205 (v/f)
-----Original Message-----
From: hemant mehta [mailto:Click here to reveal e-mail address]
Sent: Thursday, July 25, 2002 4:45 AM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] sp return value
hi all..
could some one tell me how do i access the stored procedure return value
in
ado.net
thanx,
hemant
----- Original Message -----
From: "David L. Penton" <Click here to reveal e-mail address>
To: "ngfx-sqlclient" <Click here to reveal e-mail address>
Sent: Thursday, July 25, 2002 9:26 AM
Subject: [ngfx-sqlclient] RE: Dynamic WHERE Clause
[Original message clipped]
| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
|
|
| |
|
| |
| Russ McClelland |
SWYgeW91ciBTUCBkb2Vzbid0IGhhdmUgYSByZXN1bHRzZXQgcmV0dXJuZWQsIHlvdSBjYW4gdXNl
IHRoZQ0KRXhlY3V0ZVNjYWxhcigpIG1ldGhvZCBvbiB0aGUgU3FsQ29tbWFuZCBvYmplY3Qgd2hp
Y2ggcnVucyB0aGUgU1AgYW5kDQpyZXR1cm5zIHRoZSB2YWx1ZSB0byB5b3UuDQoNCgktLS0tLU9y
aWdpbmFsIE1lc3NhZ2UtLS0tLSANCglGcm9tOiBXaWxsaWFtIChCaWxsKSBWYXVnaG4gDQoJU2Vu
dDogVGh1IDcvMjUvMjAwMiAxMTowMiBBTSANCglUbzogbmdmeC1zcWxjbGllbnQgDQoJQ2M6IA0K
CVN1YmplY3Q6IFtuZ2Z4LXNxbGNsaWVudF0gUkU6IHNwIHJldHVybiB2YWx1ZQ0KCQ0KCQ0KDQoJ
WW91IG5lZWQgdG8gY3JlYXRlIGEgQ29tbWFuZCBvYmplY3QgKHN1Y2ggYXMgU3FsQ29tbWFuZCku
IFRvDQp0aGlzDQoJY29tbWFuZCwgYWRkIGEgUGFyYW1ldGVyIHdob3NlIGRpcmVjdGlvbiBpcyBz
ZXQgdG8gUmV0dXJuVmFsdWUuDQpFeGVjdXRlDQoJdGhlIHF1ZXJ5IGFuZCB0aGUgUmV0dXJuVmFs
dWUgd2lsbCBhcHBlYXIgaW4gdGhlIFBhcmFtZXRlciBhZnRlcg0Kcm93c2V0DQoJcG9wdWxhdGlv
biAob25jZSB0aGUgRGF0YVJlYWRlciBpcyBjbG9zZWQpLg0KCQ0KCWh0aA0KCQ0KCVdpbGxpYW0g
KEJpbGwpIFZhdWdobg0KCUF1dGhvciwgdHJhaW5lciwgbWVudG9yDQoJTWljcm9zb2Z0IFJlZ2lv
bmFsIERpcmVjdG9yIC0tIFBhY2lmaWMgTm9ydGh3ZXN0DQoJQmV0YSBWIENvcnBvcmF0aW9uDQoJ
UmVkbW9uZCwgV2FzaGluZ3RvbiBVU0ENCgl3d3cuYmV0YXYuY29tDQoJKDQyNSkgNTU2LTkyMDUg
KHYvZikNCgkNCgkNCgktLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KCUZyb206IGhlbWFudCBt
ZWh0YSBbIG1haWx0bzpoYm1Ac29mdGhvbWUubmV0XQ0KCVNlbnQ6IFRodXJzZGF5LCBKdWx5IDI1
LCAyMDAyIDQ6NDUgQU0NCglUbzogbmdmeC1zcWxjbGllbnQNCglTdWJqZWN0OiBbbmdmeC1zcWxj
bGllbnRdIHNwIHJldHVybiB2YWx1ZQ0KCQ0KCWhpIGFsbC4uDQoJDQoJY291bGQgc29tZSBvbmUg
dGVsbCBtZSBob3cgZG8gaSBhY2Nlc3MgdGhlIHN0b3JlZCBwcm9jZWR1cmUNCnJldHVybiB2YWx1
ZQ0KCWluDQoJYWRvLm5ldA0KCQ0KCXRoYW54LA0KCWhlbWFudA0KCQ0KCS0tLS0tIE9yaWdpbmFs
IE1lc3NhZ2UgLS0tLS0NCglGcm9tOiAiRGF2aWQgTC4gUGVudG9uIiA8ZGF2aWRAZGF2aWRwZW50
b24uY29tPg0KCVRvOiAibmdmeC1zcWxjbGllbnQiIDxuZ2Z4LXNxbGNsaWVudEBhc3BmcmllbmRz
LmNvbT4NCglTZW50OiBUaHVyc2RheSwgSnVseSAyNSwgMjAwMiA5OjI2IEFNDQoJU3ViamVjdDog
W25nZngtc3FsY2xpZW50XSBSRTogRHluYW1pYyBXSEVSRSBDbGF1c2UNCgkNCgkNCgk+IENvdXBs
ZSBvZiB0aGluZ3MgdG8gdGhpbmsgYWJvdXQ6DQoJPg0KCT4gMSkgQSB2YXJjaGFyIGNhbiBvbmx5
IGJlIDgwMDAgY2hhcmFjdGVycy4gIFNvLCBpZiBAVGhpbmcxIHdhcw0KODAwMA0KCT4gY2hhcmFj
dGVycywgeW91IGFyZSBnb2luZyB0byBnZXQgYSByaWdodCB0cnVuY2F0ZWQgcXVlcnkNCltiZWNh
dXNlDQoJdGhlcmUNCgk+IHdvdWxkIGJlIG5vIHdoZXJlIHRvIHN0b3JlIGl0XS4gIE5vdCB0b28g
Y29vbC4NCgk+DQoJPiAyKSAgU3FsIEluamVjdGlvbi4gIFdoYXQgaWYgQFRoaW5nMSB3YXMgZXF1
YWwgdG86DQoJPg0KCT4gICAgIDA9MTsgREVDTEFSRSBAZCBzeXNuYW1lLEBxIHZhcmNoYXIoMTAw
KTsgU0VMRUNUDQpAZD1kYl9uYW1lKCksDQoJQHE9J1VTRQ0KCT4gbWFzdGVyOyBEUk9QIERBVEFC
QVNFICcrUVVPVEVOQU1FKEBxKTsgRVhFQyhAcSkgLS0NCgk+DQoJPiBhbmQgeW91IGhhcHBlbmVk
IHRvIGJlIHVzaW5nIGFuIGFjY291bnQgdGhhdCBoYWQgdGhlDQpwcml2aWxpZWdlcyB0byBkbw0K
CXRoaXM/DQoJPiBJIGNhbiB3cml0ZSBhIFVOSU9OIEFMTCBxdWVyeSBlYXNpbHkgb24gdG9wIG9m
IHRoaXMuICBPbmx5IGENCm1hdHRlciBvZg0KCXRyaWFsDQoJPiBhbmQgZXJyb3IuDQoJPg0KCT4N
Cgk+IERhdmlkIEwuIFBlbnRvbiwgTWljcm9zb2Z0IE1WUA0KCT4gSkNQZW5uZXkgVGVjaG5pY2Fs
IFNwZWNpYWxpc3QgLyBMZWFkDQoJPiAiTWF0aGVtYXRpY3MgaXMgbXVzaWMgZm9yIHRoZSBtaW5k
LCBhbmQgTXVzaWMgaXMgTWF0aGVtYXRpY3MNCmZvciB0aGUNCgk+IFNvdWwuIC0gSi5TLiBCYWNo
Ig0KCT4gZGF2aWRAZGF2aWRwZW50b24uY29tDQoJPg0KCT4gRG8geW91IGhhdmUgdGhlIFZCU2Ny
aXB0IERvY3Mgb3IgU1FMIEJPTCBpbnN0YWxsZWQ/ICBJZiBub3QsDQp3aHkgbm90Pw0KCT4gVkJT
Y3JpcHQgRG9jczogaHR0cDovL3d3dy5kYXZpZHBlbnRvbi5jb20vdmJzY3JpcHQNCgk+IFNRTCBC
T0w6IGh0dHA6Ly93d3cuZGF2aWRwZW50b24uY29tL3NxbGJvbA0KCT4NCgk+DQoJPiAtLS0tLU9y
aWdpbmFsIE1lc3NhZ2UtLS0tLQ0KCT4gRnJvbTogQWRtaW5pc3RyYXRvciBbIG1haWx0bzpkZXZl
bG9wbWVudEB3ZW1ldG9udGhlLm5ldF0NCgk+IFNlbnQ6IFdlZG5lc2RheSwgSnVseSAyNCwgMjAw
MiA3OjE4IFBNDQoJPiBUbzogbmdmeC1zcWxjbGllbnQNCgk+IFN1YmplY3Q6IFtuZ2Z4LXNxbGNs
aWVudF0gUkU6IER5bmFtaWMgV0hFUkUgQ2xhdXNlDQoJPg0KCT4NCgk+IEhlbGxvIEFsbCwNCgk+
DQoJPiAgIEFmdGVyIGEgbG90IG9mIHJlc2VhcmNoIGFuZCB0cmlhbCBhbmQgZXJyb3IsIEkgZm91
bmQgdGhlDQpzb2x1dGlvbjoNCgk+DQoJPiBDUkVBVEUgUFJPQ0VEVVJFIHNwX0dldEFzaWFuTWF0
Y2hlcw0KCT4gQFRoaW5nMSBhcyBWYXJDaGFyKDgwMDApDQoJPg0KCT4gQVMNCgk+IERlY2xhcmUg
QFF1ZXJ5IFZhcmNoYXIoODAwMCkNCgk+DQoJPiBTZWxlY3QgQFF1ZXJ5ID0gJ1NFTEVDVA0KdGJs
X0N1c3RvbWVySW5mby5DdXN0b21lckZpcnN0TmFtZSwNCgk+IHRibF9DdXN0b21lckluZm8uQ2l0
eSwgdGJsX1N0YXRlLlN0YXRlLA0KdGJsX0N1c3RvbWVySW5mby5Qcm92aW5jZSwNCgk+IHRibF9D
b3VudHJpZXMuQ291bnRyeSwNCgk+ICAgICAgICAgICAgICAgICAgICAgICB0YmxfQ3VzdG9tZXJJ
bmZvLkFwcHJvdmVkLA0KCXRibF9DdXN0b21lckluZm8uTWFpbkltYWdlLA0KCT4gdGJsX0N1c3Rv
bWVySW5mby5Vc2VyTGV2ZWwsIHRibF9DdXN0b21lckFuc3dlcnMuQmlydGhEYXRlLA0KCT4gICAg
ICAgICAgICAgICAgICAgICAgIHRibF9DdXN0b21lckluZm8uQ3VzdG9tZXJJRCwNClJPVU5EKERB
VEVESUZGKGRkLA0KCT4gdGJsX0N1c3RvbWVyQW5zd2Vycy5CaXJ0aERhdGUsIEdFVERBVEUoKSkg
LyAzNjUsIDApIEFTIEFnZQ0KCT4gRlJPTSAgICAgICAgIHRibF9DdXN0b21lckluZm8gTEVGVCBP
VVRFUiBKT0lODQoJPiAgICAgICAgICAgICAgICAgICAgICAgdGJsX0N1c3RvbWVyQW5zd2VycyBP
Tg0KCXRibF9DdXN0b21lckluZm8uQ3VzdG9tZXJJRCA9DQoJPiB0YmxfQ3VzdG9tZXJBbnN3ZXJz
LkN1c3RvbWVySUQgTEVGVCBPVVRFUiBKT0lODQoJPiAgICAgICAgICAgICAgICAgICAgICAgdGJs
X0NvdW50cmllcyBPTg0KdGJsX0N1c3RvbWVySW5mby5Db3VudHJ5ID0NCgk+IHRibF9Db3VudHJp
ZXMuQ291bnRyeUlEIExFRlQgT1VURVIgSk9JTg0KCT4gICAgICAgICAgICAgICAgICAgICAgIHRi
bF9TdGF0ZSBPTiB0YmxfQ3VzdG9tZXJJbmZvLlN0YXRlID0NCgk+IHRibF9TdGF0ZS5TdGF0ZUlE
DQoJPiBXSEVSRSB0YmxfQ3VzdG9tZXJJbmZvLkFwcHJvdmVkID0gMSBBTkQgJyArIEBUaGluZzEN
Cgk+ICsgJ09yZGVyIEJ5IHRibF9DdXN0b21lckFuc3dlcnMuQmlydGhEYXRlIERFU0MnDQoJPg0K
CT4gRXhlYyhAUXVlcnkpDQoJPiBHTw0KCT4NCgk+IFRoaXMgZ2l2ZXMgbWUgdGhlIGFiaWxpdHkg
dG8gcGFzcyBpbiBhbnkgV0hFUkUgY2xhdXNlIEkgd2lzaC4NCkkgaG9wZQ0KCXRoaXMNCgk+IGhl
bHBzIG90aGVycy4NCgk+DQoJPiBKb2huDQoJPg0KCT4gLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0t
LS0NCgk+IEZyb206IEphbWVzIEF2ZXJ5IFsgbWFpbHRvOmphdmVyeUBkZWx1eGVlbmcuY29tXQ0K
CT4gU2VudDogV2VkbmVzZGF5LCBKdWx5IDI0LCAyMDAyIDEyOjE1IFBNDQoJPiBUbzogbmdmeC1z
cWxjbGllbnQNCgk+IFN1YmplY3Q6IFtuZ2Z4LXNxbGNsaWVudF0gUkU6IER5bmFtaWMgV0hFUkUg
Q2xhdXNlDQoJPg0KCT4NCgk+IEluIFN0b3JlZCBQcm9jZWR1cmVzIHlvdSBkbyBub3QgdXNlIGFz
IGFmdGVyIHRoZSB2YXJpYWJsZS4gIEl0DQpzaG91bGQNCgliZQ0KCT4gbGlrZSB0aGlzOiAgQFRo
aW5nMSBWYXJDaGFyKDIwMCkNCgk+DQoJPg0KCT4NCgk+IC0tLS0tT3JpZ2luYWwgTWVzc2FnZS0t
LS0tDQoJPiBGcm9tOiBBZG1pbmlzdHJhdG9yIFsgbWFpbHRvOmRldmVsb3BtZW50QHdlbWV0b250
aGUubmV0XQ0KCT4gU2VudDogV2VkbmVzZGF5LCBKdWx5IDI0LCAyMDAyIDg6NTMgQU0NCgk+IFRv
OiBuZ2Z4LXNxbGNsaWVudA0KCT4gU3ViamVjdDogW25nZngtc3FsY2xpZW50XSBEeW5hbWljIFdI
RVJFIENsYXVzZQ0KCT4NCgk+DQoJPiBIZWxsbyBBbGwsDQoJPg0KCT4gICBJIGFtIHRyeWluZyB0
byBkZXZlbG9wIGEgc3RvcmVkIHByb2NlZHVyZSB0aGF0IGhhcyBhIGR5bmFtaWMNCldIRVJFDQoJ
PiBjbGF1c2UuICBIZXJlIGlzIHdoYXQgSSBoYXZlIGN1cnJlbnRseSwgYnV0IGl0IGlzbid0IHdv
cmtpbmcuDQpUaGUNCgk+IEBUaGluZzEgdmFyaWFibGUgaXMgYSBXSEVSRSBTdHJpbmcgdGhhdCBJ
IGRldmVsb3Agb24gdGhlIGZseQ0Kb24gdGhlDQoJPiB3ZWJzaXRlLiAgVGhlIGVycm9yIEkgYW0g
Z2V0dGluZyBpcyB0aGF0IHRoZSBpcyBhIHByb2JsZW0gbmVhcg0KdGhlDQoJJ2FzJw0KCT4gYnkg
QFRoaW5nMQ0KCT4NCgk+IENSRUFURSBQUk9DRURVUkUgc3BfR2V0QXNpYW5NYXRjaGVzDQoJPiBA
VGhpbmcxIGFzIFZhckNoYXIoMjAwMCkNCgk+DQoJPiBBUw0KCT4gRGVjbGFyZSBAU3R1ZmYyIFZh
ckNoYXIoMjAwMCkNCgk+DQoJPiBTZXQgQFN0dWZmMiA9IEBUaGluZzENCgk+DQoJPiBTRUxFQ1Qg
dGJsX0N1c3RvbWVySW5mby5DdXN0b21lcklELCAoUk9VTkQoREFURURJRkYoZGQsDQoJPiB0Ymxf
Q3VzdG9tZXJBbnN3ZXJzLkJpcnRoRGF0ZSwgR0VUREFURSgpKSAvIDM2NSwgMCkgYXMgQWdlLA0K
CT4gdGJsX0N1c3RvbWVySW5mby5DdXN0b21lckZpcnN0TmFtZSwNCnRibF9DdXN0b21lckluZm8u
TWFpbkltYWdlLA0KCT4gdGJsX0N1c3RvbWVySW5mby5TdWJzY3JpcHRpb25UeXBlSUQNCgk+IEZS
T00gdGJsX0N1c3RvbWVySW5mbyBMRUZUIE9VVEVSIEpPSU4gdGJsX1N0YXRlIE9ODQoJPiB0Ymxf
Q3VzdG9tZXJJbmZvLlN0YXRlID0gdGJsX1N0YXRlLlN0YXRlSUQgTEVGVCBPVVRFUiBKT0lODQoJ
dGJsX0NvdW50cmllcw0KCT4gT04gdGJsX0N1c3RvbWVySW5mby5Db3VudHJ5ID0gdGJsX0NvdW50
cmllcy5Db3VudHJ5SUQgTEVGVA0KT1VURVIgSk9JTg0KCT4gdGJsX0N1c3RvbWVyU3Bva2VuTGFu
Z3VhZ2VBbnN3ZXJzIFJJR0hUIE9VVEVSIEpPSU4NCnRibF9DdXN0b21lckFuc3dlcnMNCgk+IE9O
IHRibF9DdXN0b21lclNwb2tlbkxhbmd1YWdlQW5zd2Vycy5DdXN0b21lckFuc3dlcklEID0NCgk+
IHRibF9DdXN0b21lckFuc3dlcnMudGJsX0N1c3RvbWVyQW5zd2Vyc0lEIExFRlQgT1VURVIgSk9J
Tg0KCT4gdGJsX0N1c3RvbWVyTG9va2luZ0ZvckNob2ljZXMgT04NCgk+IHRibF9DdXN0b21lckFu
c3dlcnMudGJsX0N1c3RvbWVyQW5zd2Vyc0lEID0NCgk+IHRibF9DdXN0b21lckxvb2tpbmdGb3JD
aG9pY2VzLkN1c3RvbWVyQW5zd2Vyc0lEIE9ODQoJPiB0YmxfQ3VzdG9tZXJJbmZvLkN1c3RvbWVy
SUQgPSB0YmxfQ3VzdG9tZXJBbnN3ZXJzLkN1c3RvbWVySUQNCgk+IFdIRVJFIHRibF9DdXN0b21l
ckluZm8uQXBwcm92ZWQgPSAnMScgQU5EIEBTdHVmZjINCgk+IE9yZGVyIEJ5IHRibF9DdXN0b21l
ckluZm8uU3ViU2NyaXB0aW9uVHlwZUlELCBCaXJ0aERhdGUgREVTQw0KCT4NCgk+DQoJPg0KCT4g
QW55IGhlbHAgd291bGQgYmUgZ3JlYXRseSBhcHByZWNpYXRlZC4NCgk+DQoJPiBUaGFuayB5b3Us
DQoJPg0KCT4gSm9obg0KCT4NCgk+DQoJPiB8IFtuZ2Z4LXNxbGNsaWVudF0gbWVtYmVyIGhibUBz
b2Z0aG9tZS5uZXQgPSBZT1VSIElEDQoJPiB8IGh0dHA6Ly93d3cuYXNwZnJpZW5kcy5jb20vYXNw
ZnJpZW5kcy9uZ2Z4LXNxbGNsaWVudC5hc3AgPQ0KSk9JTi9RVUlUDQoJPg0KCQ0KCQ0KCQ0KCXwg
W25nZngtc3FsY2xpZW50XSBtZW1iZXIgYmlsbHZhQG53bGluay5jb20gPSBZT1VSIElEDQoJfCBo
dHRwOi8vd3d3LmFzcGZyaWVuZHMuY29tL2FzcGZyaWVuZHMvbmdmeC1zcWxjbGllbnQuYXNwID0N
CkpPSU4vUVVJVA0KCQ0KCQ0KCQ0KCXwgW25nZngtc3FsY2xpZW50XSBtZW1iZXIgcnVzcy5tY2Ns
ZWxsYW5kQHNtYXJ0b2JqeC5jb20gPSBZT1VSDQpJRA0KCXwgaHR0cDovL3d3dy5hc3BmcmllbmRz
LmNvbS9hc3BmcmllbmRzL25nZngtc3FsY2xpZW50LmFzcCA9DQpKT0lOL1FVSVQNCgkNCg0K
|
|
| |
|
| |
| Jon Ceanfaglione |
command.Parameters.Add(
new SqlParameter( "ReturnValue",
SqlDbType.Int,
/* int size */ 4,
ParameterDirection.ReturnValue,
/* bool isNullable */ false,
/* byte precision */ 0,
/* byte scale */ 0,
/* string srcColumn */ string.Empty,
DataRowVersion.Default,
/* value */ null
)
);
-----Original Message-----
From: hemant mehta [mailto:Click here to reveal e-mail address]
Sent: Thursday, July 25, 2002 7:45 AM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] sp return value
hi all..
could some one tell me how do i access the stored procedure return value in
ado.net
thanx,
hemant
----- Original Message -----
From: "David L. Penton" <Click here to reveal e-mail address>
To: "ngfx-sqlclient" <Click here to reveal e-mail address>
Sent: Thursday, July 25, 2002 9:26 AM
Subject: [ngfx-sqlclient] RE: Dynamic WHERE Clause
[Original message clipped]
| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
__________________________________________________
The information contained in this communication is intended only for the use
of the recipient named above, and may be legally privileged, confidential
and exempt from disclosure under applicable law. If the reader of this
communication is not the intended recipient, you are hereby notified that
any dissemination, distribution, or copying of this communication, or any of
its contents, is strictly prohibited. If you have received this
communication in error, please re-send this communication to the sender and
delete the original communication and any copy of it from your computer
system. Thank you.
|
|
| |
|
| |
| William \(Bill\) Vaughn (VIP) |
Have you tried this to return the ReturnValue from a stored procedure?
ExecuteScalar returns the first column of the first row as an object, not the
ReturnStatus.
William (Bill) Vaughn
Author, trainer, mentor
Microsoft Regional Director -- Pacific Northwest
Beta V Corporation
Redmond, Washington USA
www.betav.com <outbind://15/www.betav.com>
(425) 556-9205 (v/f)
-----Original Message-----
From: Russ McClelland [mailto:Click here to reveal e-mail address]
Sent: Thursday, July 25, 2002 9:26 AM
To: ngfx-sqlclient
Subject: RE: [ngfx-sqlclient] RE: sp return value
If your SP doesn't have a resultset returned, you can use the ExecuteScalar()
method on the SqlCommand object which runs the SP and returns the value to you.
-----Original Message-----
From: William (Bill) Vaughn
Sent: Thu 7/25/2002 11:02 AM
To: ngfx-sqlclient
Cc:
Subject: [ngfx-sqlclient] RE: sp return value
You need to create a Command object (such as SqlCommand). To this
command, add a Parameter whose direction is set to ReturnValue. Execute
the query and the ReturnValue will appear in the Parameter after rowset
population (once the DataReader is closed).
hth
William (Bill) Vaughn
Author, trainer, mentor
Microsoft Regional Director -- Pacific Northwest
Beta V Corporation
Redmond, Washington USA
www.betav.com
(425) 556-9205 (v/f)
-----Original Message-----
From: hemant mehta [mailto:Click here to reveal e-mail address]
Sent: Thursday, July 25, 2002 4:45 AM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] sp return value
hi all..
could some one tell me how do i access the stored procedure return value
in
ado.net
thanx,
hemant
----- Original Message -----
From: "David L. Penton" <Click here to reveal e-mail address>
To: "ngfx-sqlclient" <Click here to reveal e-mail address>
Sent: Thursday, July 25, 2002 9:26 AM
Subject: [ngfx-sqlclient] RE: Dynamic WHERE Clause
[Original message clipped]
| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
|
|
| |
|
| |
| Russ McClelland |
UmlnaHQsIGlmIGFsbCB5b3VyIGFmdGVyIGlzIHRoZSB2YWx1ZSByZXR1cm5lZCBmcm9tIHlvdXIg
U1Agc3VjaCBhczoNCiANCiAgICBSRVRVUk4gQEBJREVOVElUWQ0KIA0KVGhlIEV4ZWN1dGVTY2Fs
YXIoKSBpcyB0aGUgZWFzaWVzdCBtZWNoYW5pc20gdG8gdXNlLiAgWW91IGRvbid0IGhhdmUgdG8N
CmNyZWF0ZSBleHRyYSBwYXJhbWV0ZXJzIG9yIGFjY2VzcyB0aGVtIGFmdGVyIHRoZSBjYWxsLiAg
RXhlY3V0ZVNjYWxhcigpDQp3aWxsIHByb3ZpZGUgdGhlIHZhbHVlIGZvciB5b3UgYW5kIHlvdSBz
aW1wbHkgY2FzdCBpdCBpbnRvIHdoYXQgeW91DQpleHBlY3QgKGRlY2ltYWwsIGludCwgZXRjLikN
Cg0KCS0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tIA0KCUZyb206IFdpbGxpYW0gKEJpbGwpIFZh
dWdobiANCglTZW50OiBUaHUgNy8yNS8yMDAyIDI6MDUgUE0gDQoJVG86IG5nZngtc3FsY2xpZW50
IA0KCUNjOiANCglTdWJqZWN0OiBbbmdmeC1zcWxjbGllbnRdIFJFOiBzcCByZXR1cm4gdmFsdWUN
CgkNCgkNCg0KCUhhdmUgeW91IHRyaWVkIHRoaXMgdG8gcmV0dXJuIHRoZSBSZXR1cm5WYWx1ZSBm
cm9tIGEgc3RvcmVkDQpwcm9jZWR1cmU/IA0KDQoJRXhlY3V0ZVNjYWxhciByZXR1cm5zIHRoZSBm
aXJzdCBjb2x1bW4gb2YgdGhlIGZpcnN0IHJvdyBhcyBhbg0Kb2JqZWN0LCBub3QgdGhlIFJldHVy
blN0YXR1cy4NCg0KCSANCg0KCVdpbGxpYW0gKEJpbGwpIFZhdWdobg0KCUF1dGhvciwgdHJhaW5l
ciwgbWVudG9yDQoJTWljcm9zb2Z0IFJlZ2lvbmFsIERpcmVjdG9yIC0tIFBhY2lmaWMgTm9ydGh3
ZXN0DQoJQmV0YSBWIENvcnBvcmF0aW9uDQoJUmVkbW9uZCwgV2FzaGluZ3RvbiBVU0ENCgl3d3cu
YmV0YXYuY29tIDxvdXRiaW5kOi8vMTUvd3d3LmJldGF2LmNvbT4gDQoJKDQyNSkgNTU2LTkyMDUg
KHYvZikNCg0KCSANCg0KCS0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQoJRnJvbTogUnVzcyBN
Y0NsZWxsYW5kIFttYWlsdG86cnVzcy5tY2NsZWxsYW5kQHNtYXJ0T2JqeC5jb21dIA0KCVNlbnQ6
IFRodXJzZGF5LCBKdWx5IDI1LCAyMDAyIDk6MjYgQU0NCglUbzogbmdmeC1zcWxjbGllbnQNCglT
dWJqZWN0OiBSRTogW25nZngtc3FsY2xpZW50XSBSRTogc3AgcmV0dXJuIHZhbHVlDQoNCgkgDQoN
CglJZiB5b3VyIFNQIGRvZXNuJ3QgaGF2ZSBhIHJlc3VsdHNldCByZXR1cm5lZCwgeW91IGNhbiB1
c2UgdGhlDQpFeGVjdXRlU2NhbGFyKCkgbWV0aG9kIG9uIHRoZSBTcWxDb21tYW5kIG9iamVjdCB3
aGljaCBydW5zIHRoZSBTUCBhbmQNCnJldHVybnMgdGhlIHZhbHVlIHRvIHlvdS4NCg0KCQktLS0t
LU9yaWdpbmFsIE1lc3NhZ2UtLS0tLSANCgkJRnJvbTogV2lsbGlhbSAoQmlsbCkgVmF1Z2huIA0K
CQlTZW50OiBUaHUgNy8yNS8yMDAyIDExOjAyIEFNIA0KCQlUbzogbmdmeC1zcWxjbGllbnQgDQoJ
CUNjOiANCgkJU3ViamVjdDogW25nZngtc3FsY2xpZW50XSBSRTogc3AgcmV0dXJuIHZhbHVlDQoN
CgkJWW91IG5lZWQgdG8gY3JlYXRlIGEgQ29tbWFuZCBvYmplY3QgKHN1Y2ggYXMNClNxbENvbW1h
bmQpLiBUbyB0aGlzDQoJCWNvbW1hbmQsIGFkZCBhIFBhcmFtZXRlciB3aG9zZSBkaXJlY3Rpb24g
aXMgc2V0IHRvDQpSZXR1cm5WYWx1ZS4gRXhlY3V0ZQ0KCQl0aGUgcXVlcnkgYW5kIHRoZSBSZXR1
cm5WYWx1ZSB3aWxsIGFwcGVhciBpbiB0aGUNClBhcmFtZXRlciBhZnRlciByb3dzZXQNCgkJcG9w
dWxhdGlvbiAob25jZSB0aGUgRGF0YVJlYWRlciBpcyBjbG9zZWQpLg0KCQkNCgkJaHRoDQoJCQ0K
CQlXaWxsaWFtIChCaWxsKSBWYXVnaG4NCgkJQXV0aG9yLCB0cmFpbmVyLCBtZW50b3INCgkJTWlj
cm9zb2Z0IFJlZ2lvbmFsIERpcmVjdG9yIC0tIFBhY2lmaWMgTm9ydGh3ZXN0DQoJCUJldGEgViBD
b3Jwb3JhdGlvbg0KCQlSZWRtb25kLCBXYXNoaW5ndG9uIFVTQQ0KCQl3d3cuYmV0YXYuY29tDQoJ
CSg0MjUpIDU1Ni05MjA1ICh2L2YpDQoJCQ0KCQkNCgkJLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0t
LS0NCgkJRnJvbTogaGVtYW50IG1laHRhIFsgbWFpbHRvOmhibUBzb2Z0aG9tZS5uZXRdDQoJCVNl
bnQ6IFRodXJzZGF5LCBKdWx5IDI1LCAyMDAyIDQ6NDUgQU0NCgkJVG86IG5nZngtc3FsY2xpZW50
DQoJCVN1YmplY3Q6IFtuZ2Z4LXNxbGNsaWVudF0gc3AgcmV0dXJuIHZhbHVlDQoJCQ0KCQloaSBh
bGwuLg0KCQkNCgkJY291bGQgc29tZSBvbmUgdGVsbCBtZSBob3cgZG8gaSBhY2Nlc3MgdGhlIHN0
b3JlZA0KcHJvY2VkdXJlIHJldHVybiB2YWx1ZQ0KCQlpbg0KCQlhZG8ubmV0DQoJCQ0KCQl0aGFu
eCwNCgkJaGVtYW50DQoJCQ0KCQktLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0tDQoJCUZyb206
ICJEYXZpZCBMLiBQZW50b24iIDxkYXZpZEBkYXZpZHBlbnRvbi5jb20+DQoJCVRvOiAibmdmeC1z
cWxjbGllbnQiIDxuZ2Z4LXNxbGNsaWVudEBhc3BmcmllbmRzLmNvbT4NCgkJU2VudDogVGh1cnNk
YXksIEp1bHkgMjUsIDIwMDIgOToyNiBBTQ0KCQlTdWJqZWN0OiBbbmdmeC1zcWxjbGllbnRdIFJF
OiBEeW5hbWljIFdIRVJFIENsYXVzZQ0KCQkNCgkJDQoJCT4gQ291cGxlIG9mIHRoaW5ncyB0byB0
aGluayBhYm91dDoNCgkJPg0KCQk+IDEpIEEgdmFyY2hhciBjYW4gb25seSBiZSA4MDAwIGNoYXJh
Y3RlcnMuICBTbywgaWYNCkBUaGluZzEgd2FzIDgwMDANCgkJPiBjaGFyYWN0ZXJzLCB5b3UgYXJl
IGdvaW5nIHRvIGdldCBhIHJpZ2h0IHRydW5jYXRlZA0KcXVlcnkgW2JlY2F1c2UNCgkJdGhlcmUN
CgkJPiB3b3VsZCBiZSBubyB3aGVyZSB0byBzdG9yZSBpdF0uICBOb3QgdG9vIGNvb2wuDQoJCT4N
CgkJPiAyKSAgU3FsIEluamVjdGlvbi4gIFdoYXQgaWYgQFRoaW5nMSB3YXMgZXF1YWwgdG86DQoJ
CT4NCgkJPiAgICAgMD0xOyBERUNMQVJFIEBkIHN5c25hbWUsQHEgdmFyY2hhcigxMDApOyBTRUxF
Q1QNCkBkPWRiX25hbWUoKSwNCgkJQHE9J1VTRQ0KCQk+IG1hc3RlcjsgRFJPUCBEQVRBQkFTRSAn
K1FVT1RFTkFNRShAcSk7IEVYRUMoQHEpIC0tDQoJCT4NCgkJPiBhbmQgeW91IGhhcHBlbmVkIHRv
IGJlIHVzaW5nIGFuIGFjY291bnQgdGhhdCBoYWQgdGhlDQpwcml2aWxpZWdlcyB0byBkbw0KCQl0
aGlzPw0KCQk+IEkgY2FuIHdyaXRlIGEgVU5JT04gQUxMIHF1ZXJ5IGVhc2lseSBvbiB0b3Agb2Yg
dGhpcy4NCk9ubHkgYSBtYXR0ZXIgb2YNCgkJdHJpYWwNCgkJPiBhbmQgZXJyb3IuDQoJCT4NCgkJ
Pg0KCQk+IERhdmlkIEwuIFBlbnRvbiwgTWljcm9zb2Z0IE1WUA0KCQk+IEpDUGVubmV5IFRlY2hu
aWNhbCBTcGVjaWFsaXN0IC8gTGVhZA0KCQk+ICJNYXRoZW1hdGljcyBpcyBtdXNpYyBmb3IgdGhl
IG1pbmQsIGFuZCBNdXNpYyBpcw0KTWF0aGVtYXRpY3MgZm9yIHRoZQ0KCQk+IFNvdWwuIC0gSi5T
LiBCYWNoIg0KCQk+IGRhdmlkQGRhdmlkcGVudG9uLmNvbQ0KCQk+DQoJCT4gRG8geW91IGhhdmUg
dGhlIFZCU2NyaXB0IERvY3Mgb3IgU1FMIEJPTCBpbnN0YWxsZWQ/DQpJZiBub3QsIHdoeSBub3Q/
DQoJCT4gVkJTY3JpcHQgRG9jczogaHR0cDovL3d3dy5kYXZpZHBlbnRvbi5jb20vdmJzY3JpcHQN
CgkJPiBTUUwgQk9MOiBodHRwOi8vd3d3LmRhdmlkcGVudG9uLmNvbS9zcWxib2wNCgkJPg0KCQk+
DQoJCT4gLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCgkJPiBGcm9tOiBBZG1pbmlzdHJhdG9y
IFsNCm1haWx0bzpkZXZlbG9wbWVudEB3ZW1ldG9udGhlLm5ldF0NCgkJPiBTZW50OiBXZWRuZXNk
YXksIEp1bHkgMjQsIDIwMDIgNzoxOCBQTQ0KCQk+IFRvOiBuZ2Z4LXNxbGNsaWVudA0KCQk+IFN1
YmplY3Q6IFtuZ2Z4LXNxbGNsaWVudF0gUkU6IER5bmFtaWMgV0hFUkUgQ2xhdXNlDQoJCT4NCgkJ
Pg0KCQk+IEhlbGxvIEFsbCwNCgkJPg0KCQk+ICAgQWZ0ZXIgYSBsb3Qgb2YgcmVzZWFyY2ggYW5k
IHRyaWFsIGFuZCBlcnJvciwgSSBmb3VuZA0KdGhlIHNvbHV0aW9uOg0KCQk+DQoJCT4gQ1JFQVRF
IFBST0NFRFVSRSBzcF9HZXRBc2lhbk1hdGNoZXMNCgkJPiBAVGhpbmcxIGFzIFZhckNoYXIoODAw
MCkNCgkJPg0KCQk+IEFTDQoJCT4gRGVjbGFyZSBAUXVlcnkgVmFyY2hhcig4MDAwKQ0KCQk+DQoJ
CT4gU2VsZWN0IEBRdWVyeSA9ICdTRUxFQ1QNCnRibF9DdXN0b21lckluZm8uQ3VzdG9tZXJGaXJz
dE5hbWUsDQoJCT4gdGJsX0N1c3RvbWVySW5mby5DaXR5LCB0YmxfU3RhdGUuU3RhdGUsDQp0Ymxf
Q3VzdG9tZXJJbmZvLlByb3ZpbmNlLA0KCQk+IHRibF9Db3VudHJpZXMuQ291bnRyeSwNCgkJPiAg
ICAgICAgICAgICAgICAgICAgICAgdGJsX0N1c3RvbWVySW5mby5BcHByb3ZlZCwNCgkJdGJsX0N1
c3RvbWVySW5mby5NYWluSW1hZ2UsDQoJCT4gdGJsX0N1c3RvbWVySW5mby5Vc2VyTGV2ZWwsDQp0
YmxfQ3VzdG9tZXJBbnN3ZXJzLkJpcnRoRGF0ZSwNCgkJPiAgICAgICAgICAgICAgICAgICAgICAg
dGJsX0N1c3RvbWVySW5mby5DdXN0b21lcklELA0KUk9VTkQoREFURURJRkYoZGQsDQoJCT4gdGJs
X0N1c3RvbWVyQW5zd2Vycy5CaXJ0aERhdGUsIEdFVERBVEUoKSkgLyAzNjUsIDApIEFTDQpBZ2UN
CgkJPiBGUk9NICAgICAgICAgdGJsX0N1c3RvbWVySW5mbyBMRUZUIE9VVEVSIEpPSU4NCgkJPiAg
ICAgICAgICAgICAgICAgICAgICAgdGJsX0N1c3RvbWVyQW5zd2VycyBPTg0KCQl0YmxfQ3VzdG9t
ZXJJbmZvLkN1c3RvbWVySUQgPQ0KCQk+IHRibF9DdXN0b21lckFuc3dlcnMuQ3VzdG9tZXJJRCBM
RUZUIE9VVEVSIEpPSU4NCgkJPiAgICAgICAgICAgICAgICAgICAgICAgdGJsX0NvdW50cmllcyBP
Tg0KdGJsX0N1c3RvbWVySW5mby5Db3VudHJ5ID0NCgkJPiB0YmxfQ291bnRyaWVzLkNvdW50cnlJ
RCBMRUZUIE9VVEVSIEpPSU4NCgkJPiAgICAgICAgICAgICAgICAgICAgICAgdGJsX1N0YXRlIE9O
DQp0YmxfQ3VzdG9tZXJJbmZvLlN0YXRlID0NCgkJPiB0YmxfU3RhdGUuU3RhdGVJRA0KCQk+IFdI
RVJFIHRibF9DdXN0b21lckluZm8uQXBwcm92ZWQgPSAxIEFORCAnICsgQFRoaW5nMQ0KCQk+ICsg
J09yZGVyIEJ5IHRibF9DdXN0b21lckFuc3dlcnMuQmlydGhEYXRlIERFU0MnDQoJCT4NCgkJPiBF
eGVjKEBRdWVyeSkNCgkJPiBHTw0KCQk+DQoJCT4gVGhpcyBnaXZlcyBtZSB0aGUgYWJpbGl0eSB0
byBwYXNzIGluIGFueSBXSEVSRSBjbGF1c2UNCkkgd2lzaC4gIEkgaG9wZQ0KCQl0aGlzDQoJCT4g
aGVscHMgb3RoZXJzLg0KCQk+DQoJCT4gSm9obg0KCQk+DQoJCT4gLS0tLS1PcmlnaW5hbCBNZXNz
YWdlLS0tLS0NCgkJPiBGcm9tOiBKYW1lcyBBdmVyeSBbIG1haWx0bzpqYXZlcnlAZGVsdXhlZW5n
LmNvbV0NCgkJPiBTZW50OiBXZWRuZXNkYXksIEp1bHkgMjQsIDIwMDIgMTI6MTUgUE0NCgkJPiBU
bzogbmdmeC1zcWxjbGllbnQNCgkJPiBTdWJqZWN0OiBbbmdmeC1zcWxjbGllbnRdIFJFOiBEeW5h
bWljIFdIRVJFIENsYXVzZQ0KCQk+DQoJCT4NCgkJPiBJbiBTdG9yZWQgUHJvY2VkdXJlcyB5b3Ug
ZG8gbm90IHVzZSBhcyBhZnRlciB0aGUNCnZhcmlhYmxlLiAgSXQgc2hvdWxkDQoJCWJlDQoJCT4g
bGlrZSB0aGlzOiAgQFRoaW5nMSBWYXJDaGFyKDIwMCkNCgkJPg0KCQk+DQoJCT4NCgkJPiAtLS0t
LU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KCQk+IEZyb206IEFkbWluaXN0cmF0b3IgWw0KbWFpbHRv
OmRldmVsb3BtZW50QHdlbWV0b250aGUubmV0XQ0KCQk+IFNlbnQ6IFdlZG5lc2RheSwgSnVseSAy
NCwgMjAwMiA4OjUzIEFNDQoJCT4gVG86IG5nZngtc3FsY2xpZW50DQoJCT4gU3ViamVjdDogW25n
Zngtc3FsY2xpZW50XSBEeW5hbWljIFdIRVJFIENsYXVzZQ0KCQk+DQoJCT4NCgkJPiBIZWxsbyBB
bGwsDQoJCT4NCgkJPiAgIEkgYW0gdHJ5aW5nIHRvIGRldmVsb3AgYSBzdG9yZWQgcHJvY2VkdXJl
IHRoYXQgaGFzIGENCmR5bmFtaWMgV0hFUkUNCgkJPiBjbGF1c2UuICBIZXJlIGlzIHdoYXQgSSBo
YXZlIGN1cnJlbnRseSwgYnV0IGl0IGlzbid0DQp3b3JraW5nLiAgVGhlDQoJCT4gQFRoaW5nMSB2
YXJpYWJsZSBpcyBhIFdIRVJFIFN0cmluZyB0aGF0IEkgZGV2ZWxvcCBvbg0KdGhlIGZseSBvbiB0
aGUNCgkJPiB3ZWJzaXRlLiAgVGhlIGVycm9yIEkgYW0gZ2V0dGluZyBpcyB0aGF0IHRoZSBpcyBh
DQpwcm9ibGVtIG5lYXIgdGhlDQoJCSdhcycNCgkJPiBieSBAVGhpbmcxDQoJCT4NCgkJPiBDUkVB
VEUgUFJPQ0VEVVJFIHNwX0dldEFzaWFuTWF0Y2hlcw0KCQk+IEBUaGluZzEgYXMgVmFyQ2hhcigy
MDAwKQ0KCQk+DQoJCT4gQVMNCgkJPiBEZWNsYXJlIEBTdHVmZjIgVmFyQ2hhcigyMDAwKQ0KCQk+
DQoJCT4gU2V0IEBTdHVmZjIgPSBAVGhpbmcxDQoJCT4NCgkJPiBTRUxFQ1QgdGJsX0N1c3RvbWVy
SW5mby5DdXN0b21lcklELA0KKFJPVU5EKERBVEVESUZGKGRkLA0KCQk+IHRibF9DdXN0b21lckFu
c3dlcnMuQmlydGhEYXRlLCBHRVREQVRFKCkpIC8gMzY1LCAwKSBhcw0KQWdlLA0KCQk+IHRibF9D
dXN0b21lckluZm8uQ3VzdG9tZXJGaXJzdE5hbWUsDQp0YmxfQ3VzdG9tZXJJbmZvLk1haW5JbWFn
ZSwNCgkJPiB0YmxfQ3VzdG9tZXJJbmZvLlN1YnNjcmlwdGlvblR5cGVJRA0KCQk+IEZST00gdGJs
X0N1c3RvbWVySW5mbyBMRUZUIE9VVEVSIEpPSU4gdGJsX1N0YXRlIE9ODQoJCT4gdGJsX0N1c3Rv
bWVySW5mby5TdGF0ZSA9IHRibF9TdGF0ZS5TdGF0ZUlEIExFRlQgT1VURVINCkpPSU4NCgkJdGJs
X0NvdW50cmllcw0KCQk+IE9OIHRibF9DdXN0b21lckluZm8uQ291bnRyeSA9IHRibF9Db3VudHJp
ZXMuQ291bnRyeUlEDQpMRUZUIE9VVEVSIEpPSU4NCgkJPiB0YmxfQ3VzdG9tZXJTcG9rZW5MYW5n
dWFnZUFuc3dlcnMgUklHSFQgT1VURVIgSk9JTg0KdGJsX0N1c3RvbWVyQW5zd2Vycw0KCQk+IE9O
IHRibF9DdXN0b21lclNwb2tlbkxhbmd1YWdlQW5zd2Vycy5DdXN0b21lckFuc3dlcklEDQo9DQoJ
CT4gdGJsX0N1c3RvbWVyQW5zd2Vycy50YmxfQ3VzdG9tZXJBbnN3ZXJzSUQgTEVGVCBPVVRFUg0K
Sk9JTg0KCQk+IHRibF9DdXN0b21lckxvb2tpbmdGb3JDaG9pY2VzIE9ODQoJCT4gdGJsX0N1c3Rv
bWVyQW5zd2Vycy50YmxfQ3VzdG9tZXJBbnN3ZXJzSUQgPQ0KCQk+IHRibF9DdXN0b21lckxvb2tp
bmdGb3JDaG9pY2VzLkN1c3RvbWVyQW5zd2Vyc0lEIE9ODQoJCT4gdGJsX0N1c3RvbWVySW5mby5D
dXN0b21lcklEID0NCnRibF9DdXN0b21lckFuc3dlcnMuQ3VzdG9tZXJJRA0KCQk+IFdIRVJFIHRi
bF9DdXN0b21lckluZm8uQXBwcm92ZWQgPSAnMScgQU5EIEBTdHVmZjINCgkJPiBPcmRlciBCeSB0
YmxfQ3VzdG9tZXJJbmZvLlN1YlNjcmlwdGlvblR5cGVJRCwNCkJpcnRoRGF0ZSBERVNDDQoJCT4N
CgkJPg0KCQk+DQoJCT4gQW55IGhlbHAgd291bGQgYmUgZ3JlYXRseSBhcHByZWNpYXRlZC4NCgkJ
Pg0KCQk+IFRoYW5rIHlvdSwNCgkJPg0KCQk+IEpvaG4NCgkJPg0KCQk+DQoJCT4gfCBbbmdmeC1z
cWxjbGllbnRdIG1lbWJlciBoYm1Ac29mdGhvbWUubmV0ID0gWU9VUiBJRA0KCQk+IHwNCmh0dHA6
Ly93d3cuYXNwZnJpZW5kcy5jb20vYXNwZnJpZW5kcy9uZ2Z4LXNxbGNsaWVudC5hc3AgPSBKT0lO
L1FVSVQNCgkJPg0KCQkNCgkJDQoJCQ0KCQl8IFtuZ2Z4LXNxbGNsaWVudF0gbWVtYmVyIGJpbGx2
YUBud2xpbmsuY29tID0gWU9VUiBJRA0KCQl8DQpodHRwOi8vd3d3LmFzcGZyaWVuZHMuY29tL2Fz
cGZyaWVuZHMvbmdmeC1zcWxjbGllbnQuYXNwID0gSk9JTi9RVUlUDQoJCQ0KCQkNCgkJDQoJCXwg
W25nZngtc3FsY2xpZW50XSBtZW1iZXIgcnVzcy5tY2NsZWxsYW5kQHNtYXJ0b2JqeC5jb20NCj0g
WU9VUiBJRA0KCQl8DQpodHRwOi8vd3d3LmFzcGZyaWVuZHMuY29tL2FzcGZyaWVuZHMvbmdmeC1z
cWxjbGllbnQuYXNwID0gSk9JTi9RVUlUDQoNCg=
|
|
| |
|
| |
| William \(Bill\) Vaughn (VIP) |
I just tried this with an stored procedure that has
RETURN 1111
And ExecuteScalar returned 0.
William (Bill) Vaughn
Author, trainer, mentor
Microsoft Regional Director -- Pacific Northwest
Beta V Corporation
Redmond, Washington USA
www.betav.com <outbind://15/www.betav.com>
(425) 556-9205 (v/f)
-----Original Message-----
From: Russ McClelland [mailto:Click here to reveal e-mail address]
Sent: Thursday, July 25, 2002 12:48 PM
To: ngfx-sqlclient
Subject: RE: [ngfx-sqlclient] RE: sp return value
Right, if all your after is the value returned from your SP such as:
RETURN @@IDENTITY
The ExecuteScalar() is the easiest mechanism to use. You don't have to create
extra parameters or access them after the call. ExecuteScalar() will provide
the value for you and you simply cast it into what you expect (decimal, int,
etc.)
-----Original Message-----
From: William (Bill) Vaughn
Sent: Thu 7/25/2002 2:05 PM
To: ngfx-sqlclient
Cc:
Subject: [ngfx-sqlclient] RE: sp return value
Have you tried this to return the ReturnValue from a stored procedure?
ExecuteScalar returns the first column of the first row as an object, not the
ReturnStatus.
William (Bill) Vaughn
Author, trainer, mentor
Microsoft Regional Director -- Pacific Northwest
Beta V Corporation
Redmond, Washington USA
www.betav.com <outbind://15/www.betav.com>
(425) 556-9205 (v/f)
-----Original Message-----
From: Russ McClelland [mailto:Click here to reveal e-mail address]
Sent: Thursday, July 25, 2002 9:26 AM
To: ngfx-sqlclient
Subject: RE: [ngfx-sqlclient] RE: sp return value
If your SP doesn't have a resultset returned, you can use the ExecuteScalar()
method on the SqlCommand object which runs the SP and returns the value to you.
-----Original Message-----
From: William (Bill) Vaughn
Sent: Thu 7/25/2002 11:02 AM
To: ngfx-sqlclient
Cc:
Subject: [ngfx-sqlclient] RE: sp return value
You need to create a Command object (such as SqlCommand). To this
command, add a Parameter whose direction is set to ReturnValue. Execute
the query and the ReturnValue will appear in the Parameter after rowset
population (once the DataReader is closed).
hth
William (Bill) Vaughn
Author, trainer, mentor
Microsoft Regional Director -- Pacific Northwest
Beta V Corporation
Redmond, Washington USA
www.betav.com
(425) 556-9205 (v/f)
-----Original Message-----
From: hemant mehta [mailto:Click here to reveal e-mail address]
Sent: Thursday, July 25, 2002 4:45 AM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] sp return value
hi all..
could some one tell me how do i access the stored procedure return value
in
ado.net
thanx,
hemant
----- Original Message -----
From: "David L. Penton" <Click here to reveal e-mail address>
To: "ngfx-sqlclient" <Click here to reveal e-mail address>
Sent: Thursday, July 25, 2002 9:26 AM
Subject: [ngfx-sqlclient] RE: Dynamic WHERE Clause
[Original message clipped]
| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
|
|
| |
|
| |
| ToddC@match.com |
Correct, ExecuteScalar returns the first column of the first row of the
first _Resultset_. RETURN_CODE is not in the _Resultset_, the only way =
to
get it that I know of; is as you described. Create the parameter.
The other option would be to change the code to this:
CREATE PROC uspFoo()
AS
SELECT 1111
RETURN
Course you knew this <grin>.
tc=20
-----Original Message-----
From: William (Bill) Vaughn [mailto:Click here to reveal e-mail address]=20
Sent: Thursday, July 25, 2002 4:45 PM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] RE: sp return value
I just tried this with an stored procedure that has
=A0
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 RETURN 1111
And ExecuteScalar returned 0.
=A0
William (Bill) Vaughn
Author, trainer, mentor
Microsoft Regional Director -- Pacific Northwest
Beta V Corporation
Redmond, Washington USA
www.betav.com
(425) 556-9205 (v/f)
=A0
-----Original Message-----
From: Russ McClelland [mailto:Click here to reveal e-mail address]=20
Sent: Thursday, July 25, 2002 12:48 PM
To: ngfx-sqlclient
Subject: RE: [ngfx-sqlclient] RE: sp return value
=A0
Right, if all your after is the value returned from your SP such as:
=A0
=A0=A0=A0 RETURN @@IDENTITY
=A0
The ExecuteScalar() is the easiest mechanism to use.=A0 You don't have =
to
create extra parameters or access them after the call.=A0 =
ExecuteScalar() will
provide the value for you and you simply cast it into what you expect
(decimal, int, etc.)
-----Original Message-----=20
From: William (Bill) Vaughn=20
Sent: Thu 7/25/2002 2:05 PM=20
To: ngfx-sqlclient=20
Cc:=20
Subject: [ngfx-sqlclient] RE: sp return value
Have you tried this to return the ReturnValue from a stored procedure?=20
ExecuteScalar returns the first column of the first row as an object, =
not
the ReturnStatus.
=A0
William (Bill) Vaughn
Author, trainer, mentor
Microsoft Regional Director -- Pacific Northwest
Beta V Corporation
Redmond, Washington USA
www.betav.com
(425) 556-9205 (v/f)
=A0
-----Original Message-----
From: Russ McClelland [mailto:Click here to reveal e-mail address]=20
Sent: Thursday, July 25, 2002 9:26 AM
To: ngfx-sqlclient
Subject: RE: [ngfx-sqlclient] RE: sp return value
=A0
If your SP doesn't have a resultset returned, you can use the
ExecuteScalar() method on the SqlCommand object which runs the SP and
returns the value to you.
-----Original Message-----=20
From: William (Bill) Vaughn=20
Sent: Thu 7/25/2002 11:02 AM=20
To: ngfx-sqlclient=20
Cc:=20
Subject: [ngfx-sqlclient] RE: sp return value
You need to create a Command object (such as SqlCommand). To this
command, add a Parameter whose direction is set to ReturnValue. Execute
the query and the ReturnValue will appear in the Parameter after rowset
population (once the DataReader is closed).
hth
William (Bill) Vaughn
Author, trainer, mentor
Microsoft Regional Director -- Pacific Northwest
Beta V Corporation
Redmond, Washington USA
www.betav.com
(425) 556-9205 (v/f)
-----Original Message-----
From: hemant mehta [mailto:Click here to reveal e-mail address]
Sent: Thursday, July 25, 2002 4:45 AM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] sp return value
hi all..
could some one tell me how do i access the stored procedure return =
value
in
ado.net
thanx,
hemant
----- Original Message -----
From: "David L. Penton" <Click here to reveal e-mail address>
To: "ngfx-sqlclient" <Click here to reveal e-mail address>
Sent: Thursday, July 25, 2002 9:26 AM
Subject: [ngfx-sqlclient] RE: Dynamic WHERE Clause
[Original message clipped]
@q=3D'USE
[Original message clipped]
this?
> I can write a UNION ALL query easily on top of this.=A0 Only a matter =
of
trial
[Original message clipped]
tbl_CustomerInfo.MainImage,
[Original message clipped]
tbl_CustomerInfo.CustomerID =3D
[Original message clipped]
this
[Original message clipped]
be
[Original message clipped]
| [ngfx-sqlclient] member Click here to reveal e-mail address =3D YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp =3D JOIN/QUIT
| [ngfx-sqlclient] member Click here to reveal e-mail address =3D YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp =3D JOIN/QUIT
|
|
| |
|
| |
| William \(Bill\) Vaughn (VIP) |
Yes, I knew this... ;) the original contention was that you could use
ExecuteScalar to get the ReturnValue. The problem with ExecuteScalar is that
it requires a Resultset. It would be faster to ExecuteNonQuery and return
the ReturnValue or even an output parameter.
William (Bill) Vaughn
Author, Trainer, Mentor
Microsoft Pacwest Regional Director
Beta V Corporation
www.betav.com
----- Original Message -----
From: <Click here to reveal e-mail address>
To: "ngfx-sqlclient" <Click here to reveal e-mail address>
Sent: Thursday, July 25, 2002 3:07 PM
Subject: [ngfx-sqlclient] RE: sp return value
[Original message clipped]
|
|
| |
|
| |
| Peter Brunone |
Can we see the SP and .NET code? It sounds like something's not right;
I've done a ton of RETURN @@IDENTITY SP's that successfully get picked up
with ExecuteScalar().
-Peter
-----Original Message-----
From: William (Bill) Vaughn [mailto:Click here to reveal e-mail address]
I just tried this with an stored procedure that has
RETURN 1111
And ExecuteScalar returned 0.
William (Bill) Vaughn
-----Original Message-----
From: Russ McClelland [mailto:Click here to reveal e-mail address]
Right, if all your after is the value returned from your SP such as:
RETURN @@IDENTITY
The ExecuteScalar() is the easiest mechanism to use. You don't have to
create extra parameters or access them after the call. ExecuteScalar() will
provide the value for you and you simply cast it into what you expect
(decimal, int, etc.)
|
|
| |
|
| |
| William \(Bill\) Vaughn (VIP) |
stored procedure:
CREATE PROCEDURE JustReturnValue
AS
RETURN 1111
Option Strict On
Option Explicit On
Imports System.Data.SqlClient
Public Class Form1
Inherits System.Windows.Forms.Form
Dim cn As SqlConnection
Dim cmd As SqlCommand
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Try
cn = New SqlConnection("data source=.;integrated
security=sspi;initial catalog=biblio")
cn.Open()
cmd = New SqlCommand("JustReturnValue", cn)
Dim int As Integer
int = CInt(cmd.ExecuteScalar)
Debug.WriteLine(int.ToString)
Catch ex As Exception
MsgBox(ex.ToString)
End Try
cn.Close()
End Sub
End Class
William (Bill) Vaughn
Author, trainer, mentor
Microsoft Regional Director -- Pacific Northwest
Beta V Corporation
Redmond, Washington USA
www.betav.com
(425) 556-9205 (v/f)
-----Original Message-----
From: Peter Brunone [mailto:Click here to reveal e-mail address]
Sent: Thursday, July 25, 2002 4:20 PM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] RE: sp return value
Can we see the SP and .NET code? It sounds like something's not
right;
I've done a ton of RETURN @@IDENTITY SP's that successfully get picked
up
with ExecuteScalar().
-Peter
-----Original Message-----
From: William (Bill) Vaughn [mailto:Click here to reveal e-mail address]
I just tried this with an stored procedure that has
RETURN 1111
And ExecuteScalar returned 0.
William (Bill) Vaughn
-----Original Message-----
From: Russ McClelland [mailto:Click here to reveal e-mail address]
Right, if all your after is the value returned from your SP such as:
RETURN @@IDENTITY
The ExecuteScalar() is the easiest mechanism to use. You don't have to
create extra parameters or access them after the call. ExecuteScalar()
will
provide the value for you and you simply cast it into what you expect
(decimal, int, etc.)
|
|
| |
|
|
|
|
|
