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
6846 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

More C Sharp Interview Questions

Can a class have static constructor?

0 Answers

What is regex c#?

0 Answers

I have a very important query in my mind. Please help me regarding this. I don't have any real time exp in .net. But I have a knowledge it .net. I got an offer from an MNC company as a software developer has I had kept 2 years of fake exp. Even though for this job I had worked hard to crack interview for about an year. So, I would like to know how difficult it will be for working in real time as I don't have real time exp. Please tell me as soon as possible bcoz I need to join by next month. Can i sustain over there for a longer time or not. And also let me know how to work pressure will be over there. Please help me regarding this. I'm getting tension thinking about it. Thank you.

1 Answers

Is type nullable c#?

0 Answers

What does using do in c#?

0 Answers

Can hashset contain duplicates c#?

0 Answers

How u make an application remotable?

1 Answers

How to properly clean up excel interop objects?

0 Answers

What is c-sharp (c#)?