46) 11/13/2003 329247329247  329247.html">BUG: Cannot Open a SQLConnection in a Timer Event When You Debug
(329247) - When you debug, you receive the following error message if you step over the SqlConnection.Open function in a Timer event: There is no source code for the current location.

47) 11/11/2003 325684325684  325684.html">HOW TO: Implement a DataSet SELECT DISTINCT Helper Class in Visual Basic .NET
(325684) - 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...

48) 11/11/2003 317940317940  317940.html">HOW TO: Write an XSD Schema from a Database by Using a DataSet
(317940) - Use this step-by-step guide to write an XSD schema from a database. This article focuses on the following two scenarios: How to write an XSD schema from a DataSet object with one table where all columns are not required in the resulting XSD schema....

49) 11/11/2003 818779818779  818779.html">HOW TO: Populate a DataSet Object from a Database by Using Visual C++ .NET
(818779) - This step-by-step article describes how to fill a DataSet object with the results of one or more database queries and then how to access the data after the query is loaded in the DataSet object. DataSet objects are in-memory objects that can hold...

50) 11/8/2003 308621308621  308621.html">PRB: Output Parameters Are Not Returned When You Run an ADO.NET Command in Visual C# .NET
(308621) - Output parameters do not appear to be initialized or return a wrong value when you run an ADO.NET command.

51) 11/8/2003 824407824407  824407.html">FIX: "Object Reference Not Set to an Instance of an Object" Error While Rolling Back a Transaction
(824407) - When you use the Microsoft ODBC .NET Managed Provider, and an intermittent network problem causes a loss of connection to your database server while you are trying to rollback the transaction, you may receive the following error message: Object...

52) 11/5/2003 829142829142  829142.html">HOW TO: Dynamically Page through a Large Result Set in ASP.NET by Using SQL Server Stored Procedures in Visual C# .NET
(829142) - This step-by-step article describes how to use SQL stored procedures to dynamically page through a large result set in Microsoft ASP.NET. back to the top Methods of Implementation There are three main paging techniques that you can use in ASP.NET to...

53) 11/4/2003 306724306724  306724.html">INFO: "Encrypt" Has Been Added to the SqlConnection Keywords
(306724) - Support for the keyword "encrypt" has been added to the SqlConnection ConnectionString property.

54) 11/4/2003 310375310375  310375.html">PRB: 'System.Data.DBConcurrencyException' When You Update a Database Through a Stored Procedure
(310375) - When you use a DataAdapter object to write changes back to a database by means of a stored procedure, you may receive the following error message: An unhandled exception of type 'System.Data.DBConcurrencyException' occurred in system.data.dll...

55) 11/4/2003 301075301075  301075.html">HOW TO: Connect to a Database and Run a Command by Using ADO.NET and Visual Basic .NET
(301075) - 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 Basic .NET console application. back to the top Requirements The following list outlines...

56) 11/4/2003 301216301216  301216.html">HOW TO: Populate a DataSet Object from a Database by Using Visual Basic .NET
(301216) - DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article shows how to fill a DataSet object with the results of one or more database queries, and how...

57) 11/4/2003 311348311348  311348.html">PRB: Error in SQL Server 7.0 When You Call Command.Prepare Before You Add Parameters Using Visual C# .NET
(311348) - When you create a parameterized command against Microsoft SQL Server 7.0, if you call the Prepare method before you add parameters to the command, you receive the following error message: An unhandled exception of type...

58) 11/4/2003 307645307645  307645.html">PRB: Cannot Connect to SQL Server on Any Port Other Than 1433
(307645) - When you use a protocol other than Transmission Control Protocol/Internet Protocol (TCP/IP), SqlConnection.Open fails if you specify a port number other than 1433 to connect to an instance of Microsoft SQL Server.

59) 11/4/2003 309335309335  309335.html">PRB: Unexpected Exception Occurs When a Transaction Is Committed or Rolled Back After a Data Source Error Has Occurred
(309335) - In Microsoft ADO.NET, an exception may occur when a transaction is committed or rolled back. When you call the Commit method of a transaction, you may encounter the following exception: The COMMIT TRANSACTION request has no corresponding BEGIN...

60) 11/4/2003 810098810098  810098.html">BUG: Object Reference is Not Set to an Instance of an Object
(810098) - On a computer that has Microsoft .NET Framework 1.0 installed (and that does not have Microsoft Visual Studio .NET installed), when you try to access data using ADO Interop on an ASP.NET page that resides at an identical site and that is hosted on the...