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

Define isolation?

922


What is method to get XML and schema from Dataset? getXML() and get Schema ()

932


What are the several execute methods of ado.net?

878


What are all components of ADO.Net data provider?

1019


What two types of data providers does ADO.NET supply? What determines which one you should use?

952


What is the provider being used to access oracle database?

947


Which provider is used to connect ms access, oracle, etc…?

954


What is the default Timeout for SqlCommand.CommandTimeout property?

966


Is bulk insert faster than insert?

870


Explain executenonquery?

1078


What is acid in ado.net?

959


What is ado.net in vb net?

883


What is sqlconnection and sqlcommand?

1018


What is data relation?

858


What are the data providers used in ado.net

981