ADO and ADO.NET Comparison: ------------------------------------------------------------------------------------------------------------------------------------------------ -------------------------------------------------project ADO ADO.NET -------------------------------------------------------------------------------------------- ------------------------------------------- Data Update Direct Processing Similar Batch data accesses slower (because in memory) Acord Data DataSet.Tables ("Data Table Name") data .Select Data Traversal Recordset .MOVENEXTMDATASet.Tables ("Data Table Name"). ROWS (i = 1) A field RecordSet.fields ("Field Name) MyDataSet.Tables (" Data Table Name "). Rows (X, Y) Universality It is difficult to transfer between the main unit can be transferred to XML traffic (over the firewall) data to express more simple (View and Table only) more complete (can include multiple data sheets, and associated) system resources are wasteful (must always Connection) Save (can be used to turn off only with DataSet)
