42 items found in the ASP.NET 2.0 Category
Import Data From Excel to Access with ASP.NET
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 simpy and efficiently with Excel files. More...
Filed under: ASP.NET 2.0 MS Access ADO.NET as Article
AccessDataSource, SqlDataSource and connecting to Access databases in ASP.NET
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. More...
Filed under: ASP.NET 2.0 MS Access ADO.NET as Article
80040E14 - MS Access Syntax Error messages
Mikesdotnetting
-
01 May 2008 11:06
This short article deals with the following common MS Access-related error messages: More...
Filed under: ASP.NET 2.0 MS Access ADO.NET as Article
Simple Login and Redirect for ASP.NET and Access
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. More...
Filed under: ASP.NET 2.0 MS Access ADO.NET as Article
Solving the Operation Must Use An Updateable Query error
Mikesdotnetting
-
30 April 2008 22:48
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. More...
Filed under: ASP.NET 2.0 MS Access ADO.NET ASP.NET 3.5 as FAQ
Search Engine-Friendly Custom Paging with the GridView and LINQ to SQL
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. More...
Filed under: ASP.NET 2.0 LINQ ASP.NET 3.5 as Article
Migrating from Sql Server to Access in ASP.NET
Mikesdotnetting
-
16 November 2007 10:45
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. More...
Filed under: ASP.NET 2.0 MS Access ADO.NET as Article
How to get your forum question answered - avoid thread-jacking
Mikesdotnetting
-
13 November 2007 12:33
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. More...
Filed under: ASP.NET 2.0 as FAQ
An ASP.NET Search Engine with MS Access for optional search criteria
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. More...
Filed under: ASP.NET 2.0 MS Access ADO.NET as Article
Referencing CheckBoxes in GridView, Repeater and DataList controls
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. More...
Filed under: ASP.NET 2.0 as Snippet
ViewState, form fields, labels and Javascript
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. More...
Filed under: ASP.NET 2.0 Javascript as Article
Bind Data From a SqlDataSource to a Label
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. More...
Filed under: ASP.NET 2.0 ADO.NET as Article
Using an ArrayList to cheat at Scrabble
Mikesdotnetting
-
21 August 2007 14:39
My dad had a Facebook account. He was addicted to it. Or rather, he was addicted to the Scrabulous application, which is a Flash-based online version of the popular word game Scrabble. Trouble is, he kept beating me, and I had to do something rather drastic to corrrect that. So I thought it can't be too difficult to build a C# ASP.NET app that would give me some... err... assistance. Scrabulous offer the TWL06 (current official Tournament Word List) as a downloadable text file, so armed with a complete list of all 186,000+ legal Scrabble words, I sat down and started to think about how I could use it. More...
Filed under: C# ASP.NET 2.0 as Article
Object reference not set to an instance of an object and INamingContainer
Mikesdotnetting
-
21 August 2007 11:36
A list of standard ASP.NET web controls that implement INamingContainer More...
Filed under: ASP.NET 2.0 as Cheat Sheet
Consuming RSS feeds in an ASP.NET page
Mikesdotnetting
-
18 August 2007 23:12
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. More...
Filed under: ASP.NET 2.0 as Article