Tutorial items on Mikesdotnetting

Parameterized IN clauses with ADO.NET and LINQ

Posted By 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.

Filed under: C# ADO.NET LINQ ASP.NET 3.5 as Tutorial
Viewed: 22271 times

7 Comments for this item

Microsoft Chart Controls to PDF with iTextSharp and ASP.NET MVC

Posted By Mikesdotnetting - 15 September 2009 22:16

If you are developing a business application using ASP.NET MVC, and need to produce some kind of dashboard-style reporting, the Chart Controls from Microsoft are a good place to start. Having a summary in some form of document, say a PDF is also a common requirement. This article introduces you to satisfying both needs.

Filed under: iTextSharp ASP.NET MVC as Tutorial
Viewed: 51864 times

6 Comments for this item

jQuery Star Rating with ASP.NET MVC

Posted By Mikesdotnetting - 08 September 2009 13:40

There are a number of jQuery star rating plugins to choose from. All have their pros and cons. For this site, I decided to implement the one from FyneWorks because it allows for split stars. Here's how I did it.

Filed under: AJAX Javascript jQuery ASP.NET MVC as Tutorial
Viewed: 34562 times

13 Comments for this item

Preventing SQL Injection in ASP.NET

Posted By 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.

Filed under: SQL ADO.NET ASP.NET 3.5 as Tutorial
Viewed: 78958 times

26 Comments for this item

RSS Feeds and Google Sitemaps for ASP.NET MVC with LINQ To XML

Posted By Mikesdotnetting - 10 July 2009 22:43

For the majority of personal web sites, two uses of XML are commonplace: creating an RSS feed and a Google Sitemap. Here, I look at how to create both of those using LINQ to XML for an ASP.NET MVC web site.

Filed under: LINQ ASP.NET MVC as Tutorial
Viewed: 22494 times

14 Comments for this item

ASP.NET MVC, Entity Framework, Modifying One-to-Many and Many-to-Many Relationships

Posted By Mikesdotnetting - 28 June 2009 21:37

Building on my previous article, which looked at adding data with one-to-many and many-to-many relationships via the Entity Framework, here's a look at how to modify that data within an ASP.NET MVC application.

Filed under: ASP.NET MVC Entity Framework as Tutorial
Viewed: 53347 times

10 Comments for this item

ASP.NET MVC, Entity Framework, One-to-Many and Many-to-Many INSERTS

Posted By Mikesdotnetting - 17 June 2009 21:55

Taking on two new technologies - ASP.NET MVC and the Entity Framework - at the same time was bound to provide some "interesting" moments. Getting data out via EF has so far been pretty straightforward. But when it got to building the back end of my site, I had some fun trying to manage INSERTS with One-To-Many and Many-To-Many relationships.

Filed under: ASP.NET MVC Entity Framework as Tutorial
Viewed: 100363 times

17 Comments for this item

Handling Legacy URLs with ASP.NET MVC

Posted By Mikesdotnetting - 08 June 2009 07:37

According to Google's Webmaster tools, there are about 15,000 incoming links to my site. 13,000 of those reference a .ASPX file on disk. When I convert to MVC, with new Search Engine Friendly urls, all those links will break unless I do something about it. Presenting users with a 404 - file not found is not an option. I need to show them the content they were expecting, and update Search Engines with the news that things have changed. Here's how I will be managing those Legacy URLs.

Filed under: ASP.NET MVC as Tutorial
Viewed: 34655 times

14 Comments for this item

Creating a Tag Cloud using ASP.NET MVC and the Entity Framework

Posted By Mikesdotnetting - 01 June 2009 07:26

A Tag Cloud is a visual depiction of Tags or categories on a web site. CSS is used to set the variable font size of each Tag to illustrate its relative frequency or popularity within the site. As part of the migration of my site to ASP.NET MVC, I am introducing one to replace the Categories navigation that appears on the left hand side of each page, which contains a count of items within each category.

Filed under: ASP.NET MVC Entity Framework as Tutorial
Viewed: 32016 times

16 Comments for this item

A Degradable jQuery AJAX Email Form for ASP.NET MVC

Posted By Mikesdotnetting - 29 May 2009 15:58

Pretty much every web site on the Internet features a form for users to provide feedback via email to site owners. This site is no different. Migrating to ASP.NET MVC requires a slightly different approach to that used by Web Forms development, so this article looks at one way to implement a web site contact form using the MVC framework and jQuery that degrades nicely. AJAX functionality is said to be "degradable" if a way is provided for the process to work, even though users don't have Javascript available to them.

Filed under: AJAX ASP.NET 3.5 jQuery ASP.NET MVC as Tutorial
Viewed: 40488 times

25 Comments for this item

ASP.NET MVC Partial Views and Strongly Typed Custom ViewModels

Posted By Mikesdotnetting - 11 May 2009 07:06

I'm in the process of rewriting mikesdotnetting.com using the ASP.NET MVC framework. It's an interesting experience, in that this is my first exposure to MVC. The first stumbling block I encountered was how to pass data in a satisfactory way to Partial Views which only represent part of the data that is to be displayed in the View. Since I struggled to find clear guidance on this, I thought I would share a way to do it.

Filed under: ASP.NET MVC Entity Framework as Tutorial
Viewed: 183556 times

28 Comments for this item

Many ways to communicate with your database using jQuery AJAX and ASP.NET

Posted By Mikesdotnetting - 04 May 2009 18:39

I've recently done a series of articles that feature calling databases via AJAX using jQuery. In pretty much all of the articles, I have used Web Services as my data access mechanism. Judging from the comments that some of the articles have attracted, this has caused a little confusion. But Web Services is just one mechanism. Page Methods and simple ASPX files are two more. And finally, as pointed out by a commenter, Benny Halperin, ASHX files are yet another option. In this article, I shall review each of these approaches.

Filed under: AJAX ASP.NET 3.5 jQuery as Tutorial
Viewed: 739815 times

42 Comments for this item

Build your own Whois Lookup with ASP.NET and jQuery

Posted By Mikesdotnetting - 14 April 2009 22:39

IP addresses can reveal a lot about your web visitors. For an ecommerce site, the owner or registrant of the visitor's IP address can be very useful information. You could paste each visitor IP address into one of the many free IP Lookup sites available, but that can be time-consuming and tedious. Or you could build your own lookup. This article shows how this can be done pretty quickly.

Filed under: AJAX Javascript ASP.NET 3.5 jQuery as Tutorial
Viewed: 47978 times

9 Comments for this item

Lazy Loading jQuery Tabs with ASP.NET

Posted By Mikesdotnetting - 02 March 2009 07:30

This article looks at efficient use of jQuery tabs when displaying data. Specifically, it covers how to lazy-load data, so that it is only accessed and displayed if the tab is clicked.

Filed under: AJAX Javascript ASP.NET 3.5 jQuery as Tutorial
Viewed: 96099 times

28 Comments for this item

Persisting the position of jQuery Draggables in ASP.NET

Posted By Mikesdotnetting - 04 February 2009 22:29

It was bound to happen - you knock up an article on jQuery draggables one day, and the next, someone like Jim ;-) comes along and asks about persisting the position of the dragged item across Postbacks, or even sessions. I suppose it's my fault - I mentioned using draggables in a previous life in the context of saving the position, so it's only fair I share how that's done.

Filed under: AJAX Javascript ASP.NET 3.5 jQuery as Tutorial
Viewed: 23716 times