Database Tutorials & Articles
-
SQLX
by Edward CarsonSQLX, sometimes refered to as SQL/XML, is an emerging standard that specifies a syntax for returning result sets from relational databases as XML.
-
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.
-
Beating the performance gremlins
by Harry FloraHarry Flora has got some advice for you about how to deal with the unknown forces that can wreck your database’s performance.
-
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
-
.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!
-
Accessibility for Web Developers
by Gez LemonDevelopers put a lot of effort into ensuring their sites can be viewed in outdated browsers, but all too often ignore newer browsers, or worse still, a whole range of visitors. Accessibility means access to information for all. Information to all, regardless of the device used to view the document, or abilities of the visitor. This article covers the W3C guidelines for making your site accessible - a legal requirement for companies in the UK and United States.
-
MySQL Tutorial
by Gez LemonAn introduction to using MySQL, from creating databases to modifying tables to creating and deleting rows.
-
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.
-
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.
-
A Twisted Look at Object Oriented Programming in C#
by Jeff LouieAn extensive examination of OO programming in C#, covering inheritance, constructors, interfaces, virtual and static methods, and much more.
-
User-defined SQL Server operations
by Kay EwbankSQL Server's user-defined functions open up a new realm of possibilities, but there are pitfalls for the unwary.
-
Web Forms DataGrid and DataSet Programming
by Jeff LouieThis is a working C# .NET program that demonstrates how to integrate most of the features of the DataGrid and DataSet in a single project including select, insert, update, delete, confirm delete, sort, filter and page.
-
A complete banner advertising system
by James ShawJames Shaw takes you through his complete in-house banner advertising system, from serving the ads, counting the click-thrus and generating the statistics!