Here is a stored procedure I am using for a Dotnetnuke custom authentication provider that I use to get the number of failed login attempts for user.

Active Directory Integration has changed a bit since DNN 4.  This guide is intended to help you setup Active Directory on your Dotnetnuke 5.x website.�

If you are running Dotnetnuke 4.x please see this post.  If you are running Dotnetnuke 3.x please see this post.

 

Let’s get started with installing the Dotnetnuke Active Directory provider for Dotnetnuke 5.x If you haven’t installed the Active Directory Provider yet, you need to first visit the download page located here. Once you have downloaded the files you need to login to your...

Read More »

DotNetNuke provides those with “Host” level access a great screen to execute SQL commands against.

This screen is located under the “Host” menu and is named, “SQL”.  It is a simple box that you simply write your query or paste in your stored procedure script and then press, “Execute”. It is a great way to quickly looking up table information or run a delete command if your EventLog gets to full.

I find myself using this box often to look up information in a table.  The only problem is that I am never quite sure what the name of the table is that I am looking up.  That is when I use this simple SQL command to pull out all the names of tables so I can then do some “SELECT” statements on the table I need.

The command below lists all of the tables in your database.  This code is a copy of the code from here.

SELECT...

Read More »

As web developers we are often creating ways for people to upload files.  Usually uploading a file is pretty trivial and there are numerous examples of how to do it across the Internet.  From time to time we have the need to secure the file we are uploading, to prevent someone from directly navigating to the file and downloading it without our permission.  It is at these times that we have to modify the file upload process just a bit in order to prevent direct access to our files.  Of course, we still need to be able to use the files that are uploaded, so this walkthrough will show you how to upload and secure your files and also how to download your secured files.�

The premise of our security is that files with the file extension of “.resource” are not served by web servers, at least not by IIS.  Therefore all we have to do is add the file extension of “.resource” to any file we upload.  If we uploaded a file named, “Gnome.jpg”, we would store it on the server as “Gnome.jpg.resource”.  If someone were...

Read More »

I have been fighting with Installing IIS for a day or so now.  I was getting a very generic error regarding that the setup failed to install the components.  There was no real detail as to what the problem was.

Well, I finally figured it out.  You have to install the .Net Framework 3 before installing IIS or IIS won’t install.

It makes sense, but I figured Vista would be smart enough to figure that out.  Guess not.�

Technorati Tags: Vista,IIS,Install,Issue,.Net,Framework

...

Read More »

 Today I needed to grab the values of a list I have setup in Dotnetnuke
and display it in a dropdownlist.  The code to do this is really quite
simple.

Matt asked on Twitter how he could find all of the roles on his Dotnetnuke site that were not currently being used at either the page or module level.

You can find this information out by doing the following: