SQL Tutorials & Articles
-
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.
-
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.
-
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.
-
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.
-
Replicating GetRows in .NET
by Dimitrios MarkatosDimitrios explains how replicating GetRows in .NET is easy and shows how it offers precise control of the details of the data and its display.
-
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.
-
Extracting the Country from the IP Address:- How To?
by Amit GuptaGet to know from where the visitors to your website are coming. Amit shows you how you can know the Country of a visitor through his IP Address without using COM.
-
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.
-
.NET Data Caching
by Dimitrios MarkatosAn introduction to using data caching in your ASP.NET pages, from simple time-specific data expiration to file dependencies, plus a real-world example with caching for data in a pagable DataGrid control.
-
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.
-
Reading, Storing and Transforming XML Data in .NET
by Dimitrios MarkatosThis article illustrates a mixture of common .NET methods for formatting and presenting in a readable fashion any XML document you may encounter. The latest hype with XML Web Services and even the .NET Framework itself relies on XML as its backbone, therefore this is no light matter.
-
Custom ASP.NET Datagrid Paging With Exact Count
by Dimitrios MarkatosA demonstration on creating custom DataGrid paging such that we actually know the total number of pages for a result set - something that the default paging for the DataGrid doesn't tell us.
-
Using ADO in C++
by Randy Charles MorinAn introduction to using ADO in C++ - its far simpler than you'd think!