24 items found in the ADO.NET Category

Implementing SQL Server Full-Text Search In An ASP.NET MVC Web Application With Entity Framework

13 May 2016 08:13

SQL ADO.NET ASP.NET MVC Entity Framework

The search facility on this site has been rudimentary at best. I have recently upgraded it to take advantage of the Full-Text Search feature in SQL Server. Although it is still a basic implementation, it is a vast improvement on the search system that existed before, which was based on Entity Framework dynamically generating SQL LIKE clauses. This article describes how I got SQL Server Full-Text Search up and running.

Click to read more about Implementing SQL Server Full-Text Search In An ASP.NET MVC Web Application With Entity Framework ...

Viewed 904 times

0 Comments for this item

The Best Way To Import Data From Excel To SQL Server via ASP.NET

14 April 2016 13:42

ADO.NET ASP.NET MVC ASP.NET Web Forms ASP.NET Web Pages EPPlus

I've seen a lot of questions about the best way to import data from uploaded Excel files to a SQL Server database in an ASP.NET application. Most solutions involve the use of the JET or ACE OLEDB providers to read data from the saved Excel file, and some even show how to use Office Interop to obtain the data. However, all of these solutions rely on additional components being installed on the server, and they also require the uploaded file to be saved somewhere, even temporarily, which creates an additional maintenance task. The solution that follows makes use of a Nuget package that gets deployed with your application and can work with streams, so the uploaded file doesn't need to be saved. It is, in my submission, THE best way to import data from uploaded Excel files to SQL Server in an ASP.NET application.

Click to read more about The Best Way To Import Data From Excel To SQL Server via ASP.NET ...

Viewed 2006 times

0 Comments for this item

Solved - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

23 July 2015 20:05

MS Access ADO.NET EPPlus

There are a number of reasons why you might get "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" error when attempting to connect to either an accdb or an xlsx file, depending on what you are doing. This article discusses some of the causes and provides solutions first for uses involving ASP.NET, and then looking at other application uses.

Click to read more about Solved - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine ...

Viewed 204762 times

27 Comments for this item

ASP.NET MVC is not all about Linq to SQL

21 February 2010 08:21

ADO.NET ASP.NET MVC

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.

Click to read more about ASP.NET MVC is not all about Linq to SQL ...

Viewed 96588 times

11 Comments for this item

Parameterized IN clauses with ADO.NET and LINQ

28 September 2009 21:53

C# ADO.NET LINQ ASP.NET 3.5

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.

Click to read more about Parameterized IN clauses with ADO.NET and LINQ ...

Viewed 51302 times

11 Comments for this item

Preventing SQL Injection in ASP.NET

19 August 2009 07:28

SQL ADO.NET ASP.NET 3.5

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.

Click to read more about Preventing SQL Injection in ASP.NET ...

Viewed 148469 times

26 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 97837 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 31672 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 351263 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 231651 times

53 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 65358 times

8 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 21633 times

6 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 27981 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 45121 times

5 Comments for this item

Recent Comments

Jon 31/03/2016 21:36
In response to Exploring Prefix: A Free ASP.NET Profiling Tool
We had the exact same experience, finding multiple bugs in an application that we thought was pretty...

ranjith 31/03/2016 05:50
In response to A Better Way To Export Gridviews To Excel
Hello Mike. i am exporting from gridview, because i have some images in my gridview. but i am error...

Matt Watson 30/03/2016 22:19
In response to Exploring Prefix: A Free ASP.NET Profiling Tool
Glad you are loving it! Matt from Stackify...

Dmitry 28/03/2016 04:26
In response to Solved - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
thank you about the VS 32-bit remark...

federico 26/03/2016 11:29
In response to Request.Form Is Empty When Posting To ASPX Page
thanks!....

Micheal 23/03/2016 00:58
In response to ASP.NET MVC 5 with EF 6 - Working With Files
Thanks for the code. its pretty straightforward. worked for me on my first trial. Perfect!...

Francisco 22/03/2016 20:35
In response to ASP.NET MVC 5 with EF 6 - Working With Files
The post is very good, thanks...

Nick Brown 22/03/2016 13:53
In response to Adding A View
Hi, Many thanks for this tutorial, it's helping me get started with MVC. In VB (VS 2013) I get late...

ferry mae 22/03/2016 13:04
In response to Send form content by email in ASP.NET
do i need to change this? message.To.Add(new MailAddress("me@domain.com")); message.CC.Add(new you...

Keith 22/03/2016 12:02
In response to Creating a Connection String and Working with SQL Server LocalDB
As always worst explanation, but this time you rocked with plagiarism too .. huhh.. copied from Rick...