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 a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?

Answer Posted / raghwendra ji chaubey

SqlDataAdapter sda = new SqlDataAdapter(sqlquery , con);
DataSet ds = new DataSet();
sda.Fill(ds);
sda.Fill(ds, 3, 2, "SrcTables");

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is bulk insert faster than insert?

892


What is dataadapter in ado.net?

906


What are the methods of XML dataset object?

1012


How to add a javaScript function in a datagrid?

1106


What does ado stand for?

891


Is entity framework better than ado.net?

990


What are the ado.net connection pooling parameters?

963


What is the provider being used to access oracle database?

977


Data reader read and forward only, how is it possible to get 2 tables of data at a time?

902


I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

1007


What is the default timeout specified for "sqlcommand.commandtimeout" property?

1023


Explain executenonquery?

1113


How do you update a dataset in ado.net?

1004


What are the difference between readonly vs. Const?

990


What are the connected and disconnected modes in ado.net?

897