The Wayback Machine - https://web.archive.org/web/20061025170240/http://www.codeguru.com/csharp/.net/net_data/

CodeGuru
Earthweb Search
Forums Wireless Jars Gamelan Developer.com
CodeGuru Navigation
Member Sign In
User ID:
Password:
Remember Me:
Forgot Password?
Not a member?
Click here for more information and to register.

jobs.internet.com

internet.commerce
Partners & Affiliates
IT Discount Club
Trade Show Items
Help Desks
Auto Insurance Quote
New Car Prices
Televisions
Health Insurance
Dental Insurance
Price Search
Merchant Accounts
Batteries
Web Design
Domain Names
Server Racks



RSS Feeds

All

VC++/C++

.NET/C#

VB

See more EarthWeb Network feeds

Home >> .NET / C# >> .NET >> Data & Databases

Embracing the full spectrum of developer needs including content supporting 64 bit, Multi-Core, Tools, and Optimization.

Sun's AMD Opteron Compatibility Guarantee
They promise what?! Yes indeed, Sun offers a legally binding guarantee that future versions of Solaris will support any AMD Opteron-based application that will run on the current version of the OS. Read more.
Future-Proof Your File System in 5 Minutes on AMD
ZFS, the open source, freely available 128-bit file system, now included with the Solaris 10 operating system (as well as other OSes based on the OpenSolaris project), moves data fast, scales without practical limit and makes File System Check (FSCK) obsolete. Here's what you need to know about ZFS on AMD64. Read more.
AMD's Multiple Threads, Multiple Cores, Multiple Gains
Author Peter Aitken walks through the benefits of preemptive multitasking and the opportunities there are for developers. Read more.
Taking Advantage of Concurrent Programming for Windows, Part 3: Locality Effects in .NET Multi-Core Programming
In this third segment, author Larry O'Brien shows one way the data caches on the Opteron and Athlon processor families help prevent "premature optimization." Read more.
For more relevant code samples, tutorials and editorials click here.

Intel Software at IDF. Looking to create the next software breakthrough? Don�t miss the Intel Developer Forum, the premier technology industry event. Sign up now for special software community rates.

Data & Databases

Data & Databases



ASP.NET Developer's Cookbook, Chapter 13
Rating:
Steven A. Smith and Rob Howard - 09/17/2003
ASP.NET provides several Web controls that make displaying data on a Web page easier than ever before. This chapter shows you how to take advantage of a process called data-binding to easily display data in a variety of formats using very little code.

Building Data Aware Web Applications with ASP.NET -- Part 3
06/04/2003
Discover how to authenticate users using the credentials from a database as well as learn how to apply Web Services for performing database operations.

.NET Data Secrets, Part 1
05/05/2003
Among the top solutions being built today are database applications. Karl more teaches some time saving tricks to get the most out of database development for .NET.


DataGrid



Building an ASP.NET 2.0 Master/Detail Application with DB2
Rating: none
Anil Mahadev - 10/13/2006
The advent of Visual Studio 2005 and ASP.NET 2.0 have simplified building master/detail apps to just a matter of using the right controls for the job. Find out just how easy the process is with a DB2 backend.

DLINQ: Bridging the Object Relational Divide
Rating: none
Sahil Malik - 06/02/2006
DLINQ attempts to bridge the impedance mismatch between relational data and objects. Learn all about the various functions and services DLINQ offers to enable you to working with relational data as objects.

Presenting Parent/Child Data in a Data Grid Row
Rating:
Ezhilan - 12/14/2005
Learn how to bind a data grid to a data table with parent and child rows by having the Repeater control.

Product Overload: Microsoft
Rating:
Bradley Jones - 09/16/2005
Are you missing Microsoft's Professional Developers Conference (PDC)? If so, you'll still want to make sure you keep up on all the announcements.

[Updated] Using Nullable Types in C#
Rating:
Bradley Jones - 08/17/2005
The next release of C# (ECMA-334, 3rd Edition) includes the ability to use nullable data types. If you are unfamiliar with nullable types, this introduction is for you!

Autosize a DataGridView to Fit
Rating:
Wilfried Mestdagh - 06/13/2005
Read about a little code snippet to show how to autosize the columns of a DataGridView in an intelligent way to fit after resizing the form.

Managed C++: Read Image Data Using the ADO.NET DataReader
Rating: none
Tom Archer - MSFT - 01/31/2005
Tom Archer illustrates step-by-step instructions for using the .NET DataReader class to read image data from a database, and he presents a generic function that will write this data to disk.

Combo Control (not yet reviewed)
Rating:
venkatsriram - 12/27/2004
4-in-1 component for ASP.NET DHTML tab, tree, panel, menu - horizontal, vertical, pop-up, fading effects

Want to Execute Multiple Queries on a Single Connection? Go to MARS
Rating: none
Thiru Thangarathinam - 11/24/2004
ADO.NET 2.0 introduces Multiple Active Result Sets (MARS), a feature that enables you to execute multiple queries against the database using a single connection. Learn how to return multiple forward-only, read-only result sets using MARS.

Take Advantage of Isolated Storage with .NET
Rating: none
Mike Amundsen - 11/03/2004
Learn the basics of the .NET runtime's isolated storage function. Then, see how to use it to create a utility class that makes reading and writing user-specific application data safe and easy.

Past, Present, and Future of ADO.NET
Rating:
Ramesh Kumar Nagarajan - 06/10/2004
Learn how ADO .NET evolved and what the future holds for it.

Excel 2 Win!
Rating:
Sids - 03/10/2004
This tutorial demonstrates how to copy Excel data into a Windows DataGrid Control from the Clipboard.

Managing Complex Layout and Nesting DataGrids in ASP.NET
06/27/2003
Learn how to intersperse HTML table rows and cells across DataList templates to intimately manage the appearance of a DataList. In addition, learn how to nest a DataGrid in a DataList, and learn the best way to manage the presentation and code-behind for control nesting by using a UserControl.

Editing Nested DataGrids in ASP.NET
06/27/2003
While DataGrids can be nested easily, successfully repeating or nesting a DataGrid and getting the edit and update behavior to respond correctly is more of a challenge.

Using Nested DataGrids in ASP.NET
Rating:
Paul Kimmel - 05/30/2003
Discover the basic technique for binding any data source to a DataList and DataGrid in .NET. Also learn the basics for defining a data binding statement for the template sections of a DataList.

.NET Data Secrets, Part II
05/21/2003
Discover a few more tips and tricks for working with data in .NET using Visual Basic .NET. In this installment you learn nine steps to building a quick, editable Web grid as well as a little-known technique for confirming Web deletes. Selecting multiple Web form grid items in a Hotmail style is also presented.

Building Data Aware Web Applications with ASP.NET - Part 2
05/02/2003
Learn how to view and update records in a database using ASP.NET and the DataGrid control.


Sorting and Iterating



IBM DB2 Application Development with Visual Studio .NET
Rating: none
Anil Mahadev - 09/18/2006
Thanks to the DB2 Development Add-In for Visual Studio .NET, you can develop DB2 database applications using Visual C#.

Reporting on Hierarchical Recursive Data Using MS Reporting Services
Rating: none
Asif Sayed - 07/05/2006
Here's a new twist on creating database reports.

.NET Sorting: Compare Just About Any Property of Any Object
Rating:
Paul Kimmel - 06/23/2006
Implement the generic interface IComparer with some reflection, and .NET will provide sorting that compares just about any property of any object. See how it's done.

DLINQ: Submitting Your Changes
Rating: none
Sahil Malik - 06/16/2006
Submitting changes as update, insert, and delete queries is at the heart of any data-driven application. Learn the various support options DLINQ offers for these tasks.

Transactions in the .NET 2.0 Framework
Rating: none
Joe Duffy - 05/04/2006
Learn about the importance of transactions and key transaction management features in .NET 2.0 from JOe Duffy, author of Professional .NET Framework 2.0.

Domain Objects Caching Pattern for .NET
Rating: none
Iqbal2004 - 04/27/2006
Explore how to cache your domain objects and put caching code inside your persistence classes.

Eliminate Unnecessary Code and Boost Performance with C# 2.0 Iterators
Rating: none
Mark Strawmyer - 01/05/2006
With the .NET Framework 2.0 release now available, you can explore the C# 2.0 iterators feature. Examine the iterators design pattern and find out what it takes to implement and then modify it manually.

System.Transactions: Implement Your Own Resource Manager
Rating: none
Sahil Malik - 11/18/2005
Very few resource managers (RMs) are available with the framework of System.Transactions right now. So why not write your very own RMs and use them in conjunction with the hordes of RMs that will appear in future releases of the .NET Framework?

For Developers, Microsoft Has More in Store than Ever Before, Part 2
Rating:
Patrick Gallucci - 10/10/2005
Microsoft announced so many new tools and technologies at its Professional Developers Conference (PDC) 2005 that our "man on the scene" needed a second article to cover it all. Find out what else Redmond has planned for .NET developers.

Create Provider-Independent Data Access Code with ADO.NET 2.0
Rating: none
Thiru Thangarathinam - 08/26/2005
ADO.NET 2.0 offers new base classes and factory classes that enable you to write data access code that works with almost all data stores. Find out how to seamlessly working with multiple providers like SqlClient, OleDb, and ODBC without having to lock into a specific implementation.

What .NET 2.0 Has in Store for ADO.NET
Rating: none
Mark Strawmyer - 05/11/2005
Take a foray into ADO.NET to see what's in store for the next release. You'll find some very handy additions and enhancements.

Database Provider-Independent Data Access Layer Using ADO.NET 2.0
Rating:
SeenivasaRagavan Ramadurai - 03/17/2005
Learn to use ADO.NET 2.0 to access data layers.

Managed C++: Write Image Data Using the ADO.NET Command and Parameter Objects
Rating: none
Tom Archer - MSFT - 02/04/2005
Tom Archer illustrates in step-by-step fashion how to read an image file from disk and then save it to a SQL Server database by using the ADO.NET SqlCommand and SqlParameter objects.

Generic Code to Execute Stored Procedures
Rating:
Sriram Surapureddy - 01/26/2005
Generic code to execute any stored procedure/batch of stored procedures with different number of parameters and data types

Reading From Databases
Rating:
Wiley Publishing - 11/08/2004
Learn some time-saving tricks to use ASP.NET to read information from a database to your Web site.

Developing an Application Integration Component (AIC) in BizTalk Server to Parse XML Data and Store
Rating: none
Syed Hameed - 03/29/2004
Application Integration Component (AIC) can be developed in BizTalk Server to parse XML data and store into SQL Server table.

Parsing Data Files
Rating:
Mark Strawmyer - 03/08/2004
Learn more about reading from files and examine the task of parsing data from a file.

Doing Database Operations In Batches
Rating:
Tom Archer - MSFT - 02/26/2004
There are times when it is advantageous to perform certain database operations in batch. This excerpt from Extending Applications with the .NET Framework details how and when.

Performing Various Iteration Methods in .NET
Rating: none
Trevor Misfeldt - 05/02/2003
Iterate through data as quickly as possible. This article shows a comparison of various methods for iterating through data in .NET.


Web Grid



Saving Rich Edit Control Text to SQL Server
Rating:
Tom Archer - MSFT - 06/28/2004
Allowing users to enter formatted text is a great addition to any user interface. In this article, Tom Archer shows you how to save the user's formatted text to a SQL Server database.

A Practical Guide to a Post-Relational Database for .NET: Matisse - Part 2
Rating: none
johnssk - 04/23/2004
This is the second article in a series of articles that provides a step-by-step guide to a post-relational database for .NET. The second one covers schema definition with the database and demonstrates how it can be simplified.

A Practical Guide to a Post-Relational Database for .NET: Matisse
Rating:
johnssk - 04/12/2004
This is a step-by-step guide for a post-relational database for .NET that provides you with better productivity and extensibility for data management. The article aims to help developers quickly evaluate this alternative solution for .NET database.

The Big ASP.NET DataGrid Article, Part 3
Rating:
Karl Moore - 03/03/2004
Implement the likes of paging and sorting into your DataGrids, but first, start off with the most gruesome of tasks: adding an editable drop-down box to your DataGrid!

The Big ASP.NET DataGrid Article, Part 2
Rating:
Karl Moore - 02/26/2004
Look at using HTML, hyperlinks, and formatting in your DataGrid, plus figure out color-coding and the many different ways of allowing the user to select rows.

.NET Data Secrets, Part III
06/02/2003
Learn about using a Web Grid for quick and easy data paging, fast sorting, exporting a Web grid to Excel, and using an amazing undocumented SQL Server tool for writing code.


ISV Innovation Tech Briefings: Free, Demo-driven Events on the 2007 Microsoft Office System
Webcast for Application and Service Providers: Explore Business Intelligence Open Source Offerings
Is it time to make your move to the multi-threaded and parallel processing world? Find out!
Hands-on Tutorial: Hello World--Rational Software Architect--Click here!
Download: Rational Application Developer. Quickly design, develop, analyze, test, & deploy apps.


JupiterWeb networks:

internet.comearthweb.comDevx.comGraphics.com

Search JupiterWeb:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterWeb

Jupitermedia Corporate Info