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 / pra vesh hajela

SqlConnection conn = new
SqlConnection(AppConfiguration.ConnectionString);
SqlCommand cmd = new
SqlCommand("SelectCustomerInfo", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
//da.Fill(ds);
da.Fill(ds, 10, 10, "table");
return ds;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What provider ado.net use by default? Explain the role of data provider in ado.net?

1025


What are the different execute methods of Ado.Net?

1060


What is ole in excel?

984


What do you know about ADO.NET's objects and methods?

1033


What is row state?

1034


What are the advantages of using datalist?

1043


How to add a javaScript function in a datagrid?

1179


What are the steps to connect to a database?

1071


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?

1064


Which object needs to be closed?

2307


What is ado.net and its features?

1029


How to perform sorting on a table in ADO.NET?

1079


How does entity framework work?

970


What is dataset and datatable in ado.net?

1042


What is the significance of CommandBehavior.CloseConnection ?

1212