.NET Answers

DotNetNuke Modules - Data Access Layer

Dave — Thu, 07 Aug 2008 14:12:49 +0000

On Tuesday, we started working on the code for our Data Access Layer by having CodeSmith generate some classes for us. Today, we are going to generate the DataSets we need and modify the controller classes to use them. At the end, you will have a DataLayer and Business Logic Layer that will allow you to start coding your presentation layer using the familiar ASP.NET 2.0 model.

(more…)

Using DataSets to Process XML

Dave — Wed, 06 Aug 2008 09:39:58 +0000

I started a project recently that requires me to process an XML file from Google. Being the lazy sort, I’d really rather just use the data as though it were part of a database and forget that it was ever XML. So I’m using a method in the DataSet class that I’m finding is rather obscure. ReadXml().

(more…)

DotNetNuke Modules - Data Access Layer

Dave — Tue, 05 Aug 2008 09:16:15 +0000

Now that we’ve created our stored procedures, we are going to use some of the other CodeSmith templates to generate our data access layer (DAL).

Keep in mind that the templates you are going to be using were originally meant to be used on DotNetNuke 3.x. They did a great job of creating the code we needed. But as the DataSet construct matured and Generics were introduced, the whole idea of using Info classes and ArrayList went the way of the dinosaur. So there will be some tweaking we will need to do.

(more…)

ASP.NET AJAX using JSON - Here’s how.

Dave — Mon, 04 Aug 2008 12:05:58 +0000

Last week I wrote a post about how simple JSON is. In it I explained the main differences between using JSON and using the update panel. I really started out thinking I’d get to how to write JSON code, but I ran out of space. Well, today, we get to the HOW.

All JSON really is, is the ability to have JavaScript code call a WebService for our data, and write it into the HTML on the client side. If you know anything about how to write a WebService, this should be rather trivial because your web service is going to look just like any other web service with the exception of an added attribute.

(more…)

DotNetNuke - Modules - Portal Specific Modules

Dave — Thu, 31 Jul 2008 11:33:42 +0000

Many of you won’t care too much about creating Portal Specific Modules because you’ll be creating modules for an environment that only has one portal. However, if you are creating a module for resell, or you will be using the module in a multi-portal environment, you’ll need this next piece of information I’m going to give you.

(more…)

Using JSON in ASP.NET

Dave — Wed, 30 Jul 2008 13:04:15 +0000

If you’ve been avoiding using JSON in your ASP.NET application because you think it’s hard, you’re an idiot. I can say that, because I’ve been avoiding it for exactly that reason. I’ve been an idiot too. But no more! Using an UpdatePanel is still easier than JSON. But JSON is easy enough that you may decide to use it over the UpdatePanel under certain circumstances.

(more…)

DotNetNuke - Modules - Creating Stored Procs

Dave — Tue, 29 Jul 2008 12:23:12 +0000

Now that we have our tables created, we are going to use the CodeSmith product that we installed last week to create our stored procedures.

We will also end up creating the SQL scripts that we will need to install this module into another DNN installation.

(more…)

5 Tips to Make You a Valuable Programmer.

Dave — Mon, 28 Jul 2008 10:52:15 +0000

One of the big mistakes I see young programmers make is writing code that they should never have written. While the code was a great educational exercise, it was a waste of the employer’s money. So how do you decide what code to write and what code to leave out?

Here are some simple rules to follow that will make you an asset to your company. If you want to be the last one they fire, make sure you are the most efficient programmer.

(more…)

DotNetNuke - Modules - Creating The Tables

Dave — Thu, 24 Jul 2008 11:16:42 +0000

On Tuesday we installed the free version of CodeSmith to help us create the database access code. Before we can create the access code, we need some tables in our system. Even if you think you know all about creating tables in a database, don’t skip this lesson. There are some very specific tips related to working with DotNetNuke that you will miss if you skip it.

(more…)

Tracking Down Performance Issues in ASP.NET

Dave — Wed, 23 Jul 2008 14:36:08 +0000

Last night, one of my clients assigned me a problem that I thought was going to require one solution, and in the end it was just poor programming. But the process reminded me of the need for good debugging skills. Just how do you know where the performance problem is?

(more…)