interesting article for stored procedure

Guys, if you have time to check it out.
This article is related to SP in database server.
Credit to my team mate who found this.
http://furrukhbaig.wordpress.com/2007/08/22/stored-procedures-factssheet/

Read Full Post »

DotNetNuke Module Load Control Dynamically

In my previous project, the application have 3 VIEW screens (the first page is add/update, 2nd page is confirmation page, 3rd page is success or fail error message page). I need to register 3 pages in the module defination and use Globals.NavigateURL to access those pages.
For instance, my 2nd Page call ConfirmationPage.acsx (i m registered [...]

Read Full Post »

Sql Server Login failed without using user login

I m faced this problem during setting up the Development Server Envirnonemt for DotNetNuke where web apps in Server A and Database sit in Server B. For more information, you can refer this link (If SQL Server is running on a remote computer and the Web server is running IIS 6.0, give the Web server’s machine [...]

Read Full Post »

Using TransactionScope in DNN

In my previous post, I wrote a post regarding Multiple Records Manipulation using SqlTransaction, but after discussed with the team. I should use TransactionScope in Business Logic Layer which we used to write the code in Controller class.
Here the example.
Must include this namespace  “System.Transactions”
public void AddMultipleUserSurvey(List<UserSurveyInfo> objUserSurveyInfoList, int userID)
        {
            using (TransactionScope objScope = new [...]

Read Full Post »

Handling Transactions in DotNetNuke Custom Module

taking a simple example,your application is handling not only DELETE the existing record, at the same time, it INSERT multiple records after the DELETION in SINGLE method you code in Controller Class.
Imagine your create a simple survey form which consist of a checkboxlist which allow the visitor do a simple survey. (they can check one [...]

Read Full Post »