Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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

Is a structure a class?

0 Answers  


Which is executed if an exception has not occurred?

0 Answers   Siebel,


Explain the types of comments in c#?

0 Answers  


Is java better than c#?

0 Answers  


What?s the difference between the System.Array.CopyTo() and System.Array.Clone()?

6 Answers   Wipro,






Describe the accessibility modifier protected internal.

3 Answers   Siebel Systems, Visual Soft,


What is string concatenation?

0 Answers  


In a stored procedure 4 select stmts there.If error comes in one select stmt will remaining normally executes?

7 Answers   Microsoft,


What is data annotation in c#?

0 Answers  


How is exception handling implemented in c#?

0 Answers  


Why is .net so popular?

0 Answers  


What is a three-tier application.

0 Answers   Siebel,






Categories