FetCh Records No 5 to 10 From Dataset
Answers were Sorted based on User's Feedback
Answer / dinesh
Declaration : SqlDataAdapter da;
Instantiation : Dataset ds = new DataSet();
da.Fill(ds,StartingRecord,EndRecord,tablename);
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / deepak gupta
SqlDataAdapter.Fil;
(DataSet,StartingRecord,EndingRecord,tablename);
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / 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 |
DataSet supports to recieve the specfic row with the
starting rows and ending rows.
SqlDataAdapter.Fil;(DataSet,"Sample",StartingRecord,EndingRecord);
| Is This Answer Correct ? | 1 Yes | 2 No |
Is bulk insert faster than insert?
What is a datagrid?
Give an example that shows how to execute a stored procedure in ado.net?
What are the uses of Stored Procedure?
What is the difference between data reader and data adapter?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.
2 Answers Fulcrum Logic, Satyam,
What is executenonquery ado.net?
What are the different methods by which we can populate a dataset?
differences between ADO and ADO.NET
What is difference between dataset and datatable?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
Which method is used by command class to execute SQL statements that return single value?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)