9 Wired In November
 

From the Editor


Welcome to New Era’s November edition of Wired In! With 2010 right around the corner, many new technologies are being unveiled including Windows 7, SharePoint 2010, Exchange 2010 just to name a few. How can you keep up with it all?

 

To help you in your quest of reliable information and tips, check out:

We are Listening!

 

IT Courses for Development

 

20% off!

 

Windows Courses!

 

Last Chance Courses

MS SharePoint

MS SharePoint Designer & Branding

Nov. 30

MS SharePoint Power User

Nov. 16

Mindsharp - Core Technologies in Office SharePoint Server 2007

Dec. 7

MS Windows Server 2008

6416B: Updating your Network Infrastructure and Active Directory Technology Skills to Windows Server

Dec. 7

MS SQL Server 2008

6231: Maintaining a Microsoft SQL Server 2008 Database

Dec. 7

6236A: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Nov. 16

Visual Studio 2008 & ASP.NET 3.5

2310: Developing ASP .NET Web Applications using Visual Studio 2008

Dec. 7

6463A: Visual Studio 2008: ASP.NET 3.5

Nov. 23

6464A: Visual Studio 2008: ADO.NET 3.5

Nov. 25

50066: LINQ with C# 3.0 2008

Dec. 2

Clinic 50030A: Delta .NET 3.0 - 3.5

Nov. 30

 

 

New Era Technology

Emerging Technologies

SharePoint 2010

SharePoint 2010 Training is Here!

Be the first to learn this much anticipated technology!

Windows 7

 

Windows 7 training is coming!
Do you want to be the first to know? Email us at win7@neweratechnology.com

 

Free Seminar: Unleash the Power of Windows 7!

Register for Seminar

Exchange 2010

Are you prepared for the coming of Exchange Server 2010?
Be the first to know of coming courses! Email us at ex2010@neweratechnology.com

 

Free Seminar: Exchange 2010 - Taking it to the Next Level!
Register for Seminar

IT Professional's Connection

IT Professional

by: Christian Millar, MCT, Manager Microsoft Infrastructure Training

 

Tech·Days Canada Calgary, Alberta November 17-18, 2009


This will be an exciting month in Calgary. We look forward to going to Tech· Days Canada Calgary where IT pros and Developers alike, will see the newest products that Microsoft will be promoting. With the latest offerings comes new Training and Certification.


Looking at the latest of the much anticipated products is the Microsoft’s Windows 7 Operating System this has been highly touted. And with the Beta, RC and final release version there has been nothing but positives coming from community and experts alike. For those of you whom will move forward with the latest Windows and are looking for the Tips and Tricks that are now available in Windows 7 please go take a look at the Windows 7 Tips and Tricks section.


Now like most of you I have installed Windows 7 from a recent download and burnt it to DVD but they have made a tool that can be very useful for yourself if you are looking to upgrade those netbooks or laptops that don’t actually have a built in DVD player or CD rom drive, I would suggest then you can download from the Microsoft Store a neat little utility for placing Windows 7 ISO Based images onto a USB stick and use their Tool. A really very convenient tool and a must for us Network Admin types to carry on the job.


Now to talk quickly about the other much anticipated product that works extremely well with the Windows 7 client is the Windows Server 2008 R2 Edition. If your planning on attending the Tech·Days event it  will include a series of presentations to provide an in-depth deep dive into Windows Server 2008 R2, and of course an opportunity for us to gather as a community at Tech·Days.
Windows Server 2008 R2 edition offers many new benefits and we will start to examine each particular new feature that is offered in our future articles.


I encourage you to monitor the New Era Technology website if you are interested in participating in our new Classes, or if you are looking for other specific opportunities.


If you want to give Christian any feedback on this article, email him @ cmillar@neweratechnology.com

Developer's Connection

Developerby: Scott Jackson, MCT, Manager .Net Development Training  

 

I am often asked for advice on how to write better, cleaner code using .NET. I am a big fan of encapsulation – especially as it relates to data access. If you are looking for a Microsoft solution that has been tested and used in many companies throughout the industry, I suggest checking out Microsoft Data Access Application Blocks.


The most common tasks are encapsulated within the application block methods. Certain features, like opening and closing the database, take place “behind the scenes” and have error handling code surrounding them. This will help speed up development, and reduce errors in coding

An example from Codersource helps to illustrate this. The first block of code is inserting 2 parameters into the database. 12 lines of code in total:

string connectionString = (string)
ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand("INSERT_PERSON",connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@Name",SqlDbType.NVarChar,50));
command.Parameters["@Name"].Value = txtName.Text;
command.Parameters.Add(new SqlParameter("@Age",SqlDbType.NVarChar,10));
command.Parameters["@Age"].Value = txtAge.Text;
connection.Open();
command.ExecuteNonQuery();
connection.Close();

Using Application Blocks, we can accomplish the same thing in 3 lines of code:

using Microsoft.ApplicationBlocks.Data;
SqlHelper.ExecuteNonQuery(connection,"INSERT_PERSON",new
SqlParameter("@Name",txtName.Text) ,new SqlParameter("@Age",txtAge.Text) );


As you can see, this code is much cleaner. All of the code from the preceding block is still happening, but it’s all inside the Application Block. Even more useful is that when you download this, you have full access to the source code. This means you can add your own code to the application block – great for customizing it for your organization.


For this example, I am using the earlier version, which is simpler to understand. It can be downloaded from here. The newer version can be downloaded here, and is part of the Enterprise Library 4.0 and Unity 1.2. I will get more into detail on these with my next article.


If you want to give Scott feedback on this article, email him @ sjackson@neweratechology.com

Upcoming Course Information

Save 20% off all our Courses Until Dec. 31!

View all Microsoft Courses
Microsoft SQL Courses
Microsoft Exchange Courses
Microsoft System Center Courses
Microsoft SharePoint Courses
Microsoft Windows Server Courses
Microsoft .NET Development Courses

Microsoft Communication Server Courses

New Era Technology
#300, 633 - 6th Ave S.W., Ford Tower Calgary, Alberta Canada T2P 2Y5
Phone: 403-265-1150
Fax: 403-265-9797

www.neweratechnology.com

Unsubscribe