Wednesday, July 9, 2008 9:19 AM
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.
Viewed 73760 times
Saturday, May 17, 2008 9:48 AM
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.
Viewed 90809 times
Thursday, May 1, 2008 11:06 AM
This short article deals with the following common MS Access-related error messages:
Viewed 28136 times
Thursday, May 1, 2008 10:02 AM
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.
Viewed 315751 times
Wednesday, April 30, 2008 10:48 PM
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.
Viewed 203520 times
Tuesday, November 13, 2007 12:33 PM
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.
Viewed 912651 times
Monday, November 12, 2007 3:15 PM
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.
Viewed 27028 times
Thursday, August 30, 2007 10:29 AM
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.
Viewed 70411 times
Saturday, August 25, 2007 12:34 PM
Viewed 53366 times
Saturday, August 25, 2007 10:32 AM
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.
Viewed 191192 times
Tuesday, August 21, 2007 11:36 AM
A list of standard ASP.NET web controls that implement INamingContainer
Viewed 27749 times
Saturday, August 18, 2007 11:12 PM
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.
Viewed 12906 times
Friday, August 10, 2007 9:33 PM
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.
Viewed 19584 times
Thursday, August 2, 2007 11:41 PM
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.
Viewed 42380 times
Friday, July 27, 2007 2:24 PM
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.
Viewed 49225 times
7/7/2015 12:53 PM
In response to Reading Excel Files Without Saving To Disk In ASP.NET
Nice article. Thank you...
7/6/2015 6:18 PM
In response to iTextSharp - Adding Text with Chunks, Phrases and Paragraphs
Great tutorial, thank you guys...
7/6/2015 1:30 PM
In response to The Difference Between @Helpers and @Functions In WebMatrix
Is it possible to call e.g. @Functions.IsBeforeToday("2010/3/22") directly from a jQuery AJAX like...
7/5/2015 11:23 AM
In response to Web Pages - Efficient Paging Without The WebGrid
as usual, your page of resources saves the day yet again... is there a donate button? im happy to u...
7/5/2015 2:40 AM
In response to Migrating From Razor Web Pages To ASP.NET MVC 5 - Model Binding And Forms
hi i just saw ur post on the order form its really helping me with my campus project i was just how...
7/3/2015 2:32 PM
In response to Handling JSON Arrays returned from ASP.NET Web Services with jQuery
Thank you, works great and very well explained....
7/3/2015 6:20 AM
In response to 7 C# 6.0 Features That Every ASP.NET Developer Should Know About
Great Article thanks...
7/1/2015 7:03 AM
In response to iTextSharp - Drawing shapes and Graphics
I have created a rectangle using above methode. Now I want to add a text in the center of this How I...
6/30/2015 6:12 PM
In response to Reading Excel Files Without Saving To Disk In ASP.NET
Ahh.....this is awesome. Happy to see after a long time you wrote a article on web form :D...
6/30/2015 7:16 AM
In response to Posting Data With jQuery AJAX In ASP.NET Razor Web Pages
Mike, you're the Man! Another great article. So incredibly helpful. I'm definitely going to buy your...