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 differences between a primary key and a unique key in sql server?

0 Answers  

---

What does this do? gacutil /l | find /i about

1 Answers  

---

In this case if exception occure in Database which catch block will be exexcuted?

1 Answers   Microsoft,

---

what are the web form events available in asp.net?

0 Answers  

---

web farm .. how does session shuld be stored... if inproc used? does the session persists from one server to other.

2 Answers   TCS,

---

How to publish website

1 Answers   Syntel,

---

page life cycle of asp.net.

4 Answers  

---

What is the difference between control and component?

4 Answers  

---

List of interview questions collections at www.dpoint.weebly.com

2 Answers   IBM,

---

how to encrypt a connection string in web.config file?

3 Answers   Hexaware,

---

what is the difference between sql 2000 and 2005?

2 Answers   Cognizant,

---

What does clearing cache?

0 Answers  

---