What is the difference between an ADO.NET Dataset and an ADO Recordset?

1-Data-set is disconnected architecture but record set is connected architecture. 2- record-set provides data one row at a time. but data -set is a data structure that shows complete data at same time

dfdfdfgfdgfd

1- using Dataset we can combine one or more tables but when we use recordset we can by using sql join 2-Dataset can represent an entire relational database in memory complete with tables,views but recordset not 3-dataset cant have record pointer.you can use foreach loop for moving data but in recordset it has pointer to move the Data

1)While using Dataset we can combine one or more tables but when we use recordset we can't. 2)Dataset enables to share the data between applications by streaming its XML representation of data whereas Recordset requires COM marshaling to transmit the data from one component to another.