87 items found in the ASP.NET Web Pages Category

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 3663 times

2 Comments for this item

Exploring Prefix: A Free ASP.NET Profiling Tool

30 March 2016 19:21

ASP.NET MVC ASP.NET Web Forms ASP.NET Web Pages

Prefix is a free profiler for ASP.NET applications. It's dead easy to use and it will help you find bugs in your code that you didn't even know you had. I found two in what I thought were properly working apps within an hour of downloading Prefix.

Click to read more about Exploring Prefix: A Free ASP.NET Profiling Tool ...

Viewed 5273 times

5 Comments for this item

ASP.NET 5 By Numbers

16 March 2015 13:20

ASP.NET MVC ASP.NET Web Pages ASP.NET 5

There's a lot of confusion surrounding the numbers relating to the impending release of the next version of ASP.NET. This post takes a look at the main ones and seeks to explain their significance.

Click to read more about ASP.NET 5 By Numbers ...

Viewed 10900 times

4 Comments for this item

Error Handling in ASP.NET Razor Web Pages

10 March 2015 13:07

ASP.NET Web Pages WebMatrix

Bang! An unhandled exception occurred during the execution of the current web request. And that's it - your visitor is met with the yellow screen of death and they are left wondering what they did wrong. You might not even be aware of what's just happened - unless your visitor can find some way of alerting you, oh, and they bother to do so. That's the problem with run time errors; the code worked fine when you ran it on your machine. But then along came a user and they tried to do something you didn't anticipate and broke your site. So what should you do about this?

Click to read more about Error Handling in ASP.NET Razor Web Pages ...

Viewed 13233 times

1 Comment for this item

Migrating From Razor Web Pages To ASP.NET MVC 5 - Model Binding And Forms

24 February 2015 14:51

ASP.NET MVC ASP.NET Web Pages

If you have built sites with the ASP.NET Razor Web Pages framework, you might want to look at migrating them to ASP.NET MVC at some point. This tutorial is the last in a series of three that explores how you do that by taking a step by step approach to migrating the WebMatrix Bakery template site to ASP.NET MVC 5. Previous tutorials in the series have looked at the roles of the View and Controller, and the data access and view model aspects of the Model. This final part covers model binding and form posting. A download (c. 24MB) featuring the completed application is available.

Click to read more about Migrating From Razor Web Pages To ASP.NET MVC 5 - Model Binding And Forms ...

Viewed 27699 times

5 Comments for this item

Migrating From Razor Web Pages To ASP.NET MVC 5 - Data Access And View Models

18 February 2015 13:16

ASP.NET MVC Entity Framework ASP.NET Web Pages

If you have built sites with the ASP.NET Razor Web Pages framework, you might want to look at migrating them to ASP.NET MVC at some point. This tutorial is the second in a series of three that explores how you do that by taking a step by step approach to migrating the WebMatrix Bakery template site to ASP.NET MVC 5. Along the way, each of the core parts of MVC are discussed by way of an introduction to the framework. The tutorial is divided into three parts. The first part looked at the roles of the View and Controller. This part looks at the M in MVC, the Model. Specifically, it features data access and view models. The final part will cover model binding and form posting. A download (c. 24MB) featuring the completed application is available.

Click to read more about Migrating From Razor Web Pages To ASP.NET MVC 5 - Data Access And View Models ...

Viewed 12058 times

2 Comments for this item

Migrating From Razor Web Pages To ASP.NET MVC 5 - Views and Controllers

16 February 2015 13:33

ASP.NET MVC ASP.NET Web Pages

If you have built sites with the ASP.NET Razor Web Pages framework, you might want to look at migrating them to ASP.NET MVC at some point. This tutorial is the first in a series of three that explores how you do that by taking a step by step approach to migrating the WebMatrix Bakery template site to ASP.NET MVC 5. Along the way, each of the core parts of MVC will be discussed by way of an introduction to the framework. The tutorial is divided into three parts. This first part looks at the V and C part of MVC - View and Controller. The M or Model is covered in the second and third parts. A download (c. 24MB) featuring the completed application is available.

Click to read more about Migrating From Razor Web Pages To ASP.NET MVC 5 - Views and Controllers ...

Viewed 15945 times

2 Comments for this item

Integrating Web API with ASP.NET Razor Web Pages

03 February 2015 13:26

ASP.NET Web Pages WebMatrix Web API

ASP.NET Web API is the recommended way to build RESTful services over HTTP when using the ASP.NET stack. This article looks at incorporating Web API into an existing Razor Web Pages site, and provides a brief introduction to Web API itself.

Click to read more about Integrating Web API with ASP.NET Razor Web Pages ...

Viewed 41760 times

11 Comments for this item

Usage of the @ (at) sign in ASP.NET

22 January 2015 13:54

C# ASP.NET MVC ASP.NET Web Pages Razor

The number of places where you might use or encounter the @ sign in ASP.NET has grown over the last few years and its exact purpose in all circumstances still seems to cause confusion. Here's an overview of the most common places that it crops up, and guidance on its correct usage.

Click to read more about Usage of the @ (at) sign in ASP.NET ...

Viewed 15198 times

8 Comments for this item

Scheduled Tasks In ASP.NET With Quartz.Net

07 August 2014 08:34

General ASP.NET MVC ASP.NET Web Forms ASP.NET Web Pages

A perennial question on the ASP.NET forums concerns how to schedule regular tasks as part of a web application. Typically, the requirement is to send emails once every 24 hours at a particular time each day, but it could actually be anything from tweeting on a schedule to performing maintenance tasks. Equally typically, half a dozen members on the forum dive in with recommendations to install Windows Services or schedule batch files with the Task Scheduler - regardless of the fact that most web site owners are not afforded such privileges as part of their shared hosting plan.

Click to read more about Scheduled Tasks In ASP.NET With Quartz.Net ...

Viewed 111103 times

66 Comments for this item

Using ASP.NET Identity with Razor Web Pages

04 July 2014 07:27

ASP.NET Web Pages WebMatrix Razor

ASP.NET Identity is the new membership system for ASP.NET applications and is the recommended system for new MVC 5 and Web Forms projects. Among other things, it moves membership away from being dependent on System.Web, which is the general direction that the next version of ASP.NET is taking. News on how the Web Pages framework will be impacted by this evolution in ASP.NET is scarce at the moment, and so is information on how to incorporate ASP.NET Identity into a Razor Web Pages site. This article demonstrates the steps required to make use of the ASP.NET Identity framework in your Web Pages application.

Click to read more about Using ASP.NET Identity with Razor Web Pages ...

Viewed 62313 times

12 Comments for this item

Migrating Classic ASP To ASP.NET Razor Web Pages Part Three- Include Files And Reusable Code

10 March 2014 13:23

Classic ASP VB.Net ASP.NET Web Pages WebMatrix Razor

This is the third in a series of articles that explore how to migrate classic ASP web sites to the ASP.NET Web Pages framework. I covered Razor syntax and data access in the previous articles. This article shows how to deal with reusable code that typically inhabits include files in classic ASP.

Click to read more about Migrating Classic ASP To ASP.NET Razor Web Pages Part Three- Include Files And Reusable Code ...

Viewed 20874 times

6 Comments for this item

Migrating Classic ASP To ASP.NET Razor Web Pages Part Two- Data Access

03 March 2014 13:26

Classic ASP VB.Net ASP.NET Web Pages WebMatrix

The first article in this series explored the differences (and similarities) between classic ASP inline syntax and Razor syntax, the templating technology behind ASP.NET Razor Web Pages. The work required so far to port intermixed HTML and simple conditional and selection statements across from classic ASP to Razor didn't require a lot of effort. That is about to change in this article as I look at data access.

Click to read more about Migrating Classic ASP To ASP.NET Razor Web Pages Part Two- Data Access ...

Viewed 25075 times

6 Comments for this item

Migrating Classic ASP To ASP.NET Razor Web Pages Part One- Razor Syntax And Visual Basic

24 February 2014 13:25

Classic ASP ASP.NET Web Pages WebMatrix Razor

You have a classic ASP application that needs migrating to ASP.NET. You are comfortable working with classic ASP. but ASP.NET is fairly new to you. So what do you do? This article is the first in a series that looks at your options and proposes an approach to the migration that follows the path of least resistance.

Click to read more about Migrating Classic ASP To ASP.NET Razor Web Pages Part One- Razor Syntax And Visual Basic ...

Viewed 65600 times

7 Comments for this item

Creating Reusable Components For ASP.NET Razor Web Pages

04 February 2014 19:39

ASP.NET Web Pages WebMatrix

There are a number of ways that you can maximise code re-use within a Razor Web Pages site: Layout pages, helpers, functions and so on. As you build more sites, you soon find that you are repeating code between them. You might have a collection of custom utility functions and extension methods, for example that you find yourself copying and pasting across sites. Over time, this will become a maintenance nightmare as different versions of the methods live in different sites. This article shows how to solve that problem easily by creating a library that can be shared across multiple sites.

Click to read more about Creating Reusable Components For ASP.NET Razor Web Pages ...

Viewed 20478 times

8 Comments for this item

Recent Comments

satyabrata 19/06/2016 18:53
In response to Entity Framework Code First and Stored Procedures
Nice article. Thanks. The menu on this website not working in mobile....

satyabrata 16/05/2016 06:28
In response to Implementing SQL Server Full-Text Search In An ASP.NET MVC Web Application With Entity Framework
This is great. Thanks for sharing....

sharey 06/05/2016 13:15
In response to The Best Way To Import Data From Excel To SQL Server via ASP.NET
nice work gentleman.Really helpfull....

Satyabrata Mohapatra 20/04/2016 04:36
In response to The Best Way To Import Data From Excel To SQL Server via ASP.NET
Another beauty !!!! Thanks for sharing....

Avinash Setty 18/04/2016 18:39
In response to Exploring Prefix: A Free ASP.NET Profiling Tool
This tool is awesome! I am very thankful for introducing this tool for us! By any chance, do you is...

flyingtigerfan 17/04/2016 22:56
In response to Request.Form Is Empty When Posting To ASPX Page
Thanks - spent hours trying to figure this out. I'm out of date and trying to start working on some...

Darren Evans 12/04/2016 16:42
In response to Exploring Prefix: A Free ASP.NET Profiling Tool
'Tis indeed a marvellous thing. Just waiting on its appearance for ASP.NET Core. Hopefully not long...

Arkady 03/04/2016 12:09
In response to Request.Form Is Empty When Posting To ASPX Page
Thank you! I spent a day to understand what problem is before I found your article! But I made of...

satyabrata 03/04/2016 03:50
In response to Exploring Prefix: A Free ASP.NET Profiling Tool
This is great!!!!!...

John Dave Bumatay 01/04/2016 02:01
In response to Windows Authentication With ASP.NET Web Pages
+1 ! This worked for me like a magic!~ thank you very much Mike! ;)...