Database Tutorials & Articles
-
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.
-
Image Generation on the FLY using PHP
by Divyesh JariwalaFor developers like Divyesh, one of the most popular features of PHP is real-time image generation. In this article, Divyesh will show you how.
-
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.
-
Microsoft Indexing Service and ASP.NET
by Barry DorransMicrosoft Indexing Service is a service that provides a means of quickly searching for files on the machine. Barry investigates how we can use the indexing service to expose full-text searching in ASP.NET.
-
Creating Applications for Handheld Devices Using eMbedded Visual Basic
by Rob BickelA no nonsense tutorial designed to give Visual Basic developers an insight into developing VB applications for handheld devices such as PDAs.
-
Locking the Door behind You: Hacker Protection for Your Web Applications
by Caleb SimaYour Web applications can be the most important and most vulnerable entry point into your organization, and, as such, ensuring adequate hacker protection in your Web applications can be critical. This article discusses some of the issues.
-
SQL Trusted Connections with ASP.NET
by Barry DorransHard coding passwords into your application or your web site is a bad thing. Barry looks at how we can use trusted connections to provide the authentication we need, without the need for these potential security hazards.
-
Using PHP and IIS to Create a Discussion Forum
by Jayesh JainLearn how to use PHP on windows and IIS to create a basic discussion forum that makes use of a powerful database.
-
Creating tables in HTML
by baillieThis tutorial will take you through the process of creating tables in HTML, from the easy, ones to the more complex.
-
Implementing a template based website
by James CrowleyHow to implement your own template based web site using php
-
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.
-
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.
-
SQL In Simple English
by Kiran PaiKiran Pai introduces the basics of Structured Query Language in an Q & A session
-
LINQ to Objects for the .NET developer
by Mike JamesMike James explains that LINQ isn’t just for SQL programmers but is usable by every .NET developer. Learn how take the power of LINQ queries to your every-day coding through the lowly IEnumerable interface.
-
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.
-
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.
-
ADO Data Control
by Susan HarkinsLearn everything you need to know about using the ADO Data Control
-
ActiveX Data Objects
by TahoniLearn about ADO in VB and ASP, and how to create connectionless recordsets in this tutorial from Tarhoni of Wali Systems Inc.
-
Using SQL Server for ASP.NET session state
by Barry DorransLearn how you can use an alternative session storage method, using SQL Server - very useful if you're running sites across multiple servers, or need session state to persist across application restarts.