21 items found in the ADO.NET Category
ASP.NET MVC is not all about Linq to SQL
Mikesdotnetting
-
21 February 2010 08:21
Pretty much every sample application that illustrates ASP.NET MVC uses Linq To SQL or the Entity Framework as the data access method. I've seen a number of questions posted to the forums at www.asp.net asking if there are any alternatives, and indeed there are. This article will look at using plain ADO.NET within a data access layer to provide dynamic content to a typical small CRUD application. More...
Filed under: ADO.NET ASP.NET MVC as Article
Parameterized IN clauses with ADO.NET and LINQ
Mikesdotnetting
-
28 September 2009 21:53
Since my article on using parameters for Preventing SQL Injection In ASP.NET, I have had a few emails asking how to do the same with an IN clause expression. In this entry, I explore a couple of ways to do this. More...
Filed under: C# ADO.NET LINQ ASP.NET 3.5 as Article
Preventing SQL Injection in ASP.NET
Mikesdotnetting
-
19 August 2009 07:28
I, and many other contributors to the forums at www.asp.net find examples of code posted on a daily basis that are vulnerable to SQL Injection attacks. We continue to exhort beginners (and some more experienced programmers) to code against them. This article examines just how serious a flaw vulnerable coding can be, and what you should do about it. More...
Filed under: SQL ADO.NET ASP.NET 3.5 as Article
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
Sql JOINS and the Sql Server Management Studio Query Designer
Mikesdotnetting
-
28 November 2007 13:19
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. More...
Filed under: SQL SQL Server Express ADO.NET 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
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
Reading Text files into Access with ASP.NET
Mikesdotnetting
-
09 September 2007 21:20
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. More...
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
Exporting data to a CSV, tab delimited or other text format
Mikesdotnetting
-
02 August 2007 23:41
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. More...
Filed under: ASP.NET 2.0 ADO.NET as Snippet
Displaying One-To-Many Relationships with Nested Repeaters
Mikesdotnetting
-
27 July 2007 14:24
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. More...
Filed under: ASP.NET 2.0 ADO.NET as Article