Database Tutorials & Articles
-
CLR and SQL Server 2005
by Niels BerglundThe Common Language Runtime within SQL Server 2005 frees programmers to create powerful procedures to manipulate stored data.
-
Generate Thumbnail Images from PDF Documents in .NET
by Jonathan HodgsonThis article presents VB.NET code to create thumbnail images from a directory of Adobe Acrobat PDF documents using the .NET Framework.
-
Leading the database race
by Kay EwbankNew features and tools in SQL Server 2005 – an overview.
-
To SP or not to SP in SQL Server
by Douglas ReillyThe topic of using or not using stored procedures reaches the level of religious fervor in many quarters. Douglas Reilly, a Microsoft MVP, weighs in on the topic with an in-depth analysis.
-
Flying out of the gate with Derby
by Sing LiDerby is a 100% Java open source relational database, and you can’t afford to ignore it.
-
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.
-
Floating-Point in .NET Part I: Concepts and Format
by Jeffrey SaxThe first in a three part series, this article introduces the basic concepts of floating-point arithmetic: number formats, accuracy and precision, and round-off error. It includes an in-depth discussion of the .NET floating-point types.
-
Query Tool to Excel using C# and .NET
by Mike GoldDemonstrates how to use .NET interop to perform an SQL query and then send the results into an Excel spreadsheet.
-
Assessing SQL Server 2005 Express Edition
by Kay EwbankThe new SQL Server 2005 Express Edition is aimed at developers – is it up to the job?
-
Building a Full-Featured Custom DataGrid Control
by Dimitrios MarkatosIn this article, we will demonstrate how you can build your very own Datagrid control component, one that you will be able to customize, and more importantly reuse. Based on this ability, you will then end up with one powerful control that will have many implementations, from which you could learn about creating almost any other types of custom controls.
-
How to access Outlook and post to a blog using C#
by Simon SoanesAn article for all those like Robert Scoble who would like to be able to drag and drop an item to a folder in their Outlook and post it instantly to their Blog. We also briefly cover web services and talking to Outlook.
-
Implementing two-way Data Binding for ASP.NET
by Rick StrahlASP.NET simplifies many things but data binding simple controls like textboxes and checkboxes leaves a lot to be desired. Databinding is one-way only and you end up doing lots of repetitive work to publish your data. In this article I'll show you how simple databinding in .Net works and then show how to create custom controls that implement two-way binding to make short work of creating databound forms.
-
SQL Injection Attacks by Example
by Stephen J. FriedlSteve Friedl takes a look at how your site could be vulnerable to SQL injection attacks - complete with numerous examples - and the action you can take to prevent them.
-
Tree structures in ASP.NET and SQL Server
by James CrowleyTakes a look at how tree structures can be usefully stored in a relational database such as SQL Server, and how to implement web directory-like features such as breadcrumbs.
-
TestTrack Pro 7 in review
by Mike JamesWe put TestTrack Pro 7 through its paces, and find an error tracking system to reckon with.
-
Automated database change management
by Darren Fuller, InnovartisDarren Fuller discusses the need for database change management and problems with current approaches, and examines an automated methodology, the requirements to implement such an approach and describes the benefits that can be realised.
-
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.
-
DB Ghost for SQL management
by Kay EwbankDB Ghost should be of interest to anyone involved in managing changes to SQL Server databases.
-
Database efficiency
by Ingo RammerThree steps for better performing and more scalable database access.
-
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.