91) 10/23/2003 309681309681  309681.html">HOW TO: Retrieve Schema Information by Using GetOleDbSchemaTable and Visual C# .NET
(309681) - 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...

92) 10/23/2003 309683309683  309683.html">HOW TO: Retrieve Column Schema by Using the DataReader GetSchemaTable Method and Visual C++ .NET
(309683) - This article demonstrates how to use the GetSchemaTable method of the DataReader object in ADO.NET to retrieve column schema information. Another name for a column's schema is its field properties. Column schema information includes the following...

93) 10/23/2003 308651308651  308651.html">HOW TO: Obtain Underlying Provider Errors by Using ADO.NET in Visual C++ .NET
(308651) - Managed providers can raise several exceptions. To obtain more detailed information about the cause, you need access to provider-specific error information. This article shows how to gather this information. Requirements The following list outlines...

94) 10/23/2003 308656308656  308656.html">HOW TO: Open a SQL Server Database by Using the SQL Server .NET Data Provider with Visual Basic .NET
(308656) - This article describes how you can use ADO.NET to open a SQL Server database by using the SQL Server .NET data provider. ADO.NET gathers all of the classes that are required for data handling. The System.Data.SqlClient namespace describes a collection...

95) 10/23/2003 317119317119  317119.html">DOC: Incorrect Description for dataIndex
(317119) - In the following two MSDN links SqlDataReader.GetChars Method -and- OleDbDataReader.GetChars Method dataIndex is described as "The index within the row from which to begin the read operation." The description for dataIndex should be "The index within...

96) 10/23/2003 317150317150  317150.html">HOW TO: Reuse the SqlCommand and OleDbCommand Objects in Visual Basic .NET
(317150) - This step-by-step article describes how to reuse the SqlCommand object in your Visual Basic .NET code. Description of the Technique You can reuse Command objects ( SqlCommand or OleDbCommand ) in code. That is, you can create one Command object and...

97) 10/23/2003 317041317041  317041.html">HOW TO: Retrieve DataView of a Windows Forms Bound Control in Visual Basic .NET
(317041) - This article describes how to retrieve a DataView object from a Windows Forms bound control. Description of the Technique To bind a data source to a Windows Forms control, you can code it yourself or use design-time binding. When the binding occurs at...

98) 10/23/2003 308624308624  308624.html">PRB: Output Parameters Are Not Returned When You Run an ADO.NET Command in Visual C++ .NET
(308624) - When you run an ADO.NET command, the output parameters may not be initialized, or they may return an incorrect value.

99) 10/23/2003 309544309544  309544.html">BUG: BeginTransaction() Changes Isolation Level for Subsequent Transactions
(309544) - When you call the SqlConnection.BeginTransaction method and specify an isolation level in the IsolationLevel property, after the transaction is committed or rolled back, the IsolationLevel property is not reset to the default of...

100) 10/23/2003 306726306726  306726.html">BUG: Unexpected Exception on Serialization of DbConcurrencyException
(306726) - When you serialize a DBConcurrencyException object, the value of the Row property in the serialized version of the object is set to a null value and an exception occurs: An unhandled exception of type 'System.NullReferenceException' occurred in...

101) 10/23/2003 313304313304  313304.html">HOW TO: Use Base Classes to Reduce Code Forking with Managed Providers in Visual C# .NET
(313304) - Use this step-by-step guide to learn how to use base classes to reduce code forking with managed providers. Description of the Technique ADO.NET has different types of data providers (for example, SqlClient, OleDb, ODBC, and so on). If you choose the...

102) 10/23/2003 316024316024  316024.html">HOW TO: Roll Back Updates After an Error When You Use DataAdapter and DataSet in ADO.NET and Visual C# .NET
(316024) - This article describes how to roll back updates after an error when you use a DataAdapter and a DataSet object. If your client application uses an ADO.NET DataSet object to store changes that are made to data or to add new records, you can use a...

103) 10/23/2003 317017317017  317017.html">HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and Visual C++ .NET
(317017) - Use this step-by-step guide to read and write data to and from BLOB (LongVarBinary) columns in a database table. NOTES This article contains examples for both the SqlClient and the OleDb DataAdapter classes. The only differences, apart from the class...

104) 10/23/2003 315159315159  315159.html">BUG: Named Pipes Do Not Work When Worker Process Runs Under ASPNET Account
(315159) - Under the following circumstances An ASP.NET worker process (Aspnet_wp.exe) runs under the default ASPNET account. -and- You do not enable impersonation on that application. -and- You use the SQL Server .NET Data Provider or the OLE DB .NET Data...

105) 10/23/2003 309487309487  309487.html">HOW TO: Read Hierarchical Data into a DataSet in Visual Basic .NET
(309487) - Use this step-by-step guide to copy hierarchical data into a DataSet by using the Fill method of the DataSet class. How to Read Hierarchical Data into a DataSet You can use hierarchical rowsets or chapters (OLE DB type DBTYPE_HCHAPTER and ADO type...