Finally, we can [download] the c# source code for DotNetNuke Portal.

This is not a fully tested application. So use it as your own risk.

You can go to [DNN Forum] to discuss this topic.

Incoming search terms:

• download dotnetnuke with C# source (1)

For those who wish to learn or know more about DNN module development but do not know where to start.

Here the link for you to start.

1. Creating a DNN Module and Understanding DNN Architectural Approach [Click Here]
2. Creating a DotNetNuke® Module – For Absolute Beginners [Click Here]
3. Creating a Super-Fast and Super-Easy DotNetNuke® Module – for Absolute Beginners [Click Here]

Before launch your visual studio.NET 2005, please make sure you installed the DNN template & starter kit which you can find it [here], also DNN Source Code Version which you can download from [www.dotnetnuke.com]

To deal with a complex business logic, you may write complex T-SQL in stored procedure. It may return -9, -5, -1, 0, 1, 2…. and so on.

We have to use SqlHelper.ExecuteScalar instead of SqlHelper.ExecuteNonQuery.

Example,

public override long DeleteUser(long callingUserId, long userId)
{
SqlParameter[] paramArray = new SqlParameter[3];
paramArray[0] = new SqlParameter("@piCallingUserId", callingUserId);
paramArray[1] = new SqlParameter("@piDeletedUserId", userId);

paramArray[2] = new SqlParameter("@oiRetVal", 99);

paramArray[2].Direction = ParameterDirection.Output;

SqlHelper.ExecuteScalar(ConnectionString, CommandType.StoredProcedure, GetFullyQualifiedName("User_Del_User"), paramArray);

return long.Parse(paramArray[2].Value.ToString());
}

Incoming search terms:

• SqlHelper ExecuteScalar example (16)
• SQLHelper ExecuteScalar (11)
• dotnetnuke sqlhelper (6)
• dnn executescalar sql (2)
• c# executescalar (1)
• sqlhelper paramarray example (1)
• sqlhelper executescalar namespace (1)
• sqlhelper executescalar in dnn (1)
• sqlhelper executescalar dnn (1)
• specified cast is not valid sqlhelper executescalar (1)