|
|
|
|
|
Total Hits: 1 | Today: 0
|
Author: John Papa
|
Rating:
|
|
One of the biggest differences between traditional ADO and ADO.NET is that the rowsets stored within ADO.NET can be truly relational. For example, a DataSet can store one DataTable containing customers and another DataTable containing the customers' orders. These DataTable objects can then be related to one another within ADO.NET, thus recreating the relationship that exists within the relational database. In ADO.NET once you retrieve two rowsets of data (in other words, parents and children) an...
|
|
|
|
Total Hits: 21 | Today: 0
|
Author: Johnny Papa
|
Rating:
|
|
Your boss says, "We need our app to talk XML." Of course, XML is a solid data format, but what about the data formats that are already used by your company's applications? Your business applications may have a data access tier that reads and writes data to and from a database and sends the data back to the business services tier. What format does that data take? If you use an ActiveX® Data Objects (ADO) recordset, your business component is reliant upon the ADOR object library, which may or may ...
|
|
|
|
Total Hits: 25 | Today: 1
|
Author: Johnny Papa
|
Rating:
|
|
With the release of Microsoft® .NET just around the corner, developers are gearing up to take advantage ot the many features, increased interoperability, and better data integration that the new framework promotes. While COM and Visual Basic® 6.0 are still widely used and will likely live on for years to come, I've met many developers who are anxious to get moving with the .NET components. Some of the questions I am asked most often regarding .NET are how developing with ActiveX Data Objects (AD...
|
|
|
|
Total Hits: 20 | Today: 0
|
Author: John Papa
|
Rating:
|
|
One of the biggest differences between traditional ADO and ADO.NET is that the rowsets stored within ADO.NET can be truly relational. For example, a DataSet can store one DataTable containing customers and another DataTable containing the customers' orders. These DataTable objects can then be related to one another within ADO.NET, thus recreating the relationship that exists within the relational database. In ADO.NET once you retrieve two rowsets of data (in other words, parents and children) an...
|
|
|
|
Total Hits: 205 | Today: 0
|
Author: Jayaram Krishnaswamy
|
Rating:
|
|
This basic tutorial is targeted to those who want to develop Microsoft Access front end applications using ADO, or for those who are using DAO/RDO and want to move into ADO. This tutorial shows you how you may wire up the text boxes, combo boxes and list boxes to the underlying database using Microsoft's ActiveX Data Objects (ADO)....
|
|
|
|
Total Hits: 147 | Today: 0
|
Author: Intelligent Solutions Inc
|
Rating:
|
|
This is a simple example illustrating some of the new objects in ADO.NET, the new version of ADO will ship with Visual Basic.NET. The example illustrates use of the DataSet Object, which is like a disconnected recordset in ADO. In ADO.NET, connectionless database applications are emphasized, and the DataSet object is a major part of how they are implemented....
|
|
|
|
Total Hits: 302 | Today: 0
|
Author: Robbe D. Morris
|
Rating:
|
|
There is nothing quite like laziness to drive a self starter. I've been looking for a way to speed up the development of the data access layers I've been writing. Particularly in the area of populating class properties with the results returned from a DataTable and I really didn't want to mess with strongly typed DataSets. Plus, you really can't encapsulate business logic. In many cases, you wouldn't want to do this anyway but in some instances (and I have a few) it makes good sense. Our UI...
|
|
|
|
Total Hits: 176 | Today: 0
|
Author: John Kilgo
|
Rating:
|
|
With a little preparation on the Excel side and very little work on the ADO.NET side you can connect to and read Excel workbooks just as though they were database tables.
Since Excel has an OleDB provider, we can use ADO.NET's OleDb functionality to connect to Excel. It does take a little preparation on the Excel side however. You might think that since Excel has rows and columns we might be able to use that and refer to A1 and B3, etc. We can't (as far as I know). We must resort to another ...
|
|
|
|
Total Hits: 10 | Today: 0
|
Author: Nancy Michell
|
Rating:
|
|
I am using a WebBrowser control in a C# application. When using the control to navigate to a Web page, some pop-up windows appear, which I'd like to disable.
It's really difficult to determine whether a new window is one the user wants to see or not; she could be browsing to a page or Web app that's supposed to open a new window or she could have right-clicked and selected "open in new window." Ideally you would probably want to parse the Web page that's being loaded in the new window and...
|
|
|
|
Total Hits: 21 | Today: 0
|
Author: Bipin Joshi
|
Rating:
|
|
Tracing allows you to keep track of various events happening in the system. Tracing allows you to track the sequence of code execution along with the time taken for each step. Together, tracing can throw light on how your code is being executed and the performance of every step. Many real world applications are database driven and call for performance optimization of your data access code. Luckily, ADO.NET 2.0 provides built-in support for trace logging. The ADO.NET trace logging is tuned for pe...
|
|
|
|
Total Hits: 40 | Today: 1
|
Author: Bob Beauchemin
|
Rating:
|
|
The System.Data.dll assembly in the .NET Framework contains namespaces whose base classes can be used to create custom data providers. These namespaces also define a number of data access interfaces and base classes that let developers create data providers that will interoperate with other custom providers.
Using the ADO.NET classes Connection, Command, DataReader, and DataAdapter, writing a provider is easier than writing one for OLE DB. This article explains these classes and their impleme...
|
|
|
|
Total Hits: 26 | Today: 0
|
Author: John Papa
|
Rating:
|
|
ADO.NET in the next release of Visual Studio® code-named "Orcas" features the new Entity Framework. [ Editor's Update - 6/19/2007: The ADO.NET Entity Framework and Tools will ship during the first half of 2008 as an update to the Visual Studio 2008 release.] It allows developers to focus on data through an object model instead of through a logical/relational data model. The Entity Framework helps abstract the logical data schema into a conceptual model and allows for multiple ways to interact wi...
|
|
|
|
Total Hits: 86 | Today: 0
|
Author: AzamSharp
|
Rating:
|
|
ADO.NET 2.0 introduces a new model for executing queries. In ADO.NET 1.X we had to wait for the first query to finish the work before executing the new query. Well, fortunately that wait is now over since ADO.NET 2.0 introduces the asynchronous query execution model which allows the developer to execute multiple queries asynchronously; hence not waiting. In this article I will demonstrate how to execute queries using asynchronous model available in ADO.NET 2.0 framework....
|
|
|
|
Total Hits: 129 | Today: 0
|
Author: ASPExperts
|
Rating:
|
|
You shouldn't have to learn six objects beginning with the word "Data" to start using ADO.NET. More importantly, you shouldn't have to depend on learning a brand new object model for Microsoft's DataGrid object to customize the HTML you’re sending to the end user. You've been coding web-based systems in classic ASP for years, and most of your ASP skills do actually carry over to ASP.NET!...
|
|
|
|
Total Hits: 72 | Today: 0
|
Author: Robbe D. Morris
|
Rating:
|
|
Does one ADO methodology fit all situations? I have seen many developers use a variety of different methods in regards to creating ADO connections and recordsets in an attempt to optimize performance. These range from putting ADO connection objects in Application and Session variables and reusing the open connection for all of their pages to creating one ADO connection per page. And of course, everything else in between....
|
|
|
|
Total Hits: 27 | Today: 0
|
Author: John Papa
|
Rating:
|
|
In this month's column I will focus on some data management techniques commonly required in enterprise applications. These include saving parent-child data in a multitier application using ADO.NET, ADO.NET transactions, merge techniques, and a number of other ADO.NET features. I'll also discuss the best process for incorporating consistent and informative exception-handling techniques and debugging strategies into your multitier app....
|
|
|
|
Total Hits: 18 | Today: 0
|
Author: Bipin Joshi
|
Rating:
|
|
In majority of data driven applications developers deal with SQL queries that select, insert, update or delete data from the database. However, at times you need to retrieve schema information from the database. Suppose you are building applications that performs data import and export between two or more databases. As a good solution you would want to retrieve table schema at runtime rather than hard coding it. Luckily, ADO.NET provides a set of classes that allow you to query database schema. ...
|
|
|
|
Total Hits: 144 | Today: 0
|
Author: Muhammad Imran Taj
|
Rating:
|
|
This artilce explains how to connect and get data from an Access database in C# and ADO.NET...
|
|
|
|
Total Hits: 14 | Today: 0
|
Author: Eric Schmidt
|
Rating:
|
|
The purpose of this paper is to provide a concentrated, yet pragmatic, overview of ADO.NET by highlighting the performance and usability benefits of using ADO.NET with Microsoft® SQL Server™ 2000. The intended audience is architects and developers who are familiar with ADO and are interested in learning about data access in the Microsoft .NET Framework....
|
|
|
|
Total Hits: 17 | Today: 0
|
Author: John Papa
|
Rating:
|
|
Managing relations in a database became a whole lot easier with ADO.NET. Instead of returning a single rowset to a data store, you can return a series of rowsets and relate them within a DataSet. There are numerous advantages to using related DataTables in ADO.NET, including the ability to store your data in a hierarchical structure, easier updating of data, and the ability to use expressions in columns....
|
|
|
|
|
|
