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

Latest Entries

iTextSharp - Adding Text with Chunks, Phrases and Paragraphs

18 October 2008 22:32

C# ASP.NET 3.5 iTextSharp

This is the third in a series of articles that looks at using the open source component, iTextSharp from within ASP.NET to generate PDFs. Just as HTML and ASP.NET provide containers for varying ampounts of textual content, iTextSharp offers the Chunk, Phrase and Paragraph classes. Before going on, if you would like to read earlier articles, they are:

Click to read more about iTextSharp - Adding Text with Chunks, Phrases and Paragraphs ...

Viewed 416575 times

19 Comments for this item

iTextSharp - Working with Fonts

15 October 2008 22:07

C# ASP.NET 3.5 iTextSharp

Following on from my introduction to iTextSharp, the free PDF utility that lets you work with PDF files within ASP.NET, this article looks at working with fonts in PDF documents that you create. If you haven't read the first article in this series, I recommend that you do so now.

Click to read more about iTextSharp - Working with Fonts ...

Viewed 397266 times

30 Comments for this item

Create PDFs in ASP.NET - getting started with iTextSharp

12 October 2008 11:26

ASP.NET 3.5 iTextSharp

The .NET framework does not contain any native way to work with PDF files. So, if you want to generate or work with PDF files as part of your ASP.NET web application, you will have to rely on one of the many third party components that are available. Google will help you to find one that fits your budget, as well as a range of open-source free components. One of the free components is iTextSharp, which is a port of a well known Java utility, iText.

Click to read more about Create PDFs in ASP.NET - getting started with iTextSharp ...

Viewed 535513 times

54 Comments for this item

AccessDataSource, SqlDataSource and connecting to Access databases in ASP.NET

17 May 2008 09:48

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

There are a variety of options for connecting to Access databases within ASP.NET pages. This article attempts to cover the choices and offer recommendations for getting the best out of Access.

Click to read more about AccessDataSource, SqlDataSource and connecting to Access databases in ASP.NET ...

Viewed 102151 times

13 Comments for this item

80040E14 - MS Access Syntax Error messages

01 May 2008 11:06

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

This short article deals with the following common MS Access-related error messages:

Click to read more about 80040E14 - MS Access Syntax Error messages ...

Viewed 33735 times

6 Comments for this item

Simple Login and Redirect for ASP.NET and Access

01 May 2008 10:02

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

Quite often, I see questions asked about creating a simple login page for use with Access from people who don't want to take advantage of the built-in Forms Authentication framework within ASP.NET. The following samples show how relatively easy this is to accomplish.

Click to read more about Simple Login and Redirect for ASP.NET and Access ...

Viewed 374560 times

39 Comments for this item

Solving the Operation Must Use An Updateable Query error

30 April 2008 22:48

ASP.NET 2.0 MS Access ADO.NET ASP.NET 3.5

The unbelievably cryptic Operation Must Use An Updateable Query error is the bane of developers who are just starting out with Access and ASP.NET. You've done your code, plopped your database file in the App_Data folder (or at least, you should have done), and try to run a page that INSERTs or UPDATEs records, and it all stops dead. This brief article explains the cause of the error, and the steps required to stop it recurring.

Click to read more about Solving the Operation Must Use An Updateable Query error ...

Viewed 252648 times

53 Comments for this item

I'm a Microsoft MVP!

05 April 2008 10:26

General

I was delighted to find out on April Fool's Day (?) that I have been awarded the 2008 Microsoft® MVP Award.

Click to read more about I'm a Microsoft MVP! ...

Viewed 5530 times

0 Comments for this item

Sql JOINS and the Sql Server Management Studio Query Designer

28 November 2007 13:19

SQL SQL Server Express ADO.NET

There are a whole bunch of articles, blog entries and tutorials that seek to explain how SQL JOINS work. Some of them are excellent, and others are just confusing. The reason I am adding my go at trying to clarify JOINS to the mix is to highlight how proper use of the tools available to you can seriously reduce the chances of getting the JOIN syntax or type wrong. Since JOINS are all about how to relate data from one table to another, I thought it appropriate to illustrate the subject using Parents and Children (who may, or may not be related to eachother). So let's meet the families.

Click to read more about Sql JOINS and the Sql Server Management Studio Query Designer ...

Viewed 74536 times

8 Comments for this item

Search Engine-Friendly Custom Paging with the GridView and LINQ to SQL

20 November 2007 22:54

LINQ ASP.NET 3.5 ASP.NET Web Forms

The main problem I find with the built-in paging functionality offered by the GridView control is that the paging links are managed by Javascript. This is a bit awkward for people who disable, or don't have Javascript in their browser, but more importantly, the links can't be triggered by search engines. If you rely on the GridView to paginate links to content, this can prove disastrous, and much of your content will be inaccessible to search engines. Motivated by Scott Guthrie's series of blog entries on LINQ to SQL, available in the .Net 3.5 framework, I set about getting some custom paging working with html paging links.

Click to read more about Search Engine-Friendly Custom Paging with the GridView and LINQ to SQL ...

Viewed 54661 times

15 Comments for this item

Migrating from Sql Server to Access in ASP.NET

16 November 2007 10:45

MS Access ADO.NET

Yes, you did read that correctly. Here's the situation: you know that Sql Server is by far the superior database system (if indeed MS Access can be called a database system). You also know that MS Access databases are not recommended as a data store for web applications. You are comfortable with Sql Server, and haven't really looked at Access for years - if at all. But now, your boss or your client wants you to use it in the next project.

Click to read more about Migrating from Sql Server to Access in ASP.NET ...

Viewed 22048 times

6 Comments for this item

How to get your forum question answered - avoid thread-jacking

13 November 2007 12:33

ASP.NET 2.0

If you have just been directed to this page, it may be because you have just thread-jacked. If you are not sure what that means, read on for an explanation, and some guidance.

Click to read more about How to get your forum question answered - avoid thread-jacking ...

Viewed 916623 times

26 Comments for this item

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 28750 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 46909 times

5 Comments for this item

Recent Comments

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

Harris Boyce 04/07/2017 04:17
In response to Razor Pages - The Elevator Pitch
As a developer of a couple "trivial" web pages applications used by non-profits that wouldn't have I...

Cyrus 28/06/2017 20:25
In response to Razor Pages - Getting Started With The Preview
.net core 2.0 preview 2: <a...

ojorma 17/06/2017 09:24
In response to Razor Pages - The Elevator Pitch
Finally I can say goodbye to webforms...