76) 10/25/2003 322160322160  322160.html">HOW TO: Return an Oracle Ref Cursor to a .NET DataReader Object by Using the .NET Managed Provider for Oracle
(322160) - This step-by-step article describes how to use the .NET Managed Provider for Oracle to pass an input parameter to retrieve a Ref Cursor from an Oracle stored procedure by using the OracleDataReader object. Requirements The following list outlines the...

77) 10/23/2003 320634320634  320634.html">HOW TO: Update Server Data Through a Web Service by Using ADO.NET and Visual J# .NET
(320634) - This step-by-step article demonstrates how to use an Web service to receive and to update data from a database by using a DataSet object. This article also demonstrates how to reference the Web service in a client application and how to display the...

78) 10/23/2003 320629320629  320629.html">HOW TO: Read and Write BLOB Data by Using ADO.NET with Visual J# .NET
(320629) - The GetChunk and the AppendChunk methods are not available in ADO.NET on DataReader columns, DataSet columns, or Command parameters. This article describes how to use Visual J# .NET to read and write binary large object (BLOB) fields. Requirements The...

79) 10/23/2003 316549316549  316549.html">HOW TO: Debug Stored Procedures in Visual Studio .NET
(316549) - This step-by-step article explains two ways that you can debug SQL Server stored procedures and the necessary configuration settings and steps for each approach. A Visual Studio .NET developer can use the Server Explorer to debug SQL Server stored...

80) 10/23/2003 322045322045  322045.html">HOW TO: Connect to a Database and Run a Command by Using ADO.NET and Visual J# .NET
(322045) - This article describes how to use ADO.NET to connect to a database and to run a command (such as the UPDATE, the INSERT or the DELETE command) by using a Visual J# .NET console application. Requirements The following list outlines the recommended...

81) 10/23/2003 328476328476  328476.html">TCP/IP Settings for SQL Server Drivers When Pooling Is Disabled
(328476) - When you use the SQL Server ODBC driver, the SQL Server OLE DB provider, or the System.Data.SqlClient managed provider, you can disable connection pooling by using the respective application programming interfaces (APIs). When you disable pooling, the...

82) 10/23/2003 316321316321  316321.html">BUG: SqlConnection Presents Misleading User Interface for ConnectionString Property
(316321) - When you try to set the ConnectionString property for a SqlConnection object at design time, the OLEDB DataLinks dialog box permits you to select any OLE DB provider on your system to generate a connection string for the SqlConnection object. When you...

83) 10/23/2003 316337316337  316337.html">HOW TO: Convert an ADO.NET DataSet to ADO Recordset in Visual Basic .NET
(316337) - This step-by-step article describes how to convert an ADO.NET DataSet object to an ActiveX Data Objects (ADO) Recordset object. This article uses the XML approach to convert the DataSet to an ADO Recordset . The XML format that is persisted in ADO...

84) 10/23/2003 318039318039  318039.html">HOW TO: Make a Typed DataSet Return a Default Value Instead of DBNull by Using Visual Basic .NET
(318039) - This step-by-step article describes how to change the XML Schema file to make a typed DataSet return a default value instead of DBNULL. Visual Studio .NET may return an exception if the value of a DataRow is DBNULL, so you must handle the exception...

85) 10/23/2003 318048318048  318048.html">HOW TO: Make a Typed DataSet Return a Default Value Instead of DBNull by Using Visual C# .NET
(318048) - This step-by-step article describes how to change the XML Schema file to make a typed DataSet return a default value instead of DBNULL. Visual Studio .NET may return an exception if the value of a DataRow is DBNULL, so you must handle the exception...

86) 10/23/2003 317164317164  317164.html">HOW TO: Retrieve DataView of a Windows Forms Bound Control in Visual C# .NET
(317164) - 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...

87) 10/23/2003 311543311543  311543.html">INFO: Firing the Windows Forms CurrencyManager Events in Visual Basic .NET
(311543) - The CurrencyManager object allows you to synchronize bound controls as a user browses through rows in a table. For example, CurrencyManager allows you to display the correct FirstName and LastName properties in separate, bound TextBox controls as a...

88) 10/23/2003 313510313510  313510.html">BUG: Error Message When You Call an OleDbDataReader Object: System.InvalidCastException: QueryInterface for Interface IRowset Failed
(313510) - When you call an OleDbDataReader object that invokes the Read method from a different single-threaded apartment (STA) thread than the object was created in, you receive the following exception: System.InvalidOperationException: The...

89) 10/23/2003 316260316260  316260.html">HOW TO: Programmatically Create a Hierarchical DataSet Object with ADO.NET in Visual Basic .NET
(316260) - This step-by-step article describes how to create a hierarchical DataSet object that you can use as a structure for your programs. You may not have the exact data or structure that you want to use for your project. You can use the method in this...

90) 10/23/2003 317175317175  317175.html">BUG: DataColumn.MaxLength Property Is Not Set for Strongly Typed DataSets
(317175) - If you create a strongly typed DataSet, the DataColumn.MaxLength property is not set.