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

What is the difference between HTTP-Post and HTTP-Get ?

1 Answers  


Difference b/w casting and boxing?

5 Answers   IBS,


What is state management techniques in asp.net?

0 Answers  


You have been given the task of designing a web services to expose the data that is stored in a database on the server. In order to successfully build the web services, you need to import some namespaces. What is the minimum namespace you need to import? a) System.Web b) System.WebServices c) System.Web.Services d) System.Web.ServiceModel

2 Answers   Syntax Softtech,


What’s the difference between Response.Write() andResponse.Output.Write()?

1 Answers  


what are types of viewstate

1 Answers  


In asp.net, if a webpage seems too slow to load completely in th ebrowser. In this case what are the checkings or actions you will take to rectify the slowness or which are the factors related to this issue? How we can trace it?

3 Answers  


Where would you use an iHTTPModule, and what are the limitations of any approach you might take in implementing one

1 Answers  


How can we Deploy a website?

2 Answers  


What is the difference between globalization and localization?

0 Answers  


Explain the asp.net session state modes.

0 Answers  


What is an Interface and What is an Abstract Class?

3 Answers  


Categories