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

how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....

4456


What is the difference between ado.net and oledb?

952


Which is faster entity framework or ado.net?

934


Why do we use sqldataadapter?

951


What is ado.net in mvc?

928


What is row state?

983


What is two way data binding android?

988


What are the Data providers in ADO.Net?

1019


What is ole in vb?

901


How to work with disconnected data - the dataset and sqldataadapter?

988


Explain the role of data provider in ado.net?

992


What are the key events of sqlconnection class?

1193


Explain ado.net features? Benefits? Drawbacks?

1052


What are the steps you will take to improve performance?

894


What connected data?

962