|
|
|
|
|
Total Hits: 82 | Today: 0
|
Author: Joydip Kanjilal
|
Rating:
|
|
In the first part of this series of articles on Data Access Layer, we have had a look at what the strategies are, for designing and implementing a Generic Data Access Layer. We have had a look at the enumerators and the factory classes that we will be using. In this part of this article of three part series, we will discuss how we can implement the DatabaseHelper class, one that would be responsible for performing the actual database operations....
|
|
|
|
Total Hits: 56 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
This article demonstrates how to call an Oracle package to retrieve a recordset using ADO on Active Server Pages (ASP).
This article assumes that:
• You are proficient with Visual Basic Scripting Edition (VBScript), ActiveX Data Objects (ADO), and Active Server Pages (ASP).
• You understand Oracle's Procedural Language/Structured Query Language, if you will also be creating Oracle packages.
• Your Internet Information Server (IIS) is configured properly to the Oracle database. Fo...
|
|
|
|
Total Hits: 190 | Today: 0
|
Author: Paul Kimmel
|
Rating:
|
|
Data is king. Companies such as Google and eBay are based primarily on the value of their data. (In Google's case, the data is actually indexes of data.) Providing access to data often is either mission critical to a company or the company's raison d'être. Recently, while working on Motown-jobs.com, I needed to implement fuzzy searches of job listings and résumés. Rather than write this code from scratch, which can be time-consuming and error-prone, I employed the Microsoft Search Engine. The MS...
|
|
|
|
Total Hits: 62 | Today: 0
|
Author: easerve
|
Rating:
|
|
Adding records to a SQL Server 2000 database using ADO.NET a fairly strait forward process, much like adding records to an Access Database.
First, you will need to import the System.Data.SqlClient name space at the top of your page....
|
|
|
|
Total Hits: 32 | Today: 0
|
Author: easerve
|
Rating:
|
|
Counting records from Access database using ADO.NET and the .NET Framework can be accomplished easily with a few lines of code.
Also see: Count Records from SQL Database using ADO.NET, SQL, and Visual Basic.NET.
First, you will need to import the System.Data.OleDb name space at the top of your page....
|
|
|
|
Total Hits: 23 | Today: 0
|
Author: John Papa
|
Rating:
|
|
When your goal is a scalable and efficient enterprise solution, you need to develop an efficient data-access strategy. You can't just do some testing on your production machines and rely on the results. While an application can exhibit excellent response times when serving a few users, performance problems can surface when the load increases. So when I am asked to perform architectural and code reviews, there are several coding patterns I look for. In this column, I will share some of them as th...
|
|
|
|
Total Hits: 63 | Today: 1
|
Author: Steven Smith
|
Rating:
|
|
Learn how to use the ADO Connection, Command, and RecordSet object with simple SQL statements with ASP (Active Server Pages)....
|
|
|
|
Total Hits: 54 | Today: 1
|
Author: Mahesh Chand
|
Rating:
|
|
This article is an unedited part of Chapter 11: Working with ODBC .NET Data Provider from A Programmer's Guide to ADO.NET in C# book. This chapter teaches you how to work with various data sources such as Oracle, MySQL, Excel, Access, Text, and Sybase using ODBC data provider....
|
|
|
|
Total Hits: 13 | 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.
This month, I'll provide a primer on column-based expressions and computations in ADO.NET...
|
|
|
|
Total Hits: 46 | Today: 0
|
Author: David Hayden
|
Rating:
|
|
When you updated a database using the DataAdapter in .NET 1.1 each command was sent to the database one at a time. This caused a lot of roundtrips to the database.
ADO.NET 2.0 has introduced the concept of Batch Updates, which allows you to designate the number of commands sent to the database at a given time. If used correctly, this can increase the performance of your data access layer by reducing the number of roundtrips to the database....
|
|
|
|
Total Hits: 112 | Today: 1
|
Author: Asif Sayed
|
Rating:
|
|
I am sure if any of us who have been dealt with a commercial business application project (Inventory Control, Financial Accounting etc.) must have been challenged with a mechanism to produce "Automatic Document ID" for any of the modules involved. The typical example would be to have "Sales Invoice IDs" to be generated automatically with pattern {yy-nnnnn}, were yy-last two digits of year and nnnnn-00001 incrementing counter.
The most typical solution to this issue would be to have a "counter...
|
|
|
|
Total Hits: 257 | Today: 0
|
Author: Bipin Joshi
|
Rating:
|
|
Let's accept the real world fact that you need to write applications targeting not only SQL Server but also many other databases including MS-Access, Oracle and other ODBC databases. Classic ADO was a generic object model. You used to use the same Connection class with SQL Server, Access and Oracle. In ADO.NET, however, you need to use different classes depending on the provider you are using. That means before starting the coding phase you need to be aware of target database. If you develop an ...
|
|
|
|
Total Hits: 115 | Today: 0
|
Author: Bipin Joshi
|
Rating:
|
|
When you use SqlDataAdapter for performing updates, the SqlDataAdapter propagates the updates one by one. That means if there are 100 rows to be updated the SqlDataAdapter will execute 100 separate operations against the database. As you might have guessed this is not efficient while dealing with large number of rows. Fortunately SqlDataAdapter allows you to execute updates in batches. You can specify the batch size i.e. number of rows to be treated as a single batch via UpdateBatchSize property...
|
|
|
|
Total Hits: 92 | Today: 0
|
Author: Christa Carpentiere
|
Rating:
|
|
Learn how to build a data processing extension for Reporting Services that enables you to use an ADO.NET DataSet as a data source.Reporting Services provides access to SQL Server, Oracle, ODBC, and OLE DB data sources as part of its standard features. For many reporting scenarios, connecting to a database and running a query is all that is needed to get all the information you need to report upon. But what happens if you want to use a DataSet as your data source? For example, maybe you already h...
|
|
|
|
Total Hits: 69 | Today: 0
|
Author: John Papa
|
Rating:
|
|
Enterprise development has been moving towards a discon-nected model in recent years and ADO.NET development is no exception. While the disconnected model of the ADO.NET DataSet offers great flexibility, that adaptability also means looser control over data updates than you get with a connected data access model. One related issue is data concurrency. This month I'll focus on concurrency violations that occur when multiple rows could be saved to the database in a single batch. When a concurrency...
|
|
|
|
Total Hits: 23 | Today: 0
|
Author: Johnny Eradus
|
Rating:
|
|
I usually see code samples using SELECT SQL queries but I don't see many articles using other SQL queries. In this article, I will show you how to execute SQL queries from your VB.NET applications. Before we go to SQL queries, we need to know how to make a connection to a database. I will use Sql data provider to connect to the SQL Server. The Sql data provider classes are defined in the System.Data.SqlCliet namespace and some general database related classes are defined in the System.Data names...
|
|
|
|
Total Hits: 27 | Today: 0
|
Author: Bob Beauchemin
|
Rating:
|
|
See how improvements to XML support in Microsoft ADO.NET 2.0 and Microsoft SQL Server 2005 work together to make handling XML data in your applications easier....
|
|
|
|
Total Hits: 41 | Today: 1
|
Author: Doug Seven
|
Rating:
|
|
With the .NET Framework Beta 2 the ADO.NET Managed Providers changed quite a bit. In this tutorial you will learn how to connect to both a SQL Server 7.0/2000 database and an Access 2000 database using the SQL Managed Provider, and the ADO.NET Managed Provider. I will show you how the code has changed from Beta 1 to Beta 2....
|
|
|
|
Total Hits: 104 | Today: 0
|
Author: cool guy
|
Rating:
|
|
This article illustrates how you can interact with the Active Directory for querying information using Microsoft.NET technologies. Then, a business entity must be defined to represent the users in the directory. It holds the information of a particular user in the directory knowing its Distinguished Name (DN). It's defined an interface IADUser and the implementation is realized in the class ADUser as shown in the Coding....
|
|
|
|
Total Hits: 107 | Today: 0
|
Author: Mahesh Chand
|
Rating:
|
|
ASP.NET 2.0 provides new data source and data-bound server controls, which allow developers to write full-fledged data-driven applications without writing even a single line of code. This article is an introduction to these new data source controls. In my forthcoming articles, I will cover various data bound controls such as GridView, DetailsView, and FormView and how these controls use data-source controls to display data.
Microsoft Architects have proved in previous versions of ASP.NET that...
|
|
|
|
|
|
