| Building a Generic Database Tool Using .NET and Three Tier Architecture |
| DotNetJunkies |
| In this article, Sun shows how easy it is to develop a n–tiered Web application to create a generic database tool using ASP.NET and the .NET Framework. The system is quite simple and is able to handle the management of any simple table in any database. It provides an excellent starting point for providing a generic database tool. |
|
| Building a Tiered Web App Using the DataSet and the ASP DataGrid |
| MSDN |
| This month, I'll walk through the development of a three-tiered Web application that retrieves data, allows the user to make changes, and sends the data back to the database using the DataSet object as the transport mechanism. |
|
| Building a Universal DAL Component |
| DotNetJunkies |
| Think about the possibilities of a component in the data access layer (DAL) of your application that didn't care what .NET Data Provider you were using. It could work just as easily with the SQL Server Data Provider or the OleDb Data Provider, or any other potential .NET Data Providers that could surface in the future. A DAL component that you could use against an Access 2000 database in development, and against a SQL Server database in production. |
|
| Building an N-Tier Application in .NET |
| MSDN |
| After reviewing the types of n-tier applications, you'll learn how to create a typed dataset that can return data from a Web service and consume a Web service from a Windows application. |
|
| Building database application with ADO.NET for beginner. |
| The Code Project |
| An article on building database with ADO.NET application for beginner |
|
| Building RADical Web Services with VS.NET: A Top-Down Approach |
| DotNetJunkies |
| Peter works with Web Services in a RADical way. He shows you how to build powerful Web Services and their consumers without having to know that much about XML or serialization. |
|
| ColdStorage Advertising Service Development |
| MSDN |
| This article describes some of the issues faced and lessons learned in the development of the ColdStorage sample Advertising Service. |
|
| Commands in ADO .NET |
| MSDN |
| In ADO there are three possible ways to update a data source. One is through direct SQL commands, like INSERT, DELETE and UPDATE, or more complex and sophisticated stored procedures. Another is through batch update, where you submit a new image of a certain table to the server all at once. The third way is through direct fields update using server cursors. |
|
| Common .NET Libraries for Developers |
| MSDN |
| Identifies and defines many of common namespaces that you will use when developing .NET applications, and provides examples of the most common classes and methods in those namespaces. |
|
| Comparing the Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NET |
| MSDN |
| Get a comparison of the strengths of the two most common .NET data providers for Oracle, and be prepared to select the right one for your next development project. |
|
| Connecting to MySQL database from your .net applications. |
| The Code Project |
| A simple introduction on how to connect to an MySQL database. |
|
| Coping with a New Beta - Connecting to Databases |
| DotNetJunkies |
| 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.</ |
|
| Coping with a New Beta - DataSetCommand to DataAdapter |
| DotNetJunkies |
| In ASP.NET Beta 1 we all got very used to using the DataSetCommand (SQLDataSetCommand or ADODataSetCommand). With the release of Beta 2 we have a little relearning to do. In this tutorial you will learn how to use the DataAdapter, the Beta 2 equivalent of the DataSetCommand. The downloadable sample code is in both C# and Visual Basic.NET |
|
| Counting Records in an SQL Table |
| ASP Alliance |
| I was working on a project using my C# Class Generator and realized that I had no way to get a count of the number of records in the table. In the past I have used the DataAdapter class - easy, but not very efficient. I ran accross a post on one of the discussion forums and decided to build a new function in my class generator appropriately named RecordCount. The function returns an 'int' with the number of records in the table. |
|
| 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. |
|
| Data Access in ASP.NET 2.0 |
| MSDN |
| Leverage the new ASP.NET 2.0 data access controls to reduce the code you have to write when developing a data-driven Web application. |
|
| Data Access Support in Visual Studio.NET (Whidbey) |
| DotNetJunkies |
| Within this is an overview of the data access support in ADO.NET, covered by the System.Data and System.Xml namespaces. This white paper details the innovations and enhancements in the data access layer in Whidbey when retrieving data from data sources, particularly SQL Server. It covers the growth of ADO.NET in Whidbey to encompass the relational, object and XML data models, and explains typical usage scenarios for each with development guidelines and recommendations. |
|
| Data Points |
| MSDN |
| Contrasting the ADO.NET DataReader and DataSet |
|
| Data Points - Managing Hierarchical Inserts in ASP.NET and ADO.NET |
| MSDN |
| Manage and persist user input before it's committed to the database |
|
| Data Points: Migrating from ADO to ADO.NET, Part 2 |
| MSDN |
| Getting started with ADO.NET, part 2 |
|
| DataAdapter Events |
| .NET Xtreme |
| DataAdapter class(OleDb and Sql) exposes three events that can be used as record and respond to the changes being made to the database. |
|
| Detect Changes To A Database Table |
| The Code Project |
| This article sorts to illustrate one of the ways by which data table changes can be detected through the use of available aggregate functions like BINARY_CHECKSUM and CHECKSUM_AGG. |
|
| Discussion Forum Board |
| Master C# |
| This example updates the previous forum example that I had written for beta1. A lot has changed since then, even though from outside the forum has the same looks internally a lot has changed! Due to this I have taken the trouble to elaborate this example into easy to understand pieces. |
|
| Displaying data in a DataGrid using VS.NET IDE |
| C# Corner |
| We need fast coding, especially when there lots of data needed to be accessed through the web. We need an efficient way to create interfaces for the users to manipulate the data. DataGrid is one of the very useful controls in ASP.NET, and VS.NET even maximize its efficiency by keeping the code that we need to write to a minimum. |
|
| Dynamic DataGrid Paging and Sorting Using A DataReader |
| DotNetJunkies |
| In a previous article I demonstrated one of nine ways one could page and bi-directionally sort a DataGrid. I opted for the hidden field method. This method, among the eight others works fine, and it all depends on how you want to approach this based on any given factors in your app. The problems we'll be discussing here lay not with either the paging or sorting aspects of it, but rather in implementing the most efficient manner in retrieving data and presenting it to the client. |
|
