05 June 2007 22:13
The built-in functions @@Identity and Scope_Identity() are designed to retrieve the most recently added record's autoincrement identity value from Access and Sql Server respectively. Here are some usage examples.
03 June 2007 22:56
The user has gone to the trouble of selecting a list of checkboxes to indicate their choices. Now you need to re-present their selections so that they can edit them. How do you make sure the correct checkboxes are ticked?
29 May 2007 12:37
Some basic file and folder management tasks that require the use of classes inside System.IO
28 May 2007 21:18
A Cheat Sheet containing the VBScript string functions and their equivalent methods in C#.
24 May 2007 22:01
The is a brief overview of the main classes and methods in the System.Text.RegularExpressions namespace. It doesn't cover Regex patterns in any real depth at all, but gives an introduction to the power of regular expressions using C#.
21 May 2007 21:38
Two classes in the System.Net namespace make it very easy to obtain the html of a remote web page. These are the HttpWebRequest and HttpWebResponse. Here's a quick demo.
20 May 2007 20:21
Examples of splitting strings into arrays using C# and VB.Net, both with the String.Split() method, and the Regular Expressions Split() method.
19 May 2007 20:36
Cheat sheet for C# regular expressions metacharacters, operators, quantifiers etc
16 May 2007 10:06
For the main part, the DataSource controls are incredibly easy to work with. You just drag them onto your page in Design View, wire them up to a connection and provide some kind of command (ad hoc sql query or the name of a stored procedure - saved query in Access), then link them to a databound control on the page using its DataSource property. Then you run the page and all your data appears. But what if you want to get at one or more values from the returned data to do something else with it, like display it in a control that doesn't expose a DataSource property?
14 May 2007 08:44
Metacharacters for use with VBScript regular expressions
12 May 2007 22:54
A number of useful functions for accessing various properties and values of form fields.
11 May 2007 22:35
Using ADO.NET to pull data from the Northwind database (Access version), using the saved query Current Product List.
10 May 2007 22:53
Using ASP.NET to send the contents of a form by email is a common requirement. This sample looks at generating an email using System.Net.Mail in both plain text and html format from a very basic Contact Us form.
08 May 2007 17:32
06 May 2007 23:29