Answer / don

if there are 10000 records , break the records into two
half using sql quries and then by using ado.net
connectivity we can do this,

1st 5000 records: string s1=select top 5000 * from emp

2nd 5000 records: string s2=select top 5000 * from emp
order by empid desc

sqldataAdapter d1 = new sqldatAadapter(s1);
sqldataAdapter d2 = new sqldatAadapter(s2);

dataset ds = new dataset();

d1.fill(ds,"e1");
d1.fill(ds,"e2");

grid1.datasource = ds.tables["e1"];
grid1.datasource = ds.tables["e2"];

Answer / paban

If the connection source is one then use limit command in
both the sql commands.

What is the use of sessionstate tag in the web.config file?

2 Answers  

---

Mention the namespace that is used to include .net data provider for sql server in .net code?

0 Answers  

---

What is the difference between Server.Transfer and Response.Redirect?

5 Answers  

---

We Only Know The Total Number Of Feet In The Farmyard. Write A Program that will compute the total number of rabbits and chickens in the farmyard. Assume number of feet in the farmyard are 40. how many rabbits and chickens are?

0 Answers  

---

What are directives in asp.net?

0 Answers  

---

how can you bind data from dataset to XML file

2 Answers   LG Soft,

---

Which is faster viewdata or viewbag?

0 Answers  

---

with which controls you worked in Asp.net 2.0?

2 Answers   HP, nTech Solutions,

---

what is the differance between .DLL & .EXE

10 Answers   Infinite Computer Solutions,

---

What is custom control. What is the difference between custom control and user control?

2 Answers   Microsoft,

---

Explain the server control events of asp.net ?

0 Answers  

---

What is the advantage of mvc over asp.net? : Asp.Net MVC

0 Answers  

---