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 does mean by a neutral culture?

0 Answers   MindCracker,


What are the events that happen when a client requests an asp.net page from iis server?

0 Answers  


What is three major points in WCF?

9 Answers   Syntel,


What are sql notifications and sql invalidations?

0 Answers  


how many select state ments are used in stored procedure?

8 Answers   CSC,


What events will occur when a page is loaded?

0 Answers  


Difference between Response.redirect vs server.transfer?

0 Answers  


What is mvc in angular?

0 Answers  


What is _viewstart?

0 Answers  


What is postback and autopostback in asp.net?

0 Answers  


Explain the differences between managed and unmanaged code?

0 Answers  


What is asp.net architecture?

0 Answers  


Categories