SQL Tutorials & Articles
-
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.
-
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!
-
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.
-
Searching articles for hand-picked keywords
by James ShawJames Shaw demonstrates how he implemented a keyword-searching page for his site.
-
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.
-
ADO and Unicode
by David NishimotoHow to use Microsoft ADO to add and update unicode code points stored in an Oracle UTF8 database.
-
DAO 3.6 Library
by Louis RoseLearn how to use MS Access 2000 with VB and the DAO library. Includes a module for handling simple databases.
-
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.
-
XML Strengths & Weakness’ with DOM, ASP & XSL
by Nakul GoyalNakul Goyal introduces the XML technology, and how it can be used in your ASP and Visual Basic programs.
-
Beginning Active Server Pages
by James CrowleyExpand your VB skills to the web - learn how to create Active Server Pages in this extensive tutorial
-
Using SQL-DMO To Backup and Verify a Database
by Carvin WilsonThe SQL Distributed Management objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks using programming and scripting languages. This article shows you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database.
-
SQL In Simple English
by Kiran PaiKiran Pai introduces the basics of Structured Query Language in an Q & A session
