| ADO.NET 2.0 Feature Matrix |
| MSDN |
| ADO.NET 2.0 includes a new base-class provider model, features for all providers, and changes to System.Data.SqlClient. Get an overview of these new features, examples of their use, and a chart of which features are provider-neutral and SqlClient-specific. |
|
| Automatic Generated DataGrid Commands |
| C# Corner |
|
|
| BETA-PRB: CommandBuilder Changes Modified Commands Back to Original (Q310366) |
| Microsoft Support |
| The CommandBuilder object may rebuild a command that you try to modify during the next call to the DataAdapter.Update method, and your changes to the command may be lost. |
|
| BETA-PRB: Error "Unhandled Exception of Type System.NullReferenceException Occurred in CommandBuilder" (Q310367) |
| Microsoft Support |
| If you use the CommandBuilder object to explicitly get commands for the DataAdapter object as follows you can receive the following error message: "An unhandled exception of type 'System.NullReferenceException' occurred in commandbuilder (projectname).exe. Additional information: Value null was found where an instance of an object was required."
|
|
| Building a Fully Functional DataGrid |
| DotNetJunkies |
| Disappointed with the editing capabilities of the ASP.NET DataGrid? In this article, Peter will show you how to utilize several of the .NET base classes to construct your own fully featured DataGrid. |
|
| Creating a .NET Windows Installer - Part 2 |
| C#Today |
| In the first part of this series, Matthew MacDonald described how to create a simple setup program with Visual Studio .NET that could copy .NET runtime files, configure the registry, retrieve user information, and apply simple serial key validation. In this second article, he considers some more advanced techniques, and examine how they might be used in a database-based incident logging application. Some of the techniques covered include registering a custom file type, using launch conditions and using a custom add-in application to perform additional setup tasks. |
|
| Data Access and Transaction Handling Framework |
| The Code Project |
| Generic data access component for different datasources, sprocs/sql, implicitly propagated transactions, explicitly managed transaction contexts etc. |
|
| Generic Coding with the ADO.NET 2.0 Base Classes and Factories |
| MSDN |
| Learn more about the new functionality in ADO.NET 2.0 that enables you to create generic data access code. |
|
| How to avoid writing SQL for Ado.Net DataAdapter |
| The Code Project |
| Automatic creation of SQL for CRUD operations when Strongly Typed DataSets are used |
|
| How to avoid writing SQL for Ado.Net DataAdapter |
| The Code Project |
| Automatic creation of SQL for CRUD operations when Strongly Typed DataSets are used |
|
| How to update a database from a DataSet Object by using Visual C++ .NET 2003 |
| http://www.kbalertz.com/ |
| (837625) - Discusses a sequence of steps that explain how to update a database using a DataSet object is Visual C++ .NET 2003 |
|
| How to update parent-child data with an identity column from a Windows Forms Application by using a Web service in Visual C++ .NET |
| http://www.kbalertz.com/ |
| (815711) - Discusses how to create an ASP.NET Web service to access and to update a database. The article discusses how to modfiy data that is in two tables that have a parent-child relationship with an identity column that uses the Web service. |
|
| How to update parent-child data with an identity column from a Windows Forms Application by using a Web service in Visual C++ .NET |
| http://www.kbalertz.com/ |
| (815711) - Discusses how to create an ASP.NET Web service to access and to update a database. The article discusses how to modfiy data that is in two tables that have a parent-child relationship with an identity column that uses the Web service. |
|
| HOW TO: BETA: Update Server Data Through a Web Service Using ADO .NET and Visual C# .NET (Q310143) |
| Microsoft Support |
| This step-by-step article demonstrates how to use a Web Service to receive and 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 display the returned DataSet in a DataGrid control that allows you to update that data and send it back to the server. Please note that you can only use the method in this article for single-table updates. |
|
| HOW TO: Obtain Extended Error Information in the DataSet by Using Visual Basic .NET |
| Microsoft Support |
| (308058) - The DataAdapter class throws generic exceptions when problems occur. This article demonstrates how to obtain a descriptive error message for each row and column that is in fault in any table in a given DataSet class. This is very useful in update... |
|
| HOW TO: Obtain Extended Error Information in the DataSet by Using Visual Basic .NET |
| http://www.kbalertz.com/ |
| (308058) - The DataAdapter class throws generic exceptions when problems occur. This article demonstrates how to obtain a descriptive error message for each row and column that is in fault in any table in a given DataSet class. This is very useful in update... |
|
| HOW TO: Obtain Extended Error Information in the DataSet Using Visual Basic .NET (Q308058) |
| Microsoft Support |
| The DataAdapter class throws generic exceptions when problems occur. This article demonstrates how to obtain a descriptive error message for each row and column that is in fault in any table in a given DataSet class. This is very useful in update scenarios when it is important to check if there are errors in any row or column. |
|
| HOW TO: Read and Write BLOB Data by Using ADO.NET Through ASP.NET |
| http://www.kbalertz.com/ |
| (326502) - This article describes how to use the FileStream object and a byte array in ASP.NET to write binary large object (BLOB) data to Microsoft SQL Server. This article also describes how to load BLOB data from the SQL Server database and how to copy this... |
|
| HOW TO: Read and Write BLOB Data by Using ADO.NET with Visual Basic .NET |
| http://www.kbalertz.com/ |
| (308042) - The GetChunk and the AppendChunk methods are not available in ADO.NET to read and write binary large object (BLOB) fields. This article describes how to use the FileStream object and a byte array to read and to write BLOB data from Microsoft SQL... |
|
| HOW TO: Read and Write BLOB Data by Using ADO.NET with Visual C# .NET |
| Microsoft Support |
| (309158) - 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 C# .NET to read and write binary large object (BLOB) fields. Requirements The... |
|
| HOW TO: Read and Write BLOB Data by Using ADO.NET with Visual J# .NET |
| http://www.kbalertz.com/ |
| (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... |
|
| HOW TO: Roll Back Updates After an Error When You Use DataAdapter and DataSet in ADO.NET and Visual C# .NET |
| http://www.kbalertz.com/ |
| (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... |
|
| HOW TO: Update a SQL Server Database by Using the SqlDataAdapter Object in Visual J# .NET |
| http://www.kbalertz.com/ |
| (320633) - This article contains Microsoft Visual J# .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in the... |
|
| HOW TO: Update a SQL Server Database Using the SqlDataAdapter Object in Visual Basic .NET (Q308055) |
| Microsoft Support |
| This article contains Microsoft Visual Basic .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in the database. |
|
| HOW TO: Update Parent-Child Data with an Identity Column from a Windows Forms Application by Using a Web Service in Visual C# .NET (Q320301) |
| http://www.kbalertz.com/ |
| This step-by-step article describes how to retrieve a DataSet object from a Web service, how to send DiffGram updates to the Web service, and then how to merge the updated DiffGram back into the client DataSet. This process involves the following... |
|
