SQL Server Tutorials & Articles
-
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.
-
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.
-
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.
-
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.
-
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.
-
.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.
-
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.
-
Uploading Images to a Database
by Dave WantaLearn how to allow a user to upload an image to your server and store the binary data in a Microsoft SQL database.
-
Encapsulating ODBC in ASP .NET
by Jason G. WilliscroftHotQuant, LLC, builds on their previous ODBC article by demonstrating how to use encapsulation to isolate an application's data access layer and significantly streamline the code.
-
Identifying Your New Records
by Bruce JohnsonWhile the use of AutoNumber and Identity fields in tables is greatly applauded by database designers the world over, they can be annoying for developers to use. This article reveals two techniques for retrieving the value of an AutoNumber/Identity field.
-
Implementing ODBC in ASP .NET
by Jason G. WilliscroftWith Microsoft's ODBC data server controls, .NET finally supports ODBC... but not very well. HotQuant, LLC, has published an in-depth technical article demonstrating an effective workaround.
-
Using Triggers to track database action history
by Super TalTal Kelley demonstrates how to use triggers in SQL Server in order to keep track of who is modifying your database tables.
-
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.
-
Remote Scripting With JavaScript and ASP
by Mitchell HarperRemote scripting is an extremely powerful feature available in both Netscape Navigator and Internet Explorer. It allows us to use a combination of scripting languages to call server side ASP code from the client using JavaScript. In this article Mitchell shows us how to install remote scripting as well as two examples of using it to interact with ASP scripts using client-side JavaScript code.