The Wayback Machine - https://web.archive.org/web/20071116085409/http://www.codeguru.com:80/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.
Biz Resources
Network Security Services
VoIP
CRM Software

jobs.internet.com

internet.commerce
Partners & Affiliates
Promotional Gifts
KVM Switches
Managed Hosting
Logo Design
Home Mortgage Loans
KVM over IP
Holiday Gift Ideas
Laptop Computers
Economy Server Racks
Home Improvement
Laptop Battery
KVM Switch over IP
Build a Server Rack
Freelance Programmers


RSS Feeds

RSSAll

RSSVC++/C++

RSS.NET/C#

RSSVB

See more EarthWeb Network feeds

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


Usability and Design
The Usability and design space brings together the latest information, research, tools, podcasts, and conference information related to usability and design. Content is pulled from IBM and non-IBM sites. »
 
Ajax Resource Center
This space is your one-stop shop for information on the Ajax programming model, including articles and tutorials, discussion forums, blogs, wikis, events, and news. If it's happening, it's covered here. »
 
Linux Security
The Linux security space gives an overview of security issues related to Linux and covers all aspects of securing a Linux distribution. It also links to Linux security-related news and articles. »
 
Ruby Programming
Take a closer look at Ruby, a dynamic programming language that is growing rapidly in popularity. Explore its intriguing features and learn what programmers are doing with it. »
 
Wiki: WebSphere, SOA, J2EE in Practice
This wiki discusses how to use J2EE and related technologies to develop business applications, including how to make best use of IBM J2EE products like WebSphere Application Server and Rational Application Developer, and IBM SOA products like WebSphere Process Server and WebSphere Integration Developer. While it occasionally delves into tangential topics and future trends, the primary focus is on how to make use of the products and technologies that we have today. »

Microsoft Dynamics: ERP Software Your People Can Actually Use. Get Free Trials, Demos, and Case Studies of Microsoft Dynamics. Increase Adoption, Reduce Support with Easy-to-Use Microsoft Dynamics.

Data & Databases

Data & Databases



Occasionally Connected Systems Architecture: Concurrency
10/16/2007
by Udi Dahan - When designing systems that support users who need to work offline, one of the challenges developers face is how to deal with concurrency problems when these users re-connect and synchronize their data with the server. Explore patterns for conflict identification and resolution in the first of this series on Occasionally Connected Systems Architecture.

Applying Business Rules—Here or There?
09/05/2007
By William R. Vaughn - Decide where to implement your business logic.

Stitching Up Time Zones
08/20/2007
Performing brain surgery on the Registry need not be fatal.

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



.NET Tip: Type Casting and Comparison Using "as" and "is"
Rating: none
Jay Miller - 09/28/2007
Use some of the language's lesser known features for safe type casting and comparison.

Creating a Data-Bound Grid in C# with ADO.NET
Rating: none
Irina Medvinskaya - 04/09/2007
Learn the basics of using ADO.NET in C# applications and utilizing a Data Grid control to display the data returned by the query.

Custom DataGrid With Next, Previous, First, Last, and Numeric Paging
Rating:
saifi hasan - 01/31/2007
Learn how to create a custom DataGrid with previous, next, first, and last paging along with numeric paging.

Concurrent Model in ADO.NET
Rating: none
Michael Milonov - 01/08/2007
The most popular database instrument for .NET applications is ADO.NET. This set of components contains three main classes used to manipulate and store data: DataReader, DataSet and DataAdapter. Learn about their main restrictions and popular ways to solve them.

Add, Edit, and Delete in DataGridView
Rating:
Jayant Kulkarni - 12/29/2006
Discover the simple steps to add, edit, and delete records from DataGridView by using the SqlCommandBuilder and SqlAdapter objects. You'll also see some of the features of asynchronous programming.

Building an ASP.NET 2.0 Master/Detail Application with DB2
Rating:
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:
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



Building a BizTalk Pipeline Content Enricher with SQL Server 2005
Rating:
Jeffrey Juday - 11/05/2007
Learn how to implement the Content Enricher integration pattern using BizTalk 2006 R2 and SQL Server 2005.

Implementing a Custom ConnectionString Installer for Setup
Rating: none
Paul Kimmel - 10/10/2007
See how a setup project with a custom action lets the user define the connection string using the Data Links dialog and encrypt that connection string using RSA encryption.

Business Data Catalog in Microsoft Office SharePoint Server 2007: Architecture and Schemas
Rating: none
Gustavo Velez - 10/03/2007
Microsoft Office SharePoint Services (MOSS) 2007 introduces a mechanism to integrate back-end systems and Line of Business processes with the Portal infrastructure, bringing external data inside the Portal.

The Basics of Manipulating File Access Control Lists with C#
Rating: none
Jani Jarvinen - 09/26/2007
Learn about file access control lists and how to use C# to read and modify them to improve the security of your applications and your IT infrastructure.

SqlProcessor
Rating: none
cigsmh - 09/12/2007
This class can work with any database that supports ADO.NET and saves a lot of code writing.

BizTalk Pipeline Dreams Become Reality
Rating: none
Jeffrey Juday - 08/16/2007
Learn how to more easily extend, re-use, and configure a BizTalk Custom Pipeline Component.

Connecting to Oracle or Access from ASP.NET 2.0
Rating: none
Devin Rader and Bill Evjen - 04/25/2007
Discover how to use the ASP.NET 2.0 SqlDataSource and AccessDataSource Controls to work with Oracle and Access data from Wrox Professional ASP.NET 2.0 Special Edition authors Bill Evjen and Devin Rader.

SQL Server 2005: Creating Scalar User-Defined Functions from Assemblies
Rating: none
Robert Vieira - 04/11/2007
Learn some of the differences between SQL stored procedures and scalar functions in .NET code from Wrox Professional SQL Server 2005 Programming author Robert Vieria.

Database Tip: Managing Transactions with a Stack
Rating: none
Eric Smith - 03/12/2007
In development scenarios where you make multiple changes to the database, consider using transactions and, optionally, nesting transactions.

.NET Tip: Compressing/Decompressing Your Files
Rating: none
Eric Smith - 03/02/2007
One of the many new libraries included with .NET 2.0 allows for compression and decompression of files using the gzip file format. Find out how to use it.

User Profiles and Audience Targeting in SharePoint 2007
Rating: none
Sahil Malik - 02/14/2007
Organizations struggle with communicating only relevant information to its members, especially when that information lives in disparate systems that do not talk to each other. SharePoint 2007 provides an answer with user profiles and audience targeting.

A BizTalk Administration Solution for Real-Time Data Warehousing
Rating: none
Jeffrey Juday - 02/09/2007
Designing an administration solution for your real-time data warehouse is important to the long-term success of your BizTalk solution. Picking a platform your users are comfortable with is a good start.

Recursive XSL Templates
Rating: none
kirang - 01/09/2007
Learn about the recursive nature of call templates.

The Only Data Access Layer You'll Ever Need?
Rating:
Paul Kimmel - 12/20/2006
A useful data access layer (DAL) makes managing persistence easier than writing CRUD behaviors all over your code. Learn to build a flexible, simple one that does just that with a relatively few lines of code.

Many-to-Many Relationships in O/R Mapping
Rating: none
Iqbal M. Khan - 11/13/2006
If you are developing an object-oriented .NET application that has to talk to a database, you'll inevitably map objects to a relational model. And, most likely, you'll face situations where many-to-many relationships exist in your database. Learn how to handle these situations with ease.

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



Controls that Are Datasource Bound
Rating: none
Xun Ding - 11/15/2006
Take a close look at the new features available in ASP .NET databound controls, such as BulletedList and GridView. Also, learn the simple steps to perform common database operations such as paging, sorting, and editing, as well as how to create master/detail page using the Gridview control.

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.


Is it time to make your move to the multi-threaded and parallel processing world? Find out!
Free iPod Touch? Join Internet.com and Get a Chance to Win Yours.
Whitepaper: Elementool Bug Tracking--Keep Software Fixes On Course.
Microsoft Dynamics: ERP Software Your People Can Actually Use. Try It Out Free.
Article: Interoperability and Migration from Java to .NET

Access FREE HP Printing Tools:
Whitepaper:
The Top Five Most Common Hidden Infrastructure Costs
Whitepaper:
End-to-end Strategies for Reducing Imaging and Printing Costs
Whitepaper:
Putting a Price on Document-based Business Processes
Whitepaper:
How HP Helps IT, Facilities and Purchasing Do More for Less Together


JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info