If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?

Answer Posted / satyambabu

Dataset consists of DataTable collection which consists of
DataRows. Create Dataset object, then create DataRow object

Dim objRow as New DataRow

objRow(9) to objTow(19) woud give the rows between 10 and
20, as first row is stored with index 0.

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is it possible to get 2 tables of data at a time by using data reader?

572


What is difference between ado.net and asp net?

620


How to add a check box or a dropdown list to a column in a datagrid?

625


What is ado and rdo?

575


What do you mean by performing asynchronous operation using command object?

606






How will you fill the gridview by using datatable object at runtime?

631


What does ado stand for in ado.net?

530


What is executenonquery ado.net?

597


What are dcl commands?

577


Which parameter of ConnectionString is used to specify the name of the database?

647


What is sqldatareader in ado.net?

576


What is difference between dataset and datatable?

608


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

616


What are the key features of ado.net?

754


Can datareader hold data from multiple tables?

752