Shoptec VB and SQL articles

Server update without page refresh

support@shoptec.co.uk (Editor) — Sat, 19 Jun 2010 19:23:31 GMT

Allows an end-user to raise an event which allows a server update without a page refresh being necessary.

Find all stored procedures containing a text string

support@shoptec.co.uk (Editor) — Sat, 04 Jul 2009 14:15:53 GMT

A stored procedure to search all stored procedures in a database for a specified text string

Dynamic runtime SEO (Search engine optimization)

support@shoptec.co.uk (Editor) — Thu, 02 Jul 2009 19:13:58 GMT

How to set web page SEO properties at runtime in ASP.net when page content is dynamic

VB6 and Classic ASP Validation Class for UK related objects

support@shoptec.co.uk (Editor) — Mon, 29 Jun 2009 12:12:15 GMT

A compiled class for validation of UK related objects including VAT number, NI number, NHS number, Postcode, Company number, Driver number, UK dates

Data Encryption methods for VB.net and ASP.net

support@shoptec.co.uk (Editor) — Sat, 23 May 2009 23:17:25 GMT

Methods for secure 128 bit encryption and decryption which has many applications

VB.Net and ASP.Net Validation Class for UK related objects

support@shoptec.co.uk (Editor) — Sat, 23 May 2009 23:16:45 GMT

A compiled class for validation of UK related objects including VAT number, NI number, NHS number, Postcode, Company number, Driver number, UK dates

Display random banner ads from a SQL Server table

support@shoptec.co.uk (Editor) — Fri, 22 May 2009 11:02:32 GMT

This article shows how to extract banner ads, held as html in a SQL Server table.

Implement Google Adsense search in an XHTML 1.0 Transitional ASP.net (aspx) page

support@shoptec.co.uk (Editor) — Wed, 20 May 2009 19:00:04 GMT

Explains how to overcome the problem of having two forms in one page; i.e. the default form and the Google search form.

Efficient database storage and retrieval of flags (bit values)

support@shoptec.co.uk (Editor) — Thu, 07 May 2009 16:10:51 GMT

This article shows an efficient and concise method of storing/retrieving flags into/from an SQL table.

Automated Search Engine Sitemap submission

support@shoptec.co.uk (Editor) — Fri, 08 May 2009 11:56:46 GMT

Submit or resubmit a sitemap to the major search engines and optionally confirm receipt. You don't need to rely on others to do this for you.

Preventing SQL Injection attacks in an asp.net application

support@shoptec.co.uk (Editor) — Sun, 26 Apr 2009 12:17:55 GMT

This article describes the main types of SQL Injection attacks and methods to combat them in an ASP.net application

SQL Server table of UK Bank Holidays by Country and Year

support@shoptec.co.uk (Editor) — Sat, 02 May 2009 20:56:06 GMT

SQL Server data and stored procedure to retrieve England, Wales, Scotland and Northern Ireland Bank holidays for the years 2000-2099

Create an internet sitemap using Visual Basic

support@shoptec.co.uk (Editor) — Wed, 08 Apr 2009 19:36:31 GMT

This article shows how to create an internet sitemap xml file using VB6, VB.Net or ASP.Net(VB) which conforms to the required protocol

An effective way to talk to the PayPal API from ASP.Net (VB)

support@shoptec.co.uk (Editor) — Wed, 08 Apr 2009 13:30:20 GMT

Send and receive Paypal nvp data via method calls in an ASP.net (VB) application without leaving the page.

VB code sample to create a valid RSS feed file

support@shoptec.co.uk (Editor) — Tue, 07 Apr 2009 20:02:20 GMT

This article shows a method to easily create an RSS version 2.0 feed file in Visual basic

SQL Server function to handle British Summer time

support@shoptec.co.uk (Editor) — Sun, 05 Apr 2009 11:37:06 GMT

Article describes a SQL Server function that recognises British Summer Time (BST) and converts a utc date to a BST date accordingly

Perform a match or partial match on a table of occupations

support@shoptec.co.uk (Editor) — Fri, 03 Apr 2009 18:28:43 GMT

SQL Server stored procedure and table of occupations. Procedure performs a match or partial match returning list of closest matches.

Validate Companies House reference number in VB6 and VB.net

support@shoptec.co.uk (Editor) — Tue, 31 Mar 2009 11:34:53 GMT

Validates Companies House reference number to UK Government Data Standards Catalogue, version 2.1

Validate an NHS number in VB6 and VB.net

support@shoptec.co.uk (Editor) — Sun, 29 Mar 2009 00:57:43 GMT

Validate an NHS number in VB6 and VB.net to UK Government Data Standards Catalogue, Person identifiers, version 2.0

Correctly validate a UK Driver number in VB6 or VB.net

support@shoptec.co.uk (Editor) — Thu, 26 Mar 2009 17:43:12 GMT

Validate UK Driver number to UK Government Standards Catalogue, Person identifiers, version 2.1

Validate UK National Insurance number in VB6 and VB.net

support@shoptec.co.uk (Editor) — Wed, 25 Mar 2009 11:47:00 GMT

Validate UK National Insurance (NI) number to UK Government Standards Catalogue, Person identifiers, version 2.1

Classify dates within a period

support@shoptec.co.uk (Editor) — Wed, 18 Mar 2009 22:54:03 GMT

A Versatile SQL Server function that allows selection of rows having a date field with a value that falls into a set of 10 different periods

Strict IsDate function for UK format only

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:15:38 GMT

Validate a UK date in VB6 and VB.Net avoiding problems in the built-in IsDate function

Drop and manage list in datagrid cell

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:15:14 GMT

A versatile VB6 code example that handles display and management of dropdown lists from the MS DatGrid

Validate UK postcode in VB6 and VB.net to BS7666

support@shoptec.co.uk (Editor) — Wed, 18 Mar 2009 22:53:52 GMT

Validate UK postcode in VB6 and VB.net to BS7666 Address specification

Generate emails using textfile template

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:15:25 GMT

A VB.net example to generate emails with parameter substitution using templates

Detailed database table audit

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:14:56 GMT

Audit all changes made to a specified SQL Server table with the maximum level of detail

Obtain registration period from Vehicle number plate

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:15:00 GMT

A SQL Server solution that returns a vehicle registration period given the registration plate

Generate Random numbers of any length

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:15:28 GMT

VB6 and VB.net code to generate a random number of a specified number of digits

How to validate a UK VAT number

support@shoptec.co.uk (Editor) — Sat, 28 Mar 2009 10:37:32 GMT

Correctly validate a UK VAT number in VB6 and VB.net

Base 64 encoding

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:15:11 GMT

Convert binary to character data with VB6 using Base64 encoding

URL decode a string

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:15:42 GMT

URL decode a string in VB6

URL encode a string

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:15:45 GMT

URL encode a string in VB6

Lack of mousewheel support

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:15:35 GMT

Improve usability of Visual Studio VB6 by adding mousewheel support for scrolling

Fast export SQL Server table to MS Excel spreadsheet

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:15:18 GMT

Using VB6 for high performance export of SQL Server table to Excel sheet

Use booleans to good effect

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:15:48 GMT

Improve code readability and efficiency with boolean variables in VB6 and VB.net

Fast import Excel sheet to SQL Server table

support@shoptec.co.uk (Editor) — Tue, 10 Mar 2009 14:15:22 GMT

Using VB6 for high performance import of Excel sheet to SQL Server table