I am calling some stored Procedure, having selct statment, after inserting some a new data entry by different stored procedure.
Some times my Select stored procedure does not return any value. Data is exactly correct and when I explicitly called that SP with same data by Query analyzer, I will got the desired result.
The error I have got is System.Data error in vb.Net, due to empty DataReader. Strange is that dataReader is return true when I am calling dr.read(). Not getting exact solution.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!