Andy The's Blog

Movie Star

andrewthe@hotmail.com (Andy The) — Sat, 03 Jul 2010 08:24:00 +0000

type="application/x-shockwave-flash">

Output your SQL when using Linq in ASP.NET

andrewthe@hotmail.com (Andy The) — Sat, 24 Oct 2009 18:40:00 +0000

I used both Linq Data Source and straight Linq.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;

public partial class _Default : System.Web.UI.Page
{
StringWriter sw = new StringWriter();
protected void Page_Load()
{
// Using Linq Data Source
LinqDataSource1.ContextCreated += (sender, e) =>
{
sw.WriteLine("Grid 1 SQL");
((DataClassesDataContext)e.Result).Log = sw;
};

// Using Linq
DataClassesDataContext db = new DataClassesDataContext();

var results = from c in db.Customers
where c.City == "London"
select c;

GridView2.DataSource = results;

sw.WriteLine("Grid 2 SQL");
db.Log = sw;
GridView2.DataBind();

}
protected override void Render(HtmlTextWriter writer)
{
base.Render(writer);
writer.Write("<hr><p>LINQ to SQL Trace Console</p><p><textarea cols='100' rows='15' readonly='true'>");
writer.Write(sw.ToString());
writer.Write("</textarea></p>");
}

}

31 Days of Refactoring eBook

andrewthe@hotmail.com (Andy The) — Wed, 21 Oct 2009 23:01:00 +0000

http://www.lostechies.com/blogs/sean_chambers/archive/2009/10/20/31-days-of-refactoring-ebook.aspx

Free e-book offer that features Windows Server 2008 R2

andrewthe@hotmail.com (Andy The) — Wed, 21 Oct 2009 22:56:00 +0000

http://download.microsoft.com/download/5/C/0/5C0BD0AB-040D-4C56-A60B-661001012DDA/Windows_Server_2008_R2_e-book.pdf

Mass installing your DNN modules

andrewthe@hotmail.com (Andy The) — Wed, 21 Oct 2009 22:52:00 +0000

Step 1) Drop your module in:

{Where your DNN is installed}\Install\Module

Step 2) Go to this URL:

http://{yoursite}/install/install.aspx?mode=installresources

You should see your modules being installed.

Finished.

Disk2vhd v1.0

andrewthe@hotmail.com (Andy The) — Wed, 14 Oct 2009 20:16:00 +0000

http://technet.microsoft.com/en-nz/sysinternals/ee656415(en-us).aspx

Disk2vhd will create a vhd out of your hard drive.

Generate your own custom Controller and Views by overriding the default MVC T4 templates

andrewthe@hotmail.com (Andy The) — Tue, 13 Oct 2009 21:50:00 +0000

Create a ASP.NET MVC Web Application

Copy the CodeTemplates directory into the root of your MVC project.

By copying this directory into your root directory you will be overriding the default templates.

The CodeTemplates directory can be found here:

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\CSharp\Web\MVC

VB.NET

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\VisualBasic\Web\MVC

Highlight each t4 template and delete the “Custom Tool” properties.

Modify template(s)

Add new controller

Now you can see your custom created controller!!!

(This applies to the views as well)

Creating a code snippet in Visual Studio 2008

andrewthe@hotmail.com (Andy The) — Tue, 13 Oct 2009 20:16:00 +0000

Step 1:

Download and install "Snipp Dogg - Visual Studio Intellisense" from http://www.codeplex.com/SnippDogg

Step 2:

a) Create new file.

b) Paste code.

c) Fill the two required fields. Shortcut and Title

3) Save snippet file.

3) Import snippet file into Visual Studio.

Tools –> Code Snippets Manager

Choose language
Import snippet

4) Use snippet

Type the name of the shortcut name and then hit the tab button twice.

Finished.