Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


If i have 1000 records in dataset, how to do paging?

Answers were Sorted based on User's Feedback



If i have 1000 records in dataset, how to do paging?..

Answer / arunbhararthi

you can use dataadapter fill method to implement paging in
dataset.

following is the syntax:

Public Overloads Function Fill(ByVal dataSet As DataSet,
ByVal startRecord As Integer, ByVal maxRecords As Integer,
ByVal srcTable As String) As Integer

WHERE dataSet is a DataSet to fill with records and, if
necessary, schema, startRecord is the zero-based record
number to start with, maxRecords is the maximum number of
records to retrieve, and srcTable is the name of the source
table to use for table mapping.which returns a DataSet
filled with the records based on the page size passed in the
method

for example:

da.fill(ds,0,100,"emp")

Is This Answer Correct ?    14 Yes 1 No

If i have 1000 records in dataset, how to do paging?..

Answer / sunil kumar singh

for(int i=0;i<ds.Count;i++)
{
arraylist arr=new arraylist();
string abc;
abc=ds.Tables["tablename"].Rows[0][i].ToString();
arr.Add(abc);
}

Is This Answer Correct ?    4 Yes 9 No

Post New Answer

More ASP.NET Interview Questions

How can you enable impersonation in the web.config file?

0 Answers  


Which asp.net objects encapsulate the state of the client and the browser?

0 Answers  


What is OSI layer? Explain different layers.

0 Answers   MCN Solutions,


What is strong-typing versus weak-typing?

0 Answers  


What is session in web technology?

0 Answers  


How to manage different kinds of sessions in ASP.NET?

0 Answers   Cap Gemini,


In early binding will the method invoked on com component will verify it?s existance in the system or not ?

0 Answers   DELL,


what is impersonation in ASP.NET?

7 Answers   Accenture, Merrill Lynch, Wipro,


What is the default authentication mode for asp.net?

0 Answers  


what are partial classes and their use?

3 Answers   Microsoft,


Explain transparent caching with aop?

0 Answers  


How does asp.net page work?

0 Answers  


Categories