Hi Vijay,
     If i use objCommand.item(0) I am getting the first parameter name(@empno") and If I use objCommand.item(0).value I am getting the value of the parameter which i am sending.
     If I write objCommand.item(1) I am getting name of the return parametre as "@x" and if i use
objCommand.item(0).value I am not getting any value.

If i execute the same sp in query analizer i am getting correct result..
I need Your help in this regard
Thnaks
Suresh
If possible mail to the id ([email protected])

Hope you haven't gone through the article I referred in my previous post.

At this point the stored procedure has been executed and cmd.parameters(0) contains the return value.

Did you try this? What do you get if you use objCommand.parameters(0)

Cheers!

_________________________
- Vijay G
Strive for Perfection

There are two problems with your approach:
1. if you want to get the return value then it must be the first parameter added to the collection, so you're adding the params in the wrong order.
2. return values can only be INT, they cannot be VARCHAR. So you can't use this method to capture the employee name - you'll have to use an explicit output parameter to get a varchar back.

hth
Phil

Hi brain,
     I changed the order of creation of parameters. Now i am getting result i want exactly.. As Vijay said i tried with (parameters(0)). But it is not giving result. And one ore thing, here i am getting varchar as return type. ther is no such condition that function only return integers. It can return data of any type.
I just kept return parameter at the first in theparameters list.
Now i am out of trouble.
Thanks for you all to make me get out of this probelm..
Once again thanks..

Does changing the index help? Though it is not defined to be the first param.
objCommand.parameters(1)

_________________________
- Vijay G
Strive for Perfection

Hi Vijay,
I tried like that also.
I declared return parameter as second one and
I used objCommand.parameters(1) to get that .
But i didnt get any result.
By this my conclusion is return parameter should be daclared as the first one.

Thanks
Suresh babu