ADO.NET Tutorials & Articles
-
Using SqlBulkCopy for high performance inserts
by Mike GoatlyIn the age of Object Relational Mapping frameworks (ORMs) it seems unusual to ever get 'close to the metal' when it comes to persisting data. However, when you need to squeeze the last ounce of performance out of your app - it can make sense to go under the covers.
-
Concurrency handling techniques in ADO.NET
by Joydip KanjilalJoydip Kanjilal looks at the problems caused by concurrency when accessing data, both online and offline, and how to overcome them.
-
High-Performance .NET Application Development & Architecture
by Dimitrios MarkatosThis article demonstrates the art of creating and architecting high-performance and scalable .NET applications, covering all stages, from planning to development and their perspective best practices.
-
What's new in System.Xml 2.0
by Alex HomerJust as XML itself has evolved, so the XML related classes in .NET Framework 2.0 have changed. Alex Homer finds out what's different.
-
DataGrid/GridView Paging and Sorting Using A DataReader
by Dimitrios MarkatosThis article will demonstrate two ways one could implement the DataReader to bind a DataGrid, that includes caching, paging and persistent bi-directional sorting, all without the use of a DataAdapter/DataSet at all, and includes ASP.NET 2.0 GridView version!
-
Selecting, Confirming & Deleting Multiple Checkbox Items In A DataGrid/GridView - Part 2: Maintaining CheckBox State Acr
by Dimitrios MarkatosIn this article, we will examine how to create a fully functional DataGrid and GridView in .NET 2.0 with all the features you'd find set up on Hotmail, Yahoo, and AOL Mail, and further demonstrate how you can multi-select items across pages and batch delete them all.
-
Filtering and Sorting in ADO.NET
by Martin ZahnADO.NET supports many ways to manage memory-resident data returned in a DataSet. This example demonstrates how to use the additional functionality exposed by ADO.NET to sort and filter data.
-
Retrieving HTTP content in .NET
by Rick StrahlThis article discusses the .NET WebRequest and WebResponse classes used to retrieve HTTP content over the Web in detail. In the process a number of related .NET development issues are described including stream handling, string encoding, using delegates, implementing events and creating new threads to run HTTP requests simultaneously.
-
Using MySQL with .NET
by cardinals33Ever wanted to combine the power and ease of the .NET platform with a free database like MySQL? Well thanks to ODBC database functions in ADO.NET it's really easy. This article shows how.
-
Selecting, Confirming & Deleting Multiple Checkbox Items In A DataGrid (i.e. HotMail & Yahoo)
by Dimitrios MarkatosIn this article, we will examine how to create a fully functional DataGrid with all the features you'd find set up on Hotmail or Yahoo. As an added bonus we'll be performing all of our data tasks strictly utilizing Microsoft's new Data Access Application Block or DAAB v2.
-
Introducing a post-relational database for .NET
by John SasakThis is a step by step guide for a post-relational database for .NET, Matisse. The article is aiming at helping developers quickly evaluate this alternative solution as .NET database when they face problems of productivity, flexibility, extensibility, or maintainability.
-
Using ADO.NET with SQL Server
by James CrowleyAn extensive examination of using ADO.NET to access SQL Server databases, from establishing connections and executing stored procedures, to connection pools, data readers and data sets.
-
In Depth ASP.NET using ADO.NET
by John GodelIn this article we will discuss a number of ways to retrieve, show, and update data with ASP.NET forms using ADO.NET. Also, we will have a clear idea about the most common server controls in ASP.NET. In particular, with this article we will cover ASP.NET server controls, ADO.NET DataSource, and creating Templated DataBound Controls, ASP.NET forms, using data with controls. John Godel
-
An Introduction to VB.NET and Database Programming
by Chas ProfittI am a beginner. I wanted to share some experiences with other beginners. The next few articles that come from my keyboard will be about my experience with teaching myself to develop applications in VB.NET.
-
Introduction to Microsoft's .NET Platform
by Nakul GoyalASP.NET is not just another upgrade or the next version of ASP. It is a unified web development platform that provides necessary services for developers to build Enterprise Web based Applications. ASP.NET allows you to use a full featured programming language such as C# or VB.NET to build web applications easily.
-
Building XML Web Services Using C# and ASP.NET
by James YangThe term web service has been used quite frequently lately: you hear people saying how good web services are and how they will dominate the future of software development, but what exactly are web services and how can we create them? In this article James shows us how to build two web services and also unravels all of the lingo surrounding web services.
-
Creating a database connection
by Tony HoCreating connections and all your data objects are really easy Design-Time, but what if you need it for runtime? Here's how.
-
Using ADO.NET, XML & XSL to generate HTML
by Bill BurrisAutomate you website updates to avoid hours of tedious work with your HTML editor.
-
SMTP Mailing Application
by Mike GoldThis is an article on how to use the Mail Components in .NET to create a simple application to send e-mail.
