Data Sets and Data Adapters

The DataSet object is similar to the ADO Recordset object, but more powerful, and with one other important distinction the DataSet is always disconnected. The DataSet object represents a cache of data, with database-like structures such as tables, columns, relationships, and constraints. However, though a DataSet can and does behave much like a database, it is important to remember that DataSet objects do not interact directly with databases, or other source data. This allows the developer to...

How Do ISink Unmanaged Events from NET

This example demonstrates how to sink unmanaged events from .NET code. In order to use the types defined within a COM library from managed code, you have to obtain an assembly containing definitions of the cOm types. Refer to the How Do I Build a .NET Client That Uses a COM Server for specific details. With Visual Basic.NET or with C , you can reference the assembly using compiler r switch or you can add reference to your project directly from the Visual Studio.NET development tool. Once you...

Data and ADONET

Overview of ADO.NET Execute a Command Get Out Parameters from a Stored Procedure Generate XML with data from SQL Server Load a native ADO recordset into a DataSet Convert an ADO Application to ADO.NET There are many ways to filter data. One way is to filter data at the database command level, using a where clause on your query. A second way is to filter the data after it is in the DataSet. This topic covers filtering in the DataSet. Once data is in a DataSet you can use methods on the DataSet...