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

how to change a value of particular cell in a data grid

3 Answers

What are reflections in c#?

0 Answers

i have a question which is quite simple but yet complicated for me my question is why do we use void, if it does not return anything to the compiler? if it is used for normal display it can also be done by what is called Console.Write() or Consol.WriteLine() and if i do not use void with my method then my compiler throws me an error. if i return a value say integer then i write public int fun() display of the result can also be done here then why is it so necessary to use void with a function and why so compiler throw us an error if v don't use void return type?

2 Answers

Why is it a bad idea to throw your own exceptions?

4 Answers

how can include .netframeworl 2.0 in application setup

1 Answers

What is difference between iqueryable and ienumerable in c#?

0 Answers

Which are access modifiers available in c#?

0 Answers

How can we insert 100 records @ a time without using for loop into the databse

10 Answers IBM,

what is generics? can u explain 5 to 6 examples on generics that covers class,method,structure,list,delegates?