106) 10/23/2003 309488309488  309488.html">HOW TO: Retrieve Schema Information by Using GetOleDbSchemaTable and Visual Basic .NET
(309488) - This article demonstrates how to use the GetOleDbSchemaTable method of the OleDbConnection object in ADO.NET to retrieve database schema information. Schema information in a data source includes databases or catalogs that are available from the data...

107) 10/23/2003 309490309490  309490.html">HOW TO: Handle Multiple Results by Using the DataReader in Visual Basic .NET
(309490) - This article contains a generic function that you can use to process multiple recordsets and other messages that are returned from stored procedures or the execution of batch SQL statements. Description of the Technique ActiveX Data Objects (ADO) can...

108) 10/23/2003 308484308484  308484.html">HOW TO: Display Parent and Child Records in a Windows Forms DataGrid by Using Visual C# .NET
(308484) - This article describes how to create a Windows form that displays a parent (or master) record and all of the related child (or detail) records by using the Northwind Customers and Orders tables. This article also describes the CurrencyManager object...

109) 10/23/2003 308495308495  308495.html">HOW TO: Use a Web Service as a Data Source for a Client Application in Visual C# .NET
(308495) - This step-by-step article demonstrates how to create and test a Web service that returns a DataSet object to a client. This article also demonstrates how to reference the Web service in a client application and display the returned DataSet in a...

110) 10/23/2003 307710307710  307710.html">HOW TO: Perform Paging with the DataGrid Windows Control by Using Visual C# .NET
(307710) - The DataGrid Web control has built-in Automatic or Custom Paging functionalities; however, the DataGrid Windows control lacks these features. This article demonstrates how to create a simple paging mechanism for the DataGrid Windows control. The code...

111) 10/23/2003 308426308426  308426.html">HOW TO: Use Data Link Files with the OleDbConnection Object in Visual C# .NET
(308426) - This article demonstrates how to use an OLE DB Universal Data Link (.udl) file to specify the connection string that an ADO.NET OleDbConnection object uses to establish a database connection. OLE DB Universal Data Link (.udl) files provide a...

112) 10/23/2003 308428308428  308428.html">HOW TO: Use Data Link Files with the OleDbConnection Object in Visual C++ .NET
(308428) - This article demonstrates how to use an OLE DB Universal Data Link (.udl) file to specify the connection string that an ADO.NET OleDbConnection object uses to establish a database connection. OLE DB Universal Data Link (.udl) files provide a...

113) 10/23/2003 311274311274  311274.html">HOW TO: Handle Multiple Results by Using the DataReader in Visual C# .NET
(311274) - This article contains a generic function that you can use to process multiple recordsets and other messages that are returned from stored procedures or the execution of batch SQL statements. Description of the Technique ActiveX Data Objects (ADO) can...

114) 10/23/2003 309485309485  309485.html">HOW TO: Build a Connection String Programmatically in ADO.NET by Using Visual Basic .NET
(309485) - This step-by-step article demonstrates how to use the Data Link Properties dialog box to programmatically create a connection string at design time. Requirements The following list outlines the recommended hardware, software, network infrastructure,...

115) 10/23/2003 309486309486  309486.html">HOW TO: Execute SQL Parameterized Stored Procedures by Using the ODBC .NET Provider and Visual Basic .NET
(309486) - This step-by-step describes how to call a parameterized SQL Server stored procedure using the ODBC .NET Managed Provider and Visual Basic .NET. Although executing a parameterized stored procedure using the ODBC .NET Provider is slightly different from...

116) 10/23/2003 307512307512  307512.html">BUG: GetSchemaTable() of SqlDataReader Returns Wrong Column Name
(307512) - The GetSchemaTable method of the SqlDataReader object returns columns, the BaseServerName and BaseCatalogName properties. However, SqlDataReader.GetSchemaTable should only return BaseCatalogName.

117) 10/23/2003 310367310367  310367.html">PRB: "Unhandled Exception of Type 'System.NullReferenceException'" Error Message When You Use CommandBuilder
(310367) - If you use the CommandBuilder object to explicitly get commands for the DataAdapter object as follows: da.InsertCommand = cb.GetInsertCommand and then run the following Visual Basic .NET code cb.DataAdapter = Nothing or the following Visual C# .NET...

118) 10/23/2003 309361309361  309361.html">HOW TO: Use a DataReader Against an Oracle Stored Procedure in Visual C# .NET
(309361) - This step-by-step article uses the DataReader object to retrieve data from an Oracle stored procedure. You can use the DataReader to retrieve a read-only, forward-only stream of data from a database. Using the DataReader can increase application...

119) 10/23/2003 309362309362  309362.html">HOW TO: Use a DataReader Against an Oracle Stored Procedure in Visual C++ .NET
(309362) - This step-by-step article uses the DataReader object to retrieve data from an Oracle stored procedure. You can use the DataReader to retrieve a read-only, forward-only stream of data from a database. Using the DataReader can increase application...

120) 10/23/2003 310370310370  310370.html">HOW TO: Retrieve Values from DataRows That Are Marked "Deleted" by Using Visual Basic .NET
(310370) - You can use ADO.NET DataTable objects to delete rows and mark them as "Deleted." This article demonstrates how to retrieve the values of a row whose DataRowState enumeration is set to DataRowState.Deleted . Description of the Technique You can use the...