Nesting Transactions with a Single SQL Server Database 01/23/2008 By Jani Järvinen - Learn to nest your ADO.NET 2.0 transactions correctly with the TransactionScope class, and see how this information can be used with SQL Server databases.
Dependency Injection with Spring.Net 01/22/2008 By David Consdorf - Take a look at Spring.Net—a framework aimed at providing infrastructural support—and see how it implements the concept of Dependency Injection, otherwise known as Inversion of Control.
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.
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.
.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.
Using Stored Procedures and Parameters.AddWithValue
Rating: none Paul Kimmel - 07/25/2008 Developers working at all levels of experience can take advantage of this technique. Discover how to invoke a stored procedure with parameters using the AddWithValue method of the SqlParameterCollection to define SQL parameters in one step.
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.
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.
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.
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.
Sorting and Iterating Using the Task Parallel Library and PLINQ to Go Parallel
Rating: none Jani Järvinen - 06/30/2009 With more and more computers using a multi-core processor, the free lunch of increased clock speeds and the inherent performance gains are over. Software developers must instead make sure their applications take use of all the cores available in an efficient manner. New features in .NET 4.0 mean that managed code developers too can join the party.
Building Microsoft Oslo Models
Rating: none Jeffrey Juday - 12/18/2008 Learn modeling and M development with the Oslo CTP SDK.
Exploring the Oslo Repository
Rating: none Jeffrey Juday - 12/08/2008 Walk through examples and see how existing Repository models are constructed using the M language, how the models are stored in a SQL database, and how to query the SQL database for model information.
.NET Tip: Using a Nullable Value Type
Rating: none Jay Miller - 10/03/2008 Discover how to use nullable types when retrieving data from your database.
Auditing in SharePoint 2007
Rating: none Gustavo Velez - 06/27/2008 Careful registration of information in a Portal can be vitally important to a company, not only internally but also for possible juridical consequences. SharePoint 2007 has the necessary infrastructure to gather and conserve the entries in a secure way.
Working with the XML Data Type of SQL Server
Rating: none Bipin Joshi - 06/25/2008 Store XML data directly in SQL Server. Use the power of the XML data type to store and manipulate XML data efficiently and easily.
A Database Driven Reporting Application
Rating: none Chi-Wei Wang - 06/16/2008 Discover how reporting applications can adapt to changing reports by shifting its report-related information into a database.
Leveraging Content Types in SharePoint Document Libraries and Lists
Rating: none Daan De Brouckere and Raj Agarwal - 06/04/2008 Many organizations are not fully realizing the power of content types when using SharePoint. Here you will learn how to leverage content types and use them properly through examples.
Using Connection Pooling in ADO.NET
Rating: none Bipin Joshi - 02/25/2008 Learn how ADO.NET connection pooling works and how to configure it to suit your performance requirements.
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.
The Basics of Manipulating File Access Control Lists with C#
Rating: none Jani Järvinen - 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.
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.
.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.
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.
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 [Updated] Doing In-Place Editing in a GridView
Rating: Jay Thakar - 09/25/2009 Discover a different way to look at EditItemTemplate — using which user navigation for editing is reduced and ... it looks very different then regular implementation of GridView.
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.
All
