Dataset
-
i can tell about data set . dataset is local cache stored on the client site . with the help of data adapter values are selected and fill in the dara set and connection with the databasec is then broken so you need to consulyt the database every time....like that
prashant jain malviya national institute of technology
-
A recordset looks like a single table. If a recordset is to contain data from multiple database tables, it must use a JOIN query, which assembles the data from the various database tables into a single result table. In contrast, a dataset is a collection of one or more tables. The tables within a dataset are called data tables; specifically, they are DataTable objects. If a dataset contains data from multiple database tables, it will typically contain multiple DataTable objects. That is, each DataTable object typically corresponds to a single database table or view. In this way, a dataset can mimic the structure of the underlying database.
Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group
-
Check this links, hope it will help you. http://www.geekinterview.com/question\_details/15774 http://www.dotnetspider.com/qa/Question27691.aspx
-
DataSet is connection less RecordSet is connection oriented DataSet can have bi-directional move; from top row to bottom row and bottom row to top row of any table contained in it RecordSet - Can only have uni-direction DataSet - 3 dimension (having multiple tables. Tables|Rows|Cols) RecordSet - 2 dimension (Rows|Cols) Sreekumar PP