We don't know what your sp returning and what type of parameter you are passing to the sp. indresh code is the way you have to fetch the record. So as per the sp you have to pass the exact parameter from code to get your desired result.

Disclaimer: This site is started with intent to serve
the ASP.Net Community by providing forums (question-answer) site where people can
help each other. The content posted here is free for public and is the content of
its poster. The site does not provide any warranties for the posted content. If
you feel any content is violating any terms please
contact.