SQL Tutorials & Articles
-
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.
-
LINQ to log files
by Jon SkeetRunning LINQ queries over databases gets all the limelight, but Jon Skeet reminds us of it's possibilities over object graphs too.
-
ActiveRecord for Ruby and Rails
by Kevin JonesKevin Jones explains how ActiveRecord works in Rails, and in a standalone Ruby application.
-
New C# 3.0 Language Features
by Scott GuthrieLearn about some of the new features in C# 3.0 including automatic properties, collection initializers, extension methods, lambda expressions and anonymous types.
-
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.
-
VB 6 Tutorial
by James CrowleyCompletely new to Visual Basic? Overwhelmed with the confusing instructions? Read this tutorial and get a head start - learn what VB is, what you can do with it, how much it costs, and how to get star
-
LINQ-ing to XML
by Mike JamesXML, which is all about tree structures, and LINQ, which is all about querying collections, might not seem to fit together, but Mike James explains that they work together just fine.
-
Iterator blocks in C# 2: auto-generated state machines
by Jon SkeetEver wondered how the magic "yield" statement works? Jon Skeet digs into the inner workings of C# 2.0 and how this innocuous statement gets you a whole load of "free" generated code for your iterators.
-
SLOBbing about with .NET
by Dave WheelerPersisting objects is all about SLOB (serialized large objects), or so says Dave Wheeler who explains how it's now all so much easier.
-
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.
-
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.
-
The Next Generation Of Web Development
by James CrowleyWhere is Web Development moving to in the future?
-
Using ADO in C++
by Randy Charles MorinAn introduction to using ADO in C++ - its far simpler than you'd think!
-
Rails MVC and routing
by Kevin JonesKevin Jones thinks that the key idea in Rails is routing. See how this fits in with the MVC pattern and find out more about Rails by reading on.
-
Retrieving Images from a Database
by Dave WantaLearn how to retrieve binary data from a database, and stream it directly to a client via a browser.
-
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.
-
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.
-
SQL Commands
by James CrowleyIf you want to use databases, in VB, Access, ASP or anything else, at some stage you will need to learn SQL. This tutorial shows you how to use this powerful and universal language.
-
Rails: an introduction
by Kevin JonesYou've heard the hype - but not given it a shot yet? Kevin Jones explains the background of MVC, DRY and TDD and how to get started with your first Ruby on Rails web app!
-
Dynamic Search Conditions in T-SQL
by Erland SommarskogA very common requirement in an information system is to have a function (or several functions) where the users are able to search the data by selecting freely among many possible criterias. In this text I will look at various techniques to solve this problem.
