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 |
What does ado stand for in ado.net?
What is difference between Dataview and Datatable?
What are major difference between classic ADO and ADO.NET?
What we do with the object of ado.net dataset after using it?Can we dispose it or can we set it nothing?Is it must or not?
We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?
6 Answers Accenture, FastStream,
What is the significance of CommandBehavior.CloseConnection ?
What are the advantage of ado.net?
Which method is used by command class to execute SQL statements that return single value?
what are types of Dataset ?
Why DataReader is Forward Only?
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 28 can datareader hold data from multiple tables?
HOW TO FILL GRID VIEW WITH OUT USING SQLDATASOURCE AND PROGRAMING?
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)