ASP.NET 2.0 Interview Question:

How does u get record no from 5 to 15 from a dataset of 100 records?

Submitted by: Administrator

// ds-> daata set

//dr as datarow

for i=5 to 15

{

dr=ds.table.row(i)

}


You can also archive using this syntax. sqlconnection con=new sqlconnection(""); Sqldataadapter da=new Sqldataadapter("T-SQlQUARy",con); dataset ds=new dataset(); da.Fill(ds,5,15,"tablename");
Submitted by: Administrator