A collection of articles and tutorials on web development with ASP.NET by Mike Brind

Latest Entries

An ASP.NET Search Engine with MS Access for optional search criteria

12 November 2007 15:15

ASP.NET 2.0 MS Access ADO.NET ASP.NET Web Forms

Creating a search interface for one user-supplied value is pretty straightforward: a TextBox for input, a Button and some SQL that searches one or more fields where the values are LIKE '%' + @searchterm + '%' is all that is needed. While it works, this approach is not very flexible. For example, what if you wanted to search for an Employee whose last name contains "a", and don't want those where the first name or city contains "a"? The traditional solution to this is to dynamically construct the SQL statement based on what values were passed by the user. However, building the SQL string can get repetitive, boring and messy. Here is a cleaner way to allow the user to narrow down searches across multiple criteria with the use of optional parameters, and just 3 lines of programming code.

Click to read more about An ASP.NET Search Engine with MS Access for optional search criteria ...

Viewed 28872 times

4 Comments for this item

Reading Text files into Access with ASP.NET

09 September 2007 21:20

MS Access ADO.NET

The Jet 4.0 OLEDB driver is a remarkable beast. Not only will it allow connections to MS Access .mdb files and MS Excel spreadhseets, but it will also allow you to connect to and query a variety of text file formats. Here are some examples that illustrate this capability when applied to importing text based data into Access.

Click to read more about Reading Text files into Access with ASP.NET ...

Viewed 47270 times

5 Comments for this item

Referencing CheckBoxes in GridView, Repeater and DataList controls

30 August 2007 10:29

ASP.NET 2.0 ASP.NET Web Forms

If you want to find which CheckBoxes were selected in a multiple record DataBound control, the way that you you do it depends on the type of control you use. These examples demonstrate a CheckBox control being added to a GridView, Repeater and a DataList. For simplicity, I have placed all three controls on the same page, and used the Access version of theNorthwind database. One AccessDataSource control is used to bind the results of "SELECT [CategoryID], [Description], [CategoryName] FROM [Categories]" to all three controls.

Click to read more about Referencing CheckBoxes in GridView, Repeater and DataList controls ...

Viewed 76561 times

6 Comments for this item

ViewState, form fields, labels and Javascript

25 August 2007 12:34

ASP.NET 2.0 Javascript ASP.NET Web Forms

An interesting question came up on the ASP.NET forums asking why a TextBox which has its value changed by client-side Javascript persists those changes across postbacks, while a Label does not. And in a nut shell, this question covered two of the biggest causes of confusion among newcomers to ASP.NET: the difference between ViewState and IPostBackDataHandler; and the difference between client-side operations and server-side operations.

Click to read more about ViewState, form fields, labels and Javascript ...

Viewed 59174 times

5 Comments for this item

Bind Data From a SqlDataSource to a Label

25 August 2007 10:32

ASP.NET 2.0 ADO.NET ASP.NET Web Forms

Label controls in ASP.NET don't have a smart tag that allows you to select a data source, so at first glance, it is not easy to see how to bind a value returned from a SqlDataSource or AccessDataSource control to the label. Here's how to programmatically access the data returned by such a DataSource and apply it to a non-databound control.

Click to read more about Bind Data From a SqlDataSource to a Label ...

Viewed 228414 times

32 Comments for this item

Consuming RSS feeds in an ASP.NET page

18 August 2007 23:12

ASP.NET 2.0 ASP.NET Web Forms

I like reading Scott Guthrie's blog. Trouble is, I get so busy, I forget to go over there and have a look to see what's new. I was searching for something the other day, and stumbled across someone else's blog (I forget whose), but I noticed that they had the 5 most recent items in Scott's blog embedded in their home page. It was only then that I discovered that Scott Mitchell has written a whole load more tutorials on Data Access, and that these have been available for a while. So I got to thinking that I should add a feed from Scott G's site onto the home page here, so I can be updated more quickly. Here's the bare bones of how I did it.

Click to read more about Consuming RSS feeds in an ASP.NET page ...

Viewed 13798 times

1 Comment for this item

Debugging Classic ASP pages in Visual Studio 2005 on Windows XP Pro

17 August 2007 10:28

Classic ASP Visual Studio

As an ardent Dreamweaver user for classic ASP, I used to debug my scripts with a plethora of Response.Write and Response.End statements, outputting the values of various values to the browser to check that logic was working as intended. However, I recently discovered how to use the VS 2005 debugger to make debugging classic ASP (almost) a joy.

Click to read more about Debugging Classic ASP pages in Visual Studio 2005 on Windows XP Pro ...

Viewed 20858 times

2 Comments for this item

List the contents of a folder and link to each file

10 August 2007 21:33

ASP.NET 2.0

Iterating the contents of a folder is straightforward using classes from System.IO, and listing them as links to the actual file just requires a bit of html added to each file name.

Click to read more about List the contents of a folder and link to each file ...

Viewed 28030 times

2 Comments for this item

Exporting data to a CSV, tab delimited or other text format

02 August 2007 23:41

ASP.NET 2.0 ADO.NET

A question that often comes up in forums is how to export data to a CSV file, or other text format. Here's a method that takes data from a DataReader and writes it to a file.

Click to read more about Exporting data to a CSV, tab delimited or other text format ...

Viewed 55199 times

4 Comments for this item

Displaying One-To-Many Relationships with Nested Repeaters

27 July 2007 14:24

ASP.NET 2.0 ADO.NET ASP.NET Web Forms

This item could also have been entitled "Displaying Master-Detail Data" or "Displaying Categorised Data", but the principal is the same: you have what are essentially headings or categories, and a group of entries that belong to each heading that you want to display. Typical examples would include the Models of cars by Manufacturer, or Employees by Department. Here's how to do it quite simply using nested Repeaters.

Click to read more about Displaying One-To-Many Relationships with Nested Repeaters ...

Viewed 55126 times

4 Comments for this item

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

Viewed 10104 times

0 Comments for this item

A more efficient RSS feed with C#

06 June 2007 23:15

C# ASP.NET 2.0

The contents of an RSS feed only change when items that appear in it are added or amended, so the feed created in the previous article (Create an RSS Feed In ASP.NET 2.0 C#) is rather inefficient, in that the output is generated everytime the feed is requested. Here's an improvement.

Click to read more about A more efficient RSS feed with C# ...

Viewed 15039 times

0 Comments for this item

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

Viewed 411795 times

46 Comments for this item

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

Viewed 105738 times

11 Comments for this item

Recent Comments

Pam 30/08/2017 11:30
In response to Sending Email in Razor Pages
Mike, RazorPages sound like a nice choice for somebody still working in ASP classic who wants to to...

Robby Robson 15/08/2017 00:43
In response to Routing in Razor Pages
Mike: great stuff. Now that .Core Standard 2.0 is formally out, how soon will you rewrite your book...

Satyabrata Mohapatra 28/07/2017 08:59
In response to Sending Email in Razor Pages
Bit off topic, but congratulation sir for your MVP award. You deserve it !!!...

Satyabrata Mohapatra 23/07/2017 16:43
In response to Razor Pages - The Elevator Pitch
@Dale Severin You can continue to build apps using asp.net web pages....

Satyabrata Mohapatra 23/07/2017 16:40
In response to Sending Email in Razor Pages
Thanks for sharing...learned a lot...

Gfw 22/07/2017 11:53
In response to Sending Email in Razor Pages
Question... Does System.Net.Mail support SSL?...

Dale Severin 20/07/2017 03:38
In response to Razor Pages - The Elevator Pitch
I work with razor web pages extensively. I appreciate the rapid development it permits me to I am as...

Obinna Okafor 14/07/2017 01:19
In response to Routing in Razor Pages
Thank you, Mike. Good post....

Satyabrata Mohapatra 11/07/2017 16:02
In response to Routing in Razor Pages
Very powerful routing system!!...

Cyrus 05/07/2017 03:41
In response to Razor Pages - Getting Started With The Preview
How can I trim packages and services as much as possible to use just razor pages? I don’t want to to...