31) 11/21/2003 320141320141  320141.html">HOW TO: Retrieve an Identity Value from a Newly Inserted Record from SQL Server by Using Visual Basic .NET
(320141) - This step-by-step article describes how to retrieve the identity value when you add a record into a SQL Server table with an identity field. Requirements This sample uses the Northwind database in SQL Server and retrieves the identity values only for...

32) 11/21/2003 815672815672  815672.html">HOW TO: Use XML in Connected and Disconnected ADO.NET Applications by Using Visual C# .NET
(815672) - Extensible Markup Language (XML) is a fundamental part of ADO.NET and Web services. This article describes how to use XML in connected and disconnected ADO.NET applications: Connected ADO.NET applications can query SQL Server to return an XML result...

33) 11/20/2003 320916320916  320916.html">HOW TO: Call SQL Server Stored Procedures in ASP.NET by Using Visual C# .NET
(320916) - This article demonstrates how to use ASP.NET and ADO.NET with Visual C# .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. The code sample in this article first checks whether the stored...

34) 11/19/2003 816177816177  816177.html">HOW TO: Populate a Datagrid Control on a Background Thread with Data Binding by Using Visual C++ .NET
(816177) - This step-by-step article describes how to query a database on a background thread, and how to use data binding to display the results of the query in a DataGrid object. When you run large queries to a database, your application may become...

35) 11/19/2003 322793322793  322793.html">HOWTO: Fill a Typed DataSet from a Stored Procedure That Returns Multiple Resultsets by Using Visual Basic .NET
(322793) - The step-by-step article demonstrates how to use the DataAdapter TableMappings collection to map the generic DataTable object names to the schema that is already defined in the typed DataSet object. When you use a DataAdapter object to fill a DataSet...

36) 11/19/2003 330610330610  330610.html">HOW TO: Generate a Fully Populated DataGridTableStyle
(330610) - When you bind a Windows Form DataGrid control, the DataGrid builds a DataGridTableStyle object that contains default properties of the grid column objects. However, you cannot access or modify a DataGridTableStyle object that is built this way. You...

37) 11/19/2003 316887316887  316887.html">HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and Visual Basic .NET
(316887) - This article explains how to read and write data from BLOB (LongVarBinary) columns in a database table. NOTES : This article provides examples of both the SqlClient and the OleDb DataAdapter . The only differences, apart from class names, are the...

38) 11/19/2003 321896321896  321896.html">HOW TO: Perform a Complex Filter in ADO.NET
(321896) - In ADO.NET, you can use the DataView.RowFilter property and the DataTable.Select method to filter a subset of records. However, the expressions that you can use have limitations. This article demonstrates three techniques to work around the...

39) 11/19/2003 322932322932  322932.html">HOW TO: Enable and Disable DataTable Editing by Using the DataGrid in Visual C# .NET
(322932) - This step-by-step article demonstrates how to control editing tables in the DataGrid control on a table-by-table basis. The Navigate event of the DataGrid only fires when you move from DataTable object to DataTable object, not record to record. When...

40) 11/19/2003 328101328101  328101.html">ConnMaker.exe - .NET Database Connectivity Testing Tool
(328101) - The ConnMaker tool is available for download to help users test connectivity through the .NET Data Providers to SQL Server, and to other server data sources. Source code for the tool is provided as a resource for programming connectivity and data...

41) 11/19/2003 814470814470  814470.html">DataTable.Select Method Leaks Memory from the Index When You Set Some Specific Filter Properties
(814470) - When you set some specific filter properties, the DataTable.Select method may leak memory.

42) 11/19/2003 312794312794  312794.html">INFO: OLE DB .NET Managed Provider Does Not Support Some OLE DB Providers in Visual C# .NET
(312794) - The OLE DB .NET managed provider does not support all OLE DB providers.

43) 11/19/2003 326176326176  326176.html">HOW TO: Implement a DataSet SELECT DISTINCT Helper Class in Visual C# .NET
(326176) - This step-by-step article illustrates how to implement and how to use a DataSetHelper class that includes sample code to create a DataTable object that contains the unique values of a column of another DataTable object. To do this, you use the...

44) 11/19/2003 306574306574  306574.html">HOW TO: Call SQL Server Stored Procedures in ASP.NET by Using Visual Basic .NET
(306574) - This article demonstrates how to use ASP.NET and ADO.NET with Visual Basic .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. The code sample in this article first checks whether the...

45) 11/15/2003 321718321718  321718.html">HOW TO: Call Oracle Stored Procedures in Visual Basic .NET with the Microsoft Oracle Managed Provider
(321718) - 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, and to display the information in a DataGrid object. Requirements The following...