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

RequiredFieldValidator--write code in javascript

3 Answers   Wipro,


What is difference between datalist and gridview?

0 Answers  


What are different ASP.NET Web Forms with the technology different from though ASP (1.0-3.0)?

1 Answers   Siebel,


Can we make a class with class with same;suppose public class abc { public class abc { } }

1 Answers  


What are different transaction options?

2 Answers   Astadia,


How do you define authentication in Web.Config?

2 Answers   Accenture, BirlaSoft, IBM,


How many types of Cookies are available in ASP.NET?

0 Answers   MindCracker,


What asp.net control can embed xaml into asp.net pages?

0 Answers  


What is global.asax file used for?

0 Answers  


What do you mean by role-based security?

0 Answers  


What is AutoPostback?

0 Answers  


I have to send data throug querystring from one page to another. But it should not be displayed in URL. How it is possible?

6 Answers   EMR, Wipro,


Categories