Items by Category on MikesDotnetting

Using Web Pages Helpers in ASP.NET Web Forms

Posted By Mikesdotnetting - 17 November 2010 15:00

Using Web Pages Helpers in ASP.NET Web Forms Love it or loathe it, WebMatrix is here. One of the great things about this new way of developing web sites in ASP.NET is the growing selection of helpers it offers. However, there's nothing to stop you taking advantage of this goodness within your Web Forms application. Here are a couple of ways to get a Razor-based helper to appear in your aspx file.

Filed under: ASP.NET Web Forms ASP.NET Web Pages WebMatrix Razor as Tutorial
Viewed: 36015 times

5 Comments for this item

Classic ASP Include Files in ASP.NET

Posted By Mikesdotnetting - 23 June 2010 07:43

Include files within classic ASP are about the only way to achieve some measure of code-reuse within frameworks that offer little or nothing by way of composition or inheritance. Judging by the number of questions in forums, there are still a lot of people moving across from classic ASP who are puzzled as to how to approach replacing include files within ASP.NET. A number of articles illustrate individually how to do so for site-wide layout reasons, including widgets, reusing global functions, or actually including the content of a file. However, I haven't been able to find one resource that brings all these together, hence the purpose of this article.

Filed under: Classic ASP ASP.NET Web Forms as Tutorial
Viewed: 33539 times

2 Comments for this item

Highlighting Keywords Found In Search Results

Posted By Mikesdotnetting - 22 May 2010 19:41

A common question in the forums is how to highlight key words found in search results. Here's an extension method that does that, both for partial matches, or whole word matches.

Filed under: C# ASP.NET 3.5 Extension Method ASP.NET Web Forms as Snippet
Viewed: 8721 times

3 Comments for this item

Storing Files and Images in Access with ASP.NET

Posted By Mikesdotnetting - 06 December 2009 19:46

Should you store files and images in the database or the filesystem in an ASP.NET application? With SQL Server this is a dilemma, with both approaches having their pros and cons. When it comes to Access, the decision is much easier to make. Because an Access database is restricted to 2Gb, it makes more sense to store files in the file system. However, sometimes, you may not have the choice. If you have to use the database, here's how.

Filed under: MS Access ASP.NET 3.5 ASP.NET Web Forms as Tutorial
Viewed: 19646 times

7 Comments for this item

Simple File Download Protection with ASP.NET

Posted By Mikesdotnetting - 25 November 2009 09:09

When it comes to protecting files from unauthorised downloading, the vast majority of articles offer solutions that involve mapping common file types (.pdf, .txt, .doc etc) to ASP.NET within Internet Information Services. However, often in a shared hosting environment, you don't have access to IIS and the hosting company will not agree to providing such mappings for you, so what do you do?

Filed under: ASP.NET 3.5 ASP.NET Web Forms as Tutorial
Viewed: 52084 times

22 Comments for this item

Handling JSON Arrays returned from ASP.NET Web Services with jQuery

Posted By Mikesdotnetting - 10 January 2009 09:09

There appear to be many articles showing how to use jQuery with ASP.NET Web Services around, but the vast majority of them illustrate the use of PageMethods that return a single value - typically "Hello World!" or the current date and time. Not much use in the real world, where you may more often need to call a service that returns a collection of complex objects. Here are a couple of examples that look at playing with more than just simple values.

Filed under: AJAX Javascript ASP.NET 3.5 jQuery ASP.NET Web Forms as Tutorial
Viewed: 170318 times

29 Comments for this item

Import Data From Excel to Access with ASP.NET

Posted By Mikesdotnetting - 09 July 2008 09:19

Building on my previous article on importing text files of various formats to an Access database, here's how to do the same thing simply and efficiently with Excel files.

Filed under: ASP.NET 2.0 MS Access ADO.NET ASP.NET Web Forms as Tutorial
Viewed: 48360 times

15 Comments for this item

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

Posted By Mikesdotnetting - 17 May 2008 09:48

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.

Filed under: ASP.NET 2.0 MS Access ADO.NET ASP.NET Web Forms as Tutorial
Viewed: 56367 times

10 Comments for this item

80040E14 - MS Access Syntax Error messages

Posted By Mikesdotnetting - 01 May 2008 11:06

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

Filed under: ASP.NET 2.0 MS Access ADO.NET ASP.NET Web Forms as Tutorial
Viewed: 17339 times

6 Comments for this item

Simple Login and Redirect for ASP.NET and Access

Posted By Mikesdotnetting - 01 May 2008 10:02

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.

Filed under: ASP.NET 2.0 MS Access ADO.NET ASP.NET Web Forms as Tutorial
Viewed: 133145 times

32 Comments for this item

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

Posted By Mikesdotnetting - 20 November 2007 22:54

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.

Filed under: LINQ ASP.NET 3.5 ASP.NET Web Forms as Tutorial
Viewed: 38519 times

15 Comments for this item

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

Posted By Mikesdotnetting - 12 November 2007 15:15

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.

Filed under: ASP.NET 2.0 MS Access ADO.NET ASP.NET Web Forms as Tutorial
Viewed: 19069 times

2 Comments for this item

Referencing CheckBoxes in GridView, Repeater and DataList controls

Posted By Mikesdotnetting - 30 August 2007 10:29

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.

Filed under: ASP.NET 2.0 ASP.NET Web Forms as Snippet
Viewed: 49633 times

6 Comments for this item

ViewState, form fields, labels and Javascript

Posted By Mikesdotnetting - 25 August 2007 12:34

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.

Filed under: ASP.NET 2.0 Javascript ASP.NET Web Forms as Tutorial
Viewed: 35719 times

4 Comments for this item

Bind Data From a SqlDataSource to a Label

Posted By Mikesdotnetting - 25 August 2007 10:32

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.

Filed under: ASP.NET 2.0 ADO.NET ASP.NET Web Forms as Tutorial
Viewed: 112086 times

31 Comments for this item

Mikesdotnetting

Tags

My Book

Blogs

19 items found in the ASP.NET Web Forms Category