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

Give an example of a .net application which connects to microsoft access database using ado.net classes.

1078


Do you use stored procedure in ado.net?

993


Which object is used to add relationship between two Datatables?

980


Is entity framework better than ado.net?

933


Can we do database operations without using any of the ado.net objects?

936


What is ado and rdo?

862


What is difference between datareader and dataadapter?

1000


How can we add/remove row's in "datatable" object of "dataset"?

971


What is the usage of the dataset object in ado.net?

919


What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?

950


Define table relations?

922


What is the use of adodc?

942


Define partial class?

903


What is ado.net object model?

920


Which database is the ado.net?

916