XML is a universal format for data exchange, most of the data repository owners store their data in xml format, and apply XSLT to transform the XML from one format to another when required, I came across to a similar project, where we were storing everything in XML and then while processing the data we needed to display in other format.

Have written my own small transformation utility with extension object support.

 

Transform method:

/// <summary>
/// perform the XSLT transformation on the input xml and provides the transformed xml
/// </summary>
/// <param name=”transformation”>contains input xml, xslt path, and output xml</param>
public static void Transform(ITransformation transformation)
{
string sourceXML = transformation.SourceXML;
using (XmlReader reader = XmlReader.Create(new StringReader(sourceXML)))
{
//instead of initializing it with a new instance every time, get the transformation from the static cache.
//it will improve the load time of transformation object
XslCompiledTransform xslt = PrepareTransformationObject(transformation.XSLTName);

XsltArgumentList args = new XsltArgumentList();
//adding extension object, it will work as a helper method from XSLT
args.AddExtensionObject(“urn:Util”, new Util(transformation.XsltParameters));

StringWriter stringWriter = new StringWriter();
XmlTextWriter writer = new XmlTextWriter(stringWriter);

//applying tranform
xslt.Transform(reader, args, writer);

//set the output xml
transformation.DestinationXML = stringWriter.ToString();
}
}

 

This method stores the transformation object in static cache, so next time if you are using the same XSLT it will retrieve the object from cache instead of loading it again.

static Hashtable _xsltText = new Hashtable();

/// <summary>
/// Return the tranformation object, either create new or get from static cache if already available
/// </summary>
/// <param name=”transformationName”>full path of xslt</param>
/// <returns></returns>
static XslCompiledTransform PrepareTransformationObject(string transformationName)
{
if (_xsltText.ContainsKey(transformationName))
return (XslCompiledTransform)_xsltText[transformationName];
else
{
XslCompiledTransform xslt = new XslCompiledTransform();
xslt.Load(transformationName);
if (!_xsltText.ContainsKey(transformationName))
{
//you can lock the object if you face the concurrency issues
//lock (lockObj)
//{
_xsltText.Add(transformationName, xslt);
//}
}
return xslt;
}
}

 

Example using the above methods:

string xsltName = Server.MapPath(@”XSLT\Sample.xslt”);
string inputXML = XElement.Load(Server.MapPath(@”XML\input.xml”)).ToString();
string outputXML = string.Empty;

//passing the current date as transformation date, you can pass any object and then access it in util class.
XsltParam xsltParam = new XsltParam();
xsltParam.Params.Add(“TransactionDate”, DateTime.Now.ToShortDateString());

//prepare the tranformation container
TransformationContainer container = new TransformationContainer(xsltName, inputXML, outputXML, xsltParam);

TransformationHelper.Transform(container);

outputXML = container.DestinationXML;
XElement.Parse(outputXML).Save(Server.MapPath(@”XML\output.xml”));

Response.Write(outputXML);

 

Download the complete source XML-XSLT-TransformationSample.zip

 

Cheers!!

There are lots of error logging providers available such as Log4Net, AnLogger, etc. they are easy to use as well, but just to keep it simple, I have written my own. I call it “Activity and Error Logger”, it stores the data in xml format, request by request and session by session, you can actually create the user behaviour maps if you properly call the activity log at while performing any major operations. It also takes care of the concurrency, two threads will not overwrite each other. It logs the errors on page in try catch block and also at global level, in Application_Error event in global.asax

1)      Include the Logging.cs class in App_Code folder of your project

2)      Configure the web.config

3)      Set the Application_Error in global.asax

4)      Create the Logs_App and logs_Error folders in your project and you are done

5)      It creates one log file on hourly basis, one for Activities and one for Errors

6)      Now to log the activity or error, you just have to call the Logging.LogInfo or Logging. LogException functions in your code wherever required.

Logging asp.net

 

Logging.cs:

Include the Logging.cs class from the source code attached in this article

 

Web.config:

Add the below line in <configSections> if there is no configsections tag in your config, then create one right inside the <configuration> tag:

<configSections>

<section name=”ErrorHandling” type=”System.Configuration.DictionarySectionHandler”/>

</configSections>

Now add the below section after the config sections:

<ErrorHandling>

<!–set true to enable the logging–>

<add key=”EnableLogging” value=”true”/>

<!– path to log folders, DO create the folder in app directory –>

<add key=”ErrorLogFilesDir” value=”Logs_Error”/>

<add key=”AppLogFilesDir” value=”Logs_App”/>

</ErrorHandling>

 

Global.asax:

Replace the Application_Error with the below code:

void Application_Error(object sender, EventArgs e)

{

// Code that runs when an unhandled error occurs

Logging.LogException(Server.GetLastError(), “Global Error”);

}

 

Default.aspx where the activity log and error log is implemented:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace LoggingSample

{

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

GetData(123);

}

}

public void GetData(int userID)

{

try

{

//{get data from database by passing userid}

////to check if it logs the error throw an argument exception

//throw new ArgumentException(“generated error”);

//on success Log the activity

Logging.LogInfo(“Get successful for userid : ” + userID.ToString(), true);

}

catch (Exception ex)

{

//on error log the exception

Logging.LogException(ex, “Error in data bind”);

}

}

}

}

 

I have also made the admin part of the application, to create a report of activity logs, it applies the xslt on the activity log files and display them in a grid, you can extend it to create one for error log files too :

Loggingadmin asp.net

 

Download the complete source here LoggingSample.zip

 

Cheers!!

So far I have been in very dilemmatic situation whether to develop a native mobile application, having a buzz in the market to have mobile app for almost every application. I always wanted to try my hands on it, but somehow I never ever could start on it. Quite a few times I did setup IDE and SDKs to develop android application, but every time I started I could not carry on.

Being a web developer, always wanted to build the mobile application which will work on all platforms, but again a mini war between these mobile giants never encouraged a common SDK on IDE to develop the same.

To start my day, I always scan through all tech newsletters, 1 week back I found one article, Cross-Platform mobile applications using PhoneGap and JQuery (HTML5 and CSS3), as always curious to know about it, clicked through the link and read the article, understood the concept and somehow liked it so much, they kept it simple but effective. I was happy, finally I could start my mobile application, and deploy it on multiple platforms.

I created one simple app, and deployed the same on both android and iPhone, worked like a charm.

Visit phonegap.com and download, its FREE, read the instructions, that should get you going.

If you combine the power of PhoneGap and jQuery mobile, I bet you can develop nice UI as well as an application with a strong backend.

Recently heard that telerik has also launched an SDK Kendo UI, same concept, but like all telerik components its a paid product. visit kendoui.com

Questions? let me know.

Watch in 720 or 1080 px (HD) and switch to full screen:youtube.com/watch?v=uTwLf28KzEg

Better version : esnips.com/doc/c96fca47-8149-4c02-b1de-4ac48a47ee99/RegEx_In_SQL_V2

Download the source code here:RegEx-In-SqlServer.zip

Link  —  Posted: September 18, 2011 in CodeProject
Tags: , , , , ,

Node.js (nodejs.org) is an event-driven I/O server-side JavaScript environment based on V8. It is intended for writing scalable network programs such as web servers. It was created by Ryan Dahl in 2009, and its growth is sponsored by Joyent, which employs Dahl.

Wiki : en.wikipedia.org/wiki/Nodejs

Link  —  Posted: September 18, 2011 in CodeProject
Tags: , , , , , , ,

Yes, there are loads of context menu plugins already. But they require a fair amount of work to make them look good. This one is easy to use, small, and looks good.

joewalnes.com/2011/07/22/a-simple-good-looking-context-menu-for-jquery/

Link  —  Posted: July 31, 2011 in CodeProject
Tags: ,

Scriptographer ported to JavaScript and the browser, using HTML5 Canvas.

paperjs.org

Link  —  Posted: July 30, 2011 in CodeProject
Tags: , , , ,