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...

FetCh Records No 5 to 10 From Dataset

Answer Posted / rajeshwari

SqlDataAdapter.Fil;
(DataSet,StartingRecord,maxrecords,tablename);

maxrecords means how many records from starting record.
OleDbDataAdapter1.Fill(DataSet1, 3, 5, "authors")
means from 5 records from 3(4,5,6,7,8 records will be
fetched)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between oledb sql server and oledbdotnet provider?

1016


Is bulk insert faster than insert?

928


What is ado and rdo?

903


What is read only and forward only in ado.net?

948


What is a datagridview?

1050


If a table contains 20000 records. In a page at each time 100 records to be displayed.

894


What does executereader return?

990


How to pass values into a datatable?

1147


Which is faster datareader or dataadapter?

999


Give few examples of datareader that is used in different dataproviders.

982


What are basic methods of dataadapter?

978


What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

1034


how can implement dropdownlist in particular of dataset when try to update?

2782


What is the difference between data reader and data adapter?

1037


What is difference between datatable and dataset?

1068