Items By Type: Tutorial

Customising a ListControl's DataTextField value

06 July 2007 12:19

ASP.NET 2.0 ASP.NET Web Forms

The DataTextField property is used with ListControls - RadioButtonList, CheckBoxList etc to specify a field in the DataSource property to display as the items of the list in the list control. Sometimes, however, you don't want just the value from one database field to appear in the list, and there are a couple of ways to achieve this, depending on what you want to do.

Click to read more about Customising a ListControl's DataTextField value ...

Getting the identity of the most recently added record

05 June 2007 22:13

SQL SQL Server Express MS Access ADO.NET

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.

Click to read more about Getting the identity of the most recently added record ...

Saving a user's CheckBoxList selection and re-populating the CheckBoxList from saved data

03 June 2007 22:56

ASP.NET 2.0

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?

Click to read more about Saving a user's CheckBoxList selection and re-populating the CheckBoxList from saved data ...

C# Regular Expressions - the basics

24 May 2007 22:01

C#

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#.

Click to read more about C# Regular Expressions - the basics ...

Programmatically accessing data from DataSource controls

16 May 2007 10:06

C# ASP.NET 2.0 ADO.NET

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?

Click to read more about Programmatically accessing data from DataSource controls ...

ASP.NET and Ajax - using XmlHttpRequest

08 May 2007 17:32

ASP.NET 2.0 AJAX Javascript

If you are not interested in using the ASP.NET AJAX library offered for ASP.NET, but would like to feature small amounts of AJAX functionality on your pages, you can do this easily with some javascript and a receptive page.

Click to read more about ASP.NET and Ajax - using XmlHttpRequest ...

Parameter Queries in ASP.NET with MS Access

13 April 2007 22:17

ASP.NET 2.0 MS Access ADO.NET

A selection of code samples for executing queries against MS Access using parameters.

Click to read more about Parameter Queries in ASP.NET with MS Access ...

Paging long articles in ASP.NET using C#

09 April 2007 21:44

C# ASP.NET 2.0

Long articles are better broken into bite-sized chunks over several pages. With static HTML, this is easily achieved by dividing the article into logical separations and creating separate .htm files for each. Here's how to do it using C# for an article that gets posted to a database.

Click to read more about Paging long articles in ASP.NET using C# ...

Regular Expressions and VBScript

09 April 2007 12:42

Classic ASP VBScript

Regular Expressions provide a much more powerful and efficient way of manipulating strings of text than the use of a variety of standard string functions. They have a reputation of being cryptic and difficult to learn, but are actually quite easy to learn and use.

Click to read more about Regular Expressions and VBScript ...

Create A Utility Class Containing Site-Wide Functions

03 April 2007 21:33

C# ASP.NET 2.0

In Classic ASP, the typical model for managing site-wide functions is to create one or more server-side includes containing libraries of code. The OOP nature of ASP.NET offers a much more elegant solution.

Click to read more about Create A Utility Class Containing Site-Wide Functions ...

How can I use ASP.NET to do the following

01 April 2007 16:10

ASP.NET 2.0

A list of common things that people want to be able to use ASP.NET for on the client-side.

Click to read more about How can I use ASP.NET to do the following ...

Saved Parameter Queries with MS Access and ASP

31 March 2007 21:19

Classic ASP VBScript MS Access

Protecting your application against SQL injection and easier debugging are just two of the benefits of using saved parameter queries in MS Access.

Click to read more about Saved Parameter Queries with MS Access and ASP ...

ADOX, MS Access and ASP

31 March 2007 19:55

Classic ASP VBScript MS Access

You don't need MS Access installed on your computer to create a database file for your ASP web site. Using ADOX and some data definition language allows you to produce an mdb file programmatically.

Click to read more about ADOX, MS Access and ASP ...

Paging long articles in Classic ASP

31 March 2007 17:46

VBScript

Long articles are better broken into bite-sized chunks over several pages. With static HTML, this is easily achieved by dividing the article into logical separations and creating separate .htm files for each. Here's how to do it using ASP for an article that gets posted to a database.

Click to read more about Paging long articles in Classic ASP ...