if i used stored procedure for retrieving the data from sql server.in front end

if i used stored procedure for retrieving the data from sql
server.in front end i had used data reader.when 100 records are
there in table.when it has displayed ten records in frontend
database has been collapsed.then where should our data available...

Question Posted / sury_dev

2 Answers
6096 Views
CybAge, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if i used stored procedure for retrieving the data from sql server.in front end i had used data rea..

Answer / santosh rudra

Since you have used data reader, the data will be in the
database. Data reader is connection oriented, if connection
is lost data is lost

Is This Answer Correct ?

13 Yes

2 No

if i used stored procedure for retrieving the data from sql server.in front end i had used data rea..

Answer / dhaval

If we show 10 data in frontend then it can be residing in the ArrayList or any kind of collections. On demand, we can get other 10 likewise. if data is lost then there is no way to get it we will find the data in Database only

Is This Answer Correct ?

0 Yes

0 No

Post New Answer