FetCh Records No 5 to 10 From Dataset

Answer Posted / rajeshwari

SqlDataAdapter.Fil;
(DataSet,StartingRecord,maxrecords,tablename);

maxrecords means how many records from starting record.
OleDbDataAdapter1.Fill(DataSet1, 3, 5, "authors")
means from 5 records from 3(4,5,6,7,8 records will be
fetched)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Some important instruction regarding ADO.NET connection string ?

536


What is variable view?

490


What are the difference between readonly vs. Const?

497


What is data relation in ado.net?

511


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

531






Data reader read and forward only, how is it possible to get 2 tables of data at a time?

488


Explain advantages of ado.net?

551


What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

765


What is oledb driver?

491


What is sqldatareader?

484


How do you implement locking concept for dataset?

541


What is the difference in record set and dataset?

515


Define the data provider classes that is supported by ado.net?

514


What is datatable in ado.net?

515


What are two important objects of ADO.Net?

552