ADO.NET » Miscellaneous

We have 36 Miscellaneous tutorials, you can see below:


SQL Classes Encapsulation (simplified stored procedure calls, queries and DataSet returns with .NET)


A class that encapsulates SQL connection classes to make queries and stored procedures very easy to run in .NET. Contains methods like ExecuteStoredProcedure and ExcuteSelectStatement to return DataSets.


Details  •  Read Tutorial  •  Views: 330  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:44

Localizable DataSet


Put language-dependent column captions in the DataSet itself and use it in your code wherever you need it!


Details  •  Read Tutorial  •  Views: 375  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:43

Recommended ADO.NET Data Access Strategies


ADO.NET provides two basic strategies for how you work with the disconnected data model


Details  •  Read Tutorial  •  Views: 392  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:43

AutoIncrement in a disconnected DataSet


Working with disconnected DataSets that contain autoincrement count.


Details  •  Read Tutorial  •  Views: 256  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:42

ADO.NET – Get the notification events from Managed Providers


How to use the event handlers for various ADO.NET connection & data objects.


Details  •  Read Tutorial  •  Views: 181  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:42

Convert XML to Strongly Typed DataSets


An example of using an XML document to generate a typed DataSet and load it.


Details  •  Read Tutorial  •  Views: 233  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:41

Add custom validation to data columns in ADO.NET


This article describes how to add custom validation to a data column in ADO.NET.


Details  •  Read Tutorial  •  Views: 228  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:39

ADO.NET for the Object-Oriented Programmer – Part Three


In this article, we will see how to use ADO.NET to serialize an object model. Once we have finished with serialization, we will look at how to bind our object model to user controls.


Details  •  Read Tutorial  •  Views: 194  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:37

ADO.NET for the Object-Oriented Programmer – Part One


This article will show how to accomplish these goals—use ADO.NET as a thin data transport layer, while still taking advantage of the data-binding capabilities of .NET user interface controls. As it turns out, it’s pretty easy.


Details  •  Read Tutorial  •  Views: 223  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:36

.NET DataSet to ADODB Recordset Conversion


A description of how how to convert a .NET DataSet to an ADODB Recordset.


Details  •  Read Tutorial  •  Views: 222  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:36

ADO.NET for the Object-Oriented Programmer – Part Two


In this second part of the article series, we will revisit the ADO.NET CRUD operations. Only this time, we will use an application with far better architecture. Once that is done, we will move on to data binding with objects.


Details  •  Read Tutorial  •  Views: 195  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:35

Component to access databases in the .NET environment


An extremely flexible and easy-to-use library that retrieves data in XML format, supports simple parameterized queries, stored procedures, and transactions. It can also be used as a web service.


Details  •  Read Tutorial  •  Views: 210  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:34

Declarative Transactions using ADO.NET and without Enterprise Services.


Sometimes it is nice to prototype up a simple database application. This code may help, by providing the automatic transactional model of COM+ in a non-COM+ environment. This example uses \"Interception\" to provide automatic transactioning support for non-COM+ classes.


Details  •  Read Tutorial  •  Views: 195  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:33

Edit Almost Anything in a DataGrid


Allow your DataGrid to edit pictures and a whole range of other data types.


Details  •  Read Tutorial  •  Views: 219  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:33

DataGrid Copy Helper Component


A component providing Copy functionality to a Windows Forms DataGrid. Copied data can then be pasted in Excel or a text editor.


Details  •  Read Tutorial  •  Views: 220  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:32

Working with DataGrid in VC++.NET


This article demonstrates the DataGrid , ADO.NET components, and storing data into the database and retrieving from the same.


Details  •  Read Tutorial  •  Views: 242  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:19

ADO.NET Primer using Managed C++


A primer on using ADO.NET with Managed extensions for Visual C++ .NET


Details  •  Read Tutorial  •  Views: 217  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:17

Using ADO.NET in MFC Projects


Mixing managed and unmanaged code and using .NET library in MFC projects


Details  •  Read Tutorial  •  Views: 231  •  Rate: 0 (0 votes)  •  Feb 27 2007 - 09:10

ADO.NET and UDL


Using Data Link files with SQLClient and OracleClient.


Details  •  Read Tutorial  •  Views: 254  •  Rate: 0 (0 votes)  •  Feb 14 2007 - 13:21

Simulating Recordsets with ADO.NET


A proposed class to simulate the ADODB.Recordset behavior in .NET.


Details  •  Read Tutorial  •  Views: 253  •  Rate: 0 (0 votes)  •  Feb 14 2007 - 13:21

ADO.NET RecordSet Library


An ADO.NET recordset class.


Details  •  Read Tutorial  •  Views: 283  •  Rate: 3 (1 votes)  •  Feb 14 2007 - 13:19

Declarative Transactions using ADO.NET and without Enterprise Services.


Sometimes it is nice to prototype up a simple database application. This code may help, by providing the automatic transactional model of COM+ in a non-COM+ environment. This example uses \"Interception\" to provide automatic transactioning support for non-COM+ classes.


Details  •  Read Tutorial  •  Views: 220  •  Rate: 0 (0 votes)  •  Feb 03 2007 - 15:05

ADO.NET – Get the notification events from Managed Providers


How to use the event handlers for various ADO.NET connection & data objects.


Details  •  Read Tutorial  •  Views: 216  •  Rate: 0 (0 votes)  •  Feb 03 2007 - 14:59

WQL DataProvider for ADO.NET


WQL DataProvider for ADO.NET


Details  •  Read Tutorial  •  Views: 246  •  Rate: 0 (0 votes)  •  Feb 03 2007 - 14:55

Inherit from ADO.NET DataSet to create your own business objects


Extend generated Strong Typed Datasets, add your own business-specific functionality to a real DataSet object. Binding to forms and updating to a database is all done by the .NET framework. This is built on Shawn Wildermuth\'s a.k.a. ADO Guy\'s DataSetGenerator.


Details  •  Read Tutorial  •  Views: 279  •  Rate: 0 (0 votes)  •  Feb 03 2007 - 14:55

.NET DataSet to ADODB Recordset Conversion


A description of how how to convert a .NET DataSet to an ADODB Recordset.


Details  •  Read Tutorial  •  Views: 245  •  Rate: 0 (0 votes)  •  Feb 03 2007 - 14:53

2 Ways of Displaying Data from an SQL Server Database using ADO.NET.


A step-by-step tutorial which explains 2 ways of displaying data from an SQL Server database using ADO.NET in an ASP.NET page. Every step has been explained in detail. Online demo and source code available for download.


Details  •  Read Tutorial  •  Views: 247  •  Rate: 0 (0 votes)  •  Jan 22 2007 - 12:42

Write Image Data Using the ADO.NET Command and Parameter Objects


This article shows the reverse scenario of reading an image file from disk and saving it to a database column by utilizing the SqlCommand and SqlParameter classes. With the various command classes (for example, SqlCommand, OracleCommand, OdbcCommand, and so forth) you easily can insert or modify database records by passing a SQL statement to the command class\'s constructor (or setting a command object\'s CommandText property) and then calling one of the command object\'s \"execute\" methods, such as ExecuteReader.


Details  •  Read Tutorial  •  Views: 290  •  Rate: 0 (0 votes)  •  Jan 21 2007 - 18:03

Connecting to Databases the ASP.NET Way


It seems with every new release of Visual Studio we get a new data access method. DAO, RDO, ADO...and now ADO.NET. Well, this version of Visual Studio not only introduces ADO.NET, but also the SQL .NET Data Provider. ADO.NET and the SQL .NET Data Provider introduce many new features that we cover in other tutorials. There are quite a few samples out there demonstrating how to connect your ASP.NET application to a Microsoft SQL Server database...but lets face it, not everybody uses SQL. So how can you connect your application to an ODBC or OLEDB data store? The answer is with the ODBC and OleDb .NET Data Providers. In this tutorial we will cover all three types of connections.


Details  •  Read Tutorial  •  Views: 258  •  Rate: 0 (0 votes)  •  Jan 20 2007 - 16:44

ADO.net Programming Style


ADO.net Programming article which focus on both how to write efficient code and how to represent the information which take advantage of layered design of .net framework. Articles describes how you can write code efficiently and improve performance of application and avoids errors due to poor coding style.


Details  •  Read Tutorial  •  Views: 259  •  Rate: 0 (0 votes)  •  Jan 20 2007 - 16:40

Add custom validation to data columns in ADO.NET


Currently, the DataTable has minimal support for custom validation in data columns when creating extended data columns. This article shows how to add regular expression validation capabilities to the data columns by extending the ADO.NET DataColumn. The DataColumn can be validated whenever it undergoes a change, against a validator.


Details  •  Read Tutorial  •  Views: 275  •  Rate: 0 (0 votes)  •  Jan 20 2007 - 16:23

Introducing ADO.NET


This paper introduces something Microsoft calls ADO.NET. Don\'t confuse this new .NET data access interface with what we have grown to know understand as ADO - I think it\'s really very different. Yes, ADO.NET and ADOc both open connections and fetch data, however, they do so in different ways using different objects and with different limitations.


Details  •  Read Tutorial  •  Views: 767  •  Rate: 0 (0 votes)  •  Jul 07 2005 - 09:46

.NET Data Access Architecture Guide


This guide focuses on the use of ADO.NET to access Microsoft SQL Server 2000 by using the SQL Server .NET data provider, one of the two providers shipped with ADO.NET. Where appropriate, this guide highlights any differences that you need to be aware of when you use the OLE DB .NET data provider to access other OLE DB - aware data sources.


Details  •  Read Tutorial  •  Views: 1168  •  Rate: 0 (0 votes)  •  May 30 2005 - 16:42

The Data Access Application Block


Data Access for .NET consists of an architecture guide and an application block. The Data Access for .NET Architecture Guide provides guidelines for implementing an ADO.NET-based data access layer in a multi-tier .NET application. It focuses on a range of common data access tasks and scenarios and presents guidance to help you choose the most appropriate approaches and techniques.


Details  •  Read Tutorial  •  Views: 881  •  Rate: 4 (1 votes)  •  May 30 2005 - 16:42

Introducing ADO.NET


This paper introduces something Microsoft calls ADO.NET. Don't confuse this new .NET data access interface with what we have grown to know understand as ADO - I think it's really very different. Yes, ADO.NET and ADO both open connections and fetch data, however, they do so in different ways using different objects and with different limitations.


Details  •  Read Tutorial  •  Views: 854  •  Rate: 0 (0 votes)  •  May 24 2005 - 16:40

Top 10 New Features of ADO.NET 2.0


This article summarizes the new and updated features of ADO.NET 2.0, which ships with .NET Framework 2.0.


Details  •  Read Tutorial  •  Views: 984  •  Rate: 0 (0 votes)  •  Sep 10 2004 - 20:52