Knowledge Gain

IBATIS.NET Developer Guide

2013-07-01T16:14:00.004+05:30

5. IBATIS.NET Developer Guide

5.1. Installing the Data Mapper for .NET

5.1.1. Setup the Distribution

You can download the latest version of IBATIS.NET from the below official site: http://code.google.com/p/mybatisnet/downloads/list

I'm going to download the IBatis.DataMapper.1.6.2.bin.zip

List of file found under the distribution's source folder of IBatis.DataMapper.1.6.2.bin.zip

Folder name	Description
Castle.DynamicProxy	Creating Proxy
IBatisNet.Common	Assembly of classes shared by DataAccess and DataMapper
IBatisNet.Common.Logging.Log4Net	Log4Net factory adapter classes
iBatisNet.DataMapper	The DataMapper framework
Log4Net	Log4Net factory adapter Base classes
providers.config	The database provider definition file (XML Configuration file)
sample.SqlMap.config	The Data Mapper configuration file (XML Configuration file)
SqlMap.xml	The Data Map definition file (XML Schema File)

5.1.2. Add Assembly References

Add references to the following files

1. Castle.DynamicProxy.dll

2. iBatisNet.DataMapper.dll

3. iBatisNet.Common.dll

IBatis.NET references

5.1.3. Add XML File Items

Add following xml files to your application

1. providers.config

2. sample.SqlMap.config

3. SqlMap.xml

IBatis.NET XML files

5.2. Provider Configuration File

I want to connect my application to SQL Server 2005, so removed all the other provider section and maintain "sqlServer2005" provider section alone.

Ensure that the enabled attribute is set to true; this is set to false by default in the sample installation files.

Provider Configuration

5.3. Data Mapper Configuration File

Create a copy of sample.SqlMap.config file and rename it with sqlMap.config

5.3.1. The Element

Name attribute from the "provider.config" file to be defined here based on any one of the database (SQL Server, Oracle, Access, and MySql).

Example:

5.3.2. The element

The element specifies ODBC datasource or connection string for any one database (SQL Server, Oracle, Access, and MySql).

5.3.3. The Element

elements for loading a set of Data Map definition. Note that the elements are nested in a element.

Example:

5.4. Create a map

Add another XML file to the root of your project called UsersMap.xml.

5.5. Building a SqlMapper Instance

The framework provides service methods that you can call which read the configuration file (and any of its definition files) and builds a SqlMapper object. The SqlMapper object provides access to the rest of the framework. The SqlMapper is designed to be multi-threaded and long-lived, and so makes for a good singleton.

Code:

using IBatisNet.Common.Utilities;

using IBatisNet.DataMapper;

using IBatisNet.DataMapper.Configuration;

namespace DataMapper

{

public class Mapper

{

private static volatile ISqlMapper _mapper = null;

protected static void Configure(object obj)

{

_mapper = null;

}

protected static void InitMapper()

{

ConfigureHandler handler = new ConfigureHandler(Configure);

DomSqlMapBuilder builder = new DomSqlMapBuilder();

_mapper = builder.ConfigureAndWatch(handler);

}

public static ISqlMapper Instance()

{

if (_mapper == null)

{

lock (typeof(SqlMapper))

{

if (_mapper == null) // double-check

{

InitMapper();

}

return _mapper;

}

public static ISqlMapper Get()

{

return Instance();

}

5.6. Code to execute IBATIS.Net

Code:

The DataLayer looks like below

using System;

using System.Collections.Generic;

using System.Web;

using System.Xml;

using IBatisNet.Common;

using IBatisNet.Common.Utilities;

using IBatisNet.DataMapper;

using IBatisNet.DataMapper.Configuration;

using DataMapper;

namespace IBATIS

{

public class DataLayer

{

public static IList<PVCSummary> PVCReport(string XMLPARAM, int PAGENUMBER, string PAGING)

{

parameters pm = new parameters();

pm.XMLPARAM = XMLPARAM;

pm.PAGENUMBER = PAGENUMBER;

pm.PAGING = PAGING;

IList<PLANNEDVSCOMPLETED> objPvCReport = DataMapper.Mapper.Instance()

.QueryForList<PLANNEDVSCOMPLETED>("PVCReport", pm);

return objPvCReport;

}

public class parameters

{

public virtual string XMLPARAM { get; set; }

public virtual int PAGENUMBER { get; set; }

public virtual string PAGING { get; set; }

}

The codebehind of aspx page as shown below

protected void Page_Load(object sender, EventArgs e)

{

string Param = ""; //xml parameter

IList<PLANNEDVSCOMPLETED> objReport = DataLayer.PVCReport(Param, 1, "Y");

lstvw.DataSource = objReport; //assign result object directly to listview datasource

lstvw.DataBind()

}

Generate class and properties at runtime

2013-07-01T15:45:00.002+05:30

To generate a class and properties at run-time.

using System;

using System.Data;

using System.Reflection;

using System.Collections.Generic;

namespace ReportEngine

{

class Program

{

static void Main(string[] args)

{

DataTable table = InputGeneration.GetTable();

//InputGeneration.DisplayTable(table);

#region "Method2 - Generate class and properties alone at runtime"

Console.WriteLine("\n---Method2 - Generate class and properties alone at runtime--------------\n");

IEnumerableDynamicProperty> properties = Method2.GenerateProperties(table);

Type type = Method2.GenerateClass(properties);

//The below combination will return all non-public instance properties on the type.

var flags = BindingFlags.Instance | BindingFlags.Public | BindingFlags.NonPublic;

PropertyInfo[] props = type.GetProperties(flags);

for (int i = 0; i < props.Length; i++)

{

Console.Write("\t{0}\t", props[i].Name);

}

Console.WriteLine("\t");

Method2 m2 = new Method2();

m2.AssignClassValues(type, table);

#endregion

Console.WriteLine("\n---------------------------------------------------------\n");

Console.ReadLine();

}

InputGeneration:

using System;

using System.Data;

namespace ReportEngine

{

public static class InputGeneration

{

public static DataTable GetTable()

{

// Here we create a DataTable with four columns.

DataTable table = new DataTable();

table.Columns.Add("Dosage", typeof(int));

table.Columns.Add("Drug", typeof(string));

table.Columns.Add("Patient", typeof(string));

table.Columns.Add("Date", typeof(DateTime));

// Here we add five DataRows.

table.Rows.Add(25, "Indocin", "David", DateTime.Now);

table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now);

table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now);

table.Rows.Add(21, "Combivent", "Janet", DateTime.Now);

table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Now);

return table;

}

public static void DisplayTable(DataTable dt)

{

if (dt.Rows.Count > 0)

{

foreach (DataColumn column in dt.Columns)

{

Console.Write("\t{0}\t", column.ColumnName);

}

Console.WriteLine("\t");

foreach (DataRow row in dt.Rows)

{

foreach (DataColumn column in dt.Columns)

Console.Write("\t{0}\t", row[column]);

Console.WriteLine("\t");

}

else

Console.WriteLine("No Current Rows Found");

}

Method2:

using System;

using System.Data;

using System.Collections.Generic;

using ReportEngine.ClassAtRuntime;

using System.Reflection;

namespace ReportEngine

{

public class Method2

{

public static IEnumerable<DynamicProperty> GenerateProperties(DataTable table)

{

List<DynamicProperty> Properties = new List<DynamicProperty>();

foreach (DataColumn column in table.Columns)

{

Properties.Add(new DynamicProperty(column.ColumnName.ToUpper(), column.DataType));

}

return Properties;

}

public static Type GenerateClass(IEnumerable<DynamicProperty> properties)

{

Type type = Dynamic.CreateClass(properties);

return type;

}

public void AssignClassValues(Type type, DataTable table)

{

List<object> lstobj = new List<object>();

foreach (DataRow dr in table.Rows)

{

var obj = Activator.CreateInstance(type);

PropertyInfo[] props = obj.GetType().GetProperties();

for (int i = 0; i < props.Length; i++)

{

if (props[i].CanWrite)

{

try

{

if (dr[props[i].Name] != null && !dr.IsNull(props[i].Name))

{

props[i].SetValue(obj, dr[props[i].Name], null);

}

else

{

props[i].SetValue(props[i].Name, null, null);

}

catch // DB COLUMN does not exist for this property.

{

props[i].SetValue(props[i].Name, null, null);

}

lstobj.Add(obj);

}

public void ReadClassValues(List<object> lstobj)

{

foreach (object obj in lstobj)

{

}

public void getModelFromObject(Type type, DataTable table)

{

List el = new List();

foreach (DataRow dr in table.Rows)

{

T item = (T)Activator.CreateInstance(type);

getObject(dr, ref item, table);

T tsts = item;

((List)el).Add(item);

}

public void getObject(DataRow dr, ref T obj, DataTable dt)

{

foreach (DataColumn dc in dt.Columns)

{

if (obj.GetType().GetProperty(dc.ColumnName) != null)

{

obj.GetType().GetProperty(dc.ColumnName).SetValue(obj, dr[dc.ColumnName], null);

}

DynamicClasswithProperties:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Reflection;

using System.Reflection.Emit;

using System.Threading;

namespace ReportEngine.ClassAtRuntime

{

class DynamicClasswithProperties

{

}

public abstract class DynamicClass

{

public override string ToString()

{

PropertyInfo[] props = this.GetType().GetProperties(BindingFlags.Instance | BindingFlags.Public);

StringBuilder sb = new StringBuilder();

sb.Append("{");

for (int i = 0; i < props.Length; i++)

{

if (i > 0) sb.Append(", ");

sb.Append(props[i].Name);

sb.Append("=");

sb.Append(props[i].GetValue(this, null));

}

sb.Append("}");

return sb.ToString();

}

public class DynamicProperty

{

string name;

Type type;

public DynamicProperty(string name, Type type)

{

if (name == null) throw new ArgumentNullException("name");

if (type == null) throw new ArgumentNullException("type");

this.name = name;

this.type = type;

}

public string Name

{

get { return name; }

}

public Type Type

{

get { return type; }

}

public static class Dynamic

{

public static Type CreateClass(IEnumerable<DynamicProperty> properties)

{

return ClassFactory.Instance.GetDynamicClass(properties);

}

internal class Signature : IEquatable<Signature>

{

public DynamicProperty[] properties;

public int hashCode;

public Signature(IEnumerable<DynamicProperty> properties)

{

this.properties = properties.ToArray();

hashCode = 0;

foreach (DynamicProperty p in properties)

{

hashCode ^= p.Name.GetHashCode() ^ p.Type.GetHashCode();

}

public override int GetHashCode()

{

return hashCode;

}

public override bool Equals(object obj)

{

return obj is Signature ? Equals((Signature)obj) : false;

}

public bool Equals(Signature other)

{

if (properties.Length != other.properties.Length) return false;

for (int i = 0; i < properties.Length; i++)

{

if (properties[i].Name != other.properties[i].Name ||

properties[i].Type != other.properties[i].Type) return false;

}

return true;

}

internal class ClassFactory

{

public static readonly ClassFactory Instance = new ClassFactory();

static ClassFactory() { } // Trigger lazy initialization of static fields

ModuleBuilder module;

Dictionary<Signature, Type> classes;

int classCount;

ReaderWriterLock rwLock;

private ClassFactory()

{

AssemblyName name = new AssemblyName("DynamicClasses");

AssemblyBuilder assembly = AppDomain.CurrentDomain.DefineDynamicAssembly(name, AssemblyBuilderAccess.Run);

#if ENABLE_LINQ_PARTIAL_TRUST

new ReflectionPermission(PermissionState.Unrestricted).Assert();

#endif

try

{

module = assembly.DefineDynamicModule("Module");

}

finally

{

#if ENABLE_LINQ_PARTIAL_TRUST

PermissionSet.RevertAssert();

#endif

}

classes = new Dictionary<Signature, Type>();

rwLock = new ReaderWriterLock();

}

public Type GetDynamicClass(IEnumerable<DynamicProperty> properties)

{

rwLock.AcquireReaderLock(Timeout.Infinite);

try

{

Signature signature = new Signature(properties);

Type type;

if (!classes.TryGetValue(signature, out type))

{

type = CreateDynamicClass(signature.properties);

classes.Add(signature, type);

}

return type;

}

finally

{

rwLock.ReleaseReaderLock();

}

Type CreateDynamicClass(DynamicProperty[] properties)

{

LockCookie cookie = rwLock.UpgradeToWriterLock(Timeout.Infinite);

try

{

string typeName = "DynamicClass" + (classCount + 1);

#if ENABLE_LINQ_PARTIAL_TRUST

new ReflectionPermission(PermissionState.Unrestricted).Assert();

#endif

try

{

TypeBuilder tb = this.module.DefineType(typeName, TypeAttributes.Class |

TypeAttributes.Public, typeof(DynamicClass));

FieldInfo[] fields = GenerateProperties(tb, properties);

GenerateEquals(tb, fields);

GenerateGetHashCode(tb, fields);

Type result = tb.CreateType();

classCount++;

return result;

}

finally

{

#if ENABLE_LINQ_PARTIAL_TRUST

PermissionSet.RevertAssert();

#endif

}

finally

{

rwLock.DowngradeFromWriterLock(ref cookie);

}

FieldInfo[] GenerateProperties(TypeBuilder tb, DynamicProperty[] properties)

{

FieldInfo[] fields = new FieldBuilder[properties.Length];

for (int i = 0; i < properties.Length; i++)

{

DynamicProperty dp = properties[i];

FieldBuilder fb = tb.DefineField("_" + dp.Name, dp.Type, FieldAttributes.Private);

PropertyBuilder pb = tb.DefineProperty(dp.Name, PropertyAttributes.HasDefault, dp.Type, null);

MethodBuilder mbGet = tb.DefineMethod("get_" + dp.Name,

MethodAttributes.Public | MethodAttributes.SpecialName | MethodAttributes.HideBySig,

dp.Type, Type.EmptyTypes);

ILGenerator genGet = mbGet.GetILGenerator();

genGet.Emit(OpCodes.Ldarg_0);

genGet.Emit(OpCodes.Ldfld, fb);

genGet.Emit(OpCodes.Ret);

MethodBuilder mbSet = tb.DefineMethod("set_" + dp.Name,

MethodAttributes.Public | MethodAttributes.SpecialName | MethodAttributes.HideBySig,

null, new Type[] { dp.Type });

ILGenerator genSet = mbSet.GetILGenerator();

genSet.Emit(OpCodes.Ldarg_0);

genSet.Emit(OpCodes.Ldarg_1);

genSet.Emit(OpCodes.Stfld, fb);

genSet.Emit(OpCodes.Ret);

pb.SetGetMethod(mbGet);

pb.SetSetMethod(mbSet);

fields[i] = fb;

}

return fields;

}

void GenerateEquals(TypeBuilder tb, FieldInfo[] fields)

{

MethodBuilder mb = tb.DefineMethod("Equals",

MethodAttributes.Public | MethodAttributes.ReuseSlot |

MethodAttributes.Virtual | MethodAttributes.HideBySig,

typeof(bool), new Type[] { typeof(object) });

ILGenerator gen = mb.GetILGenerator();

LocalBuilder other = gen.DeclareLocal(tb);

Label next = gen.DefineLabel();

gen.Emit(OpCodes.Ldarg_1);

gen.Emit(OpCodes.Isinst, tb);

gen.Emit(OpCodes.Stloc, other);

gen.Emit(OpCodes.Ldloc, other);

gen.Emit(OpCodes.Brtrue_S, next);

gen.Emit(OpCodes.Ldc_I4_0);

gen.Emit(OpCodes.Ret);

gen.MarkLabel(next);

foreach (FieldInfo field in fields)

{

Type ft = field.FieldType;

Type ct = typeof(EqualityComparer<>).MakeGenericType(ft);

next = gen.DefineLabel();

gen.EmitCall(OpCodes.Call, ct.GetMethod("get_Default"), null);

gen.Emit(OpCodes.Ldarg_0);

gen.Emit(OpCodes.Ldfld, field);

gen.Emit(OpCodes.Ldloc, other);

gen.Emit(OpCodes.Ldfld, field);

gen.EmitCall(OpCodes.Callvirt, ct.GetMethod("Equals", new Type[] { ft, ft }), null);

gen.Emit(OpCodes.Brtrue_S, next);

gen.Emit(OpCodes.Ldc_I4_0);

gen.Emit(OpCodes.Ret);

gen.MarkLabel(next);

}

gen.Emit(OpCodes.Ldc_I4_1);

gen.Emit(OpCodes.Ret);

}

void GenerateGetHashCode(TypeBuilder tb, FieldInfo[] fields)

{

MethodBuilder mb = tb.DefineMethod("GetHashCode",

MethodAttributes.Public | MethodAttributes.ReuseSlot |

MethodAttributes.Virtual | MethodAttributes.HideBySig,

typeof(int), Type.EmptyTypes);

ILGenerator gen = mb.GetILGenerator();

gen.Emit(OpCodes.Ldc_I4_0);

foreach (FieldInfo field in fields)

{

Type ft = field.FieldType;

Type ct = typeof(EqualityComparer<>).MakeGenericType(ft);

gen.EmitCall(OpCodes.Call, ct.GetMethod("get_Default"), null);

gen.Emit(OpCodes.Ldarg_0);

gen.Emit(OpCodes.Ldfld, field);

gen.EmitCall(OpCodes.Callvirt, ct.GetMethod("GetHashCode", new Type[] { ft }), null);

gen.Emit(OpCodes.Xor);

}

gen.Emit(OpCodes.Ret);

}

Predefined class and generate properties alone at runtime

2013-07-01T15:06:00.002+05:30

To generate a properties at run-time and using pre-defined class.

using System;

using System.Data;

using System.Reflection;

using System.Collections.Generic;

namespace ReportEngine

{

class Program

{

static void Main(string[] args)

{

DataTable table = InputGeneration.GetTable();

//InputGeneration.DisplayTable(table);

#region "Method1 - Predefined class and generate properties alone at runtime"

Console.WriteLine("\n---Method1 - Predefined class and generate properties alone at runtime------\n");

List<string> PropertyNames = Method1.GenerateProperties(table);

ListDynamicClass> DynamicClassList = Method1.GenerateClass(PropertyNames, table);

Method1.DisplayClass(DynamicClassList, PropertyNames);

#endregion

Console.WriteLine("\n---------------------------------------------------------\n");

Console.ReadLine();

}

InputGeneration:

using System;

using System.Data;

namespace ReportEngine

{

public static class InputGeneration

{

public static DataTable GetTable()

{

// Here we create a DataTable with four columns.

DataTable table = new DataTable();

table.Columns.Add("Dosage", typeof(int));

table.Columns.Add("Drug", typeof(string));

table.Columns.Add("Patient", typeof(string));

table.Columns.Add("Date", typeof(DateTime));

// Here we add five DataRows.

table.Rows.Add(25, "Indocin", "David", DateTime.Now);

table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now);

table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now);

table.Rows.Add(21, "Combivent", "Janet", DateTime.Now);

table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Now);

return table;

}

public static void DisplayTable(DataTable dt)

{

if (dt.Rows.Count > 0)

{

foreach (DataColumn column in dt.Columns)

{

Console.Write("\t{0}\t", column.ColumnName);

}

Console.WriteLine("\t");

foreach (DataRow row in dt.Rows)

{

foreach (DataColumn column in dt.Columns)

Console.Write("\t{0}\t", row[column]);

Console.WriteLine("\t");

}

else

Console.WriteLine("No Current Rows Found");

}

Method1:

using System;

using System.Data;

using System.Collections.Generic;

using ReportEngine.PropertyAtRuntime;

namespace ReportEngine

{

public static class Method1

{

public static List<string> GenerateProperties(DataTable table)

{

List<string> PropertyNames = new List<string>();

foreach (DataColumn column in table.Columns)

{

PropertyNames.Add(column.ColumnName.ToUpper());

}

return PropertyNames;

}

public static List<DynamicClass> GenerateClass(List<string> PropertyNames, DataTable table)

{

List<DynamicClass> DynamicClassList = new List<DynamicClass>();

foreach (DataRow row in table.Rows)

{

var dynamicClass = new DynamicClass();

foreach (string PropertyName in PropertyNames)

{

dynamicClass.property[PropertyName] = row[PropertyName].ToString();

}

DynamicClassList.Add(dynamicClass);

}

return DynamicClassList;

}

public static void DisplayClass(List<DynamicClass> DynamicClassList, List<string> PropertyNames)

{

foreach (string PropertyName in PropertyNames)

{

Console.Write("{0}\t", PropertyName);

}

Console.WriteLine("\n");

foreach (DynamicClass dynamicClass in DynamicClassList)

{

foreach (string PropertyName in PropertyNames)

{

Console.Write("{0}\t", dynamicClass.property[PropertyName]);

}

Console.WriteLine("\n");

}

DynamicClass:

using System;

namespace ReportEngine.PropertyAtRuntime

{

public class DynamicClass

{

// property is a class that will create dynamic properties at runtime

private DynamicProperty _property = new DynamicProperty();

public DynamicProperty property

{

get { return _property; }

set { _property = value; }

}

DynamicProperty:

using System;

using System.Collections.Generic;

namespace ReportEngine.PropertyAtRuntime

{

public class DynamicProperty

{

// a Dictionary that hold all the dynamic property values

private Dictionary<string, object> properties = new Dictionary<string, object>();

// the property call to get any dynamic property in our Dictionary, or "" if none found.

public object this[string name]

{

get

{

if (properties.ContainsKey(name))

{

return properties[name];

}

return "";

}

set

{

properties[name] = value;

}

2013-03-06T09:38:00.000+05:30

Read csv file and import its data into List(object) with Linq

           var arrTitle = File.ReadAllLines(csvFileFolderPath)
                                .Select(x => x.Split(','))
                                .First();

            List lstUser = File.ReadAllLines(csvFileFolderPath)
                                                .Select(x => x.Split(','))
                                                .Skip(1)
                                                .Select(x =>
                                                     new Users
                                                     {
                                                         USERID = x[0],
                                                         LASTNAME = x[1],
                                                         FIRSTNAME = x[2],
                                                         PASSWORD = x[3]
                                                     }).ToList ();

Read csv file and import its data into Datatable with Linq

            DataTable dt = new DataTable();

            var c1 = File.ReadAllLines(csvFileFolderPath)
                                    .Select(x => x.Split(','))
                                    .First().ToArray();

            var col = from cl in c1
                        select new DataColumn(cl);

            dt.Columns.AddRange(col.ToArray());

            var tableData = File.ReadAllLines(csvFileFolderPath)
                                .Select(x => x.Split(','))
                                .Skip(1)
                                .ToList();

            (from st in tableData
                    select dt.Rows.Add(st)).ToList();

Class File:

Public class Users
{
public virtual string USERID { get; set; }
      public virtual string LASTNAME { get; set; }
      public virtual string FIRSTNAME { get; set; }
      public virtual string PASSWORD { get; set; }
}

A Simple String Compression Algorithm

2013-03-06T09:01:00.000+05:30

Data compression is always useful for encoding information using fewer bits than the original representation it would use. There are many applications where the size of information would be critical. In data communication, the size of data can affect the cost too.

Form Code-Behind:

public byte[] ret;
SixBitEnDec obj = new SixBitEnDec();

private void Form1_Load(object sender, EventArgs e)
{
btnDecrypt.Enabled = false;
}

private void btnEncrypt_Click_1(object sender, EventArgs e)
{
ret = obj.encode(txtInput.Text, Convert.ToInt32(txtbit.Text));
     btnDecrypt.Enabled = true;
}

private void btnDecrypt_Click(object sender, EventArgs e)
{
txtResult.Text = obj.decode(ret, Convert.ToInt32(txtbit.Text));
}

Class File:

public class SixBitEnDec
    {
        static public int SIX_BIT = 6;
        static public int FIVE_BIT = 5;

        public SixBitEnDec() {

        }

        public byte[] encode(String txt, int bit)
        {
            int length = txt.Length;
            float tmpRet1 = 0, tmpRet2 = 0;

            if (bit == 6)
            {
                tmpRet1 = 3.0f;
                tmpRet2 = 4.0f;
            }
            else if (bit == 5)
            {
                tmpRet1 = 5.0f;
                tmpRet2 = 8.0f;
            }

            byte[] encoded = new byte[(int)(tmpRet1 * Math.Ceiling(length / tmpRet2))];
            char[] str = new char[length];

            int startIndex = 0;
            char[] chars = txt
                  .Where((c, i) => i >= startIndex && i < startIndex + length).ToArray();

            String temp;
            String strBinary = string.Empty;

            for (int i = 0; i < length; i++)
            {
                temp = Convert.ToString((toValue(chars[i])), 2);
                while (temp.Length % bit != 0)
                {
                    temp = "0" + temp;
                }
                strBinary = strBinary + temp;
            }

            while (strBinary.Length % 8 != 0)
            {
                strBinary = strBinary + "0";
            }

            Int32 tempInt = 0;
            for (int i = 0; i < strBinary.Length; i = i + 8)
            {
                tempInt = Convert.ToInt32(strBinary.Substring(i, 8), 2);
                encoded[i / 8] = Convert.ToByte(tempInt);
            }
            return encoded;
        }

        public String decode(byte[] encoded, int bit)
        {
            String strTemp = string.Empty;
            String strBinary = string.Empty;
            String strText = string.Empty;
            Int32 tempInt = 0;
            Int32 intTemp = 0;

            for (int i = 0; i < encoded.Length; i++)
            {
                if (encoded[i] < 0)
                {
                    intTemp = (int)encoded[i] + 256;
                }
                else
                    intTemp = (int)encoded[i];

                strTemp = Convert.ToString(intTemp, 2);

                while (strTemp.Length % 8 != 0)
                {
                    strTemp = "0" + strTemp;
                }
                strBinary = strBinary + strTemp;
            }
            for (int i = 0; i < strBinary.Length; i = i + bit)
            {
                tempInt = Convert.ToInt32(strBinary.Substring(i, bit), 2);
                strText = strText + toChar(Convert.ToInt32(tempInt));
            }
            return strText;
        }

        int toValue(char ch)
        {
            int chaVal = 0;
            switch (ch)
            {
                case ' ': chaVal = 0; break;
                case 'a': chaVal = 1; break;
                case 'b': chaVal = 2; break;
                case 'c': chaVal = 3; break;
                case 'd': chaVal = 4; break;
                case 'e': chaVal = 5; break;
                case 'f': chaVal = 6; break;
                case 'g': chaVal = 7; break;
                case 'h': chaVal = 8; break;
                case 'i': chaVal = 9; break;
                case 'j': chaVal = 10; break;
                case 'k': chaVal = 11; break;
                case 'l': chaVal = 12; break;
                case 'm': chaVal = 13; break;
                case 'n': chaVal = 14; break;
                case 'o': chaVal = 15; break;
                case 'p': chaVal = 16; break;
                case 'q': chaVal = 17; break;
                case 'r': chaVal = 18; break;
                case 's': chaVal = 19; break;
                case 't': chaVal = 20; break;
                case 'u': chaVal = 21; break;
                case 'v': chaVal = 22; break;
                case 'w': chaVal = 23; break;
                case 'x': chaVal = 24; break;
                case 'y': chaVal = 25; break;
                case 'z': chaVal = 26; break;
                case '.': chaVal = 27; break;
                case '*': chaVal = 28; break;
                case ',': chaVal = 29; break;
                case '\'': chaVal = 30; break;
                case '2': chaVal = 31; break;
                case 'A': chaVal = 32; break;
                case 'B': chaVal = 33; break;
                case 'C': chaVal = 34; break;
                case 'D': chaVal = 35; break;
                case 'E': chaVal = 36; break;
                case 'F': chaVal = 37; break;
                case 'G': chaVal = 38; break;
                case 'H': chaVal = 39; break;
                case 'I': chaVal = 40; break;
                case 'J': chaVal = 41; break;
                case 'K': chaVal = 42; break;
                case 'L': chaVal = 43; break;
                case 'M': chaVal = 44; break;
                case 'N': chaVal = 45; break;
                case 'O': chaVal = 46; break;
                case 'P': chaVal = 47; break;
                case 'Q': chaVal = 48; break;
                case 'R': chaVal = 49; break;
                case 'S': chaVal = 50; break;
                case 'T': chaVal = 51; break;
                case 'U': chaVal = 52; break;
                case 'V': chaVal = 53; break;
                case 'W': chaVal = 54; break;
                case '0': chaVal = 55; break;
                case '1': chaVal = 56; break;
                case '3': chaVal = 57; break;
                case '4': chaVal = 58; break;
                case '5': chaVal = 59; break;
                case '6': chaVal = 60; break;
                case '7': chaVal = 61; break;
                case '8': chaVal = 62; break;
                case '9': chaVal = 63; break;
                default: chaVal = 0; break;

            }
            return chaVal;
        }

        char toChar(int val)
        {
            char ch = ' ';
            switch (val)
            {
                case 0: ch = ' '; break;
                case 1: ch = 'a'; break;
                case 2: ch = 'b'; break;
                case 3: ch = 'c'; break;
                case 4: ch = 'd'; break;
                case 5: ch = 'e'; break;
                case 6: ch = 'f'; break;
                case 7: ch = 'g'; break;
                case 8: ch = 'h'; break;
                case 9: ch = 'i'; break;
                case 10: ch = 'j'; break;
                case 11: ch = 'k'; break;
                case 12: ch = 'l'; break;
                case 13: ch = 'm'; break;
                case 14: ch = 'n'; break;
                case 15: ch = 'o'; break;
                case 16: ch = 'p'; break;
                case 17: ch = 'q'; break;
                case 18: ch = 'r'; break;
                case 19: ch = 's'; break;
                case 20: ch = 't'; break;
                case 21: ch = 'u'; break;
                case 22: ch = 'v'; break;
                case 23: ch = 'w'; break;
                case 24: ch = 'x'; break;
                case 25: ch = 'y'; break;
                case 26: ch = 'z'; break;
                case 27: ch = '.'; break;
                case 28: ch = '*'; break;
                case 29: ch = ','; break;
                case 30: ch = '\''; break;
                case 31: ch = '2'; break;
                case 32: ch = 'A'; break;
                case 33: ch = 'B'; break;
                case 34: ch = 'C'; break;
                case 35: ch = 'D'; break;
                case 36: ch = 'E'; break;
                case 37: ch = 'F'; break;
                case 38: ch = 'G'; break;
                case 39: ch = 'H'; break;
                case 40: ch = 'I'; break;
                case 41: ch = 'J'; break;
                case 42: ch = 'K'; break;
                case 43: ch = 'L'; break;
                case 44: ch = 'M'; break;
                case 45: ch = 'N'; break;
                case 46: ch = 'O'; break;
                case 47: ch = 'P'; break;
                case 48: ch = 'Q'; break;
                case 49: ch = 'R'; break;
                case 50: ch = 'S'; break;
                case 51: ch = 'T'; break;
                case 52: ch = 'U'; break;
                case 53: ch = 'V'; break;
                case 54: ch = 'W'; break;
                case 55: ch = '0'; break;
                case 56: ch = '1'; break;
                case 57: ch = '3'; break;
                case 58: ch = '4'; break;
                case 59: ch = '5'; break;
                case 60: ch = '6'; break;
                case 61: ch = '7'; break;
                case 62: ch = '8'; break;
                case 63: ch = '9'; break;
                default: ch = ' '; break;
            }
            return ch;
        }
    }

Note:
Above code works fine for 6 bit encryption and decryption. Shortly i'll upload the code for 5 bit also.

For Referrences:
http://www.codeproject.com/Articles/223610/A-Simple-String-Compression-Algorithm

Dynamically create ListView and thier templates at runtime

2013-01-08T13:18:00.002+05:30

I have created a Composite control, which contains a listview to display a table of items. I am using a ListView in Asp.NET and define the templates in the code-behind.

using System;
using System.Web;
using System.Web.UI;

public partial class Report1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
      {
    }

    protected override void CreateChildControls()
        {
            base.CreateChildControls();

            ListView view = new ListView();

        view.ID = "view";
            view.LayoutTemplate = new LayoutTemplate();
        view.GroupTemplate = new GroupTemplate();
            view.ItemTemplate = new ItemTemplate();

            view.DataSource = FibonacciSequence();    //assign List objects for custom design
            view.DataBind();

            pnl.Controls.Add(view);
        }

    public int Iterations { get; set; }

    private IEnumerable FibonacciSequence()
      {
            int i1 = 0;
            int i2 = 1;
            Iterations = 5;
            for (int i = 0; i < Iterations; i++)
            {
                yield return i1 + i2;
                int temp = i1 + i2;
                i1 = i2;
                i2 = temp;
            }
            yield break;
      }

    public class LayoutTemplate : ITemplate
      {
            public void InstantiateIn(Control container)
            {
                var div = new HtmlGenericControl("div") { ID = "groupPlaceholder" };
                container.Controls.Add(div);
            }
      }

    public class GroupTemplate : ITemplate
      {
            public void InstantiateIn(Control container)
            {
                var tbl1 = new HtmlGenericControl("table");
                tbl1.Attributes.Add("cellpadding", "0");
                tbl1.Attributes.Add("cellspacing", "0");
                tbl1.Attributes.Add("border", "0");
                tbl1.Attributes.Add("class", "tblBorder");
                tbl1.Attributes.Add("width", "100%");
                var tr1 = new HtmlGenericControl("tr");
                var td1 = new HtmlGenericControl("td");
                td1.Style.Add("padding", "5px");

                var tbl2 = new HtmlGenericControl("table");
                tbl2.Attributes.Add("cellpadding", "3px");
                tbl2.Attributes.Add("cellspacing", "0");
                tbl2.Attributes.Add("border", "0");
                tbl2.Attributes.Add("width", "100%");
                var tr2 = new HtmlGenericControl("tr") { ID = "itemPlaceholder" };

                tbl2.Controls.Add(tr2);
                td1.Controls.Add(tbl2);
                tr1.Controls.Add(td1);
                tbl1.Controls.Add(tr1);
                container.Controls.Add(tbl1);
            }
      }

        public class ItemTemplate : ITemplate
      {
            public void InstantiateIn(Control container)
            {
                var tr = new HtmlGenericControl("tr");
                tr.DataBinding += DataBinding;
                container.Controls.Add(tr);
            }

            public void DataBinding(object sender, EventArgs e)
            {
                var container = (HtmlGenericControl)sender;
                var dataItem = ((ListViewDataItem)container.NamingContainer).DataItem;

                container.Controls.Add( new Literal(){Text = dataItem.ToString() });

            //For custom design
            //container.Controls.Add( new Literal(){Text = GetValue(dataItem) });
            }

        protected string GetValue(object obj)
            {
            //parse object and do customized design

            PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(obj.GetType());

                    string SVALUE, SNAME = string.Empty;

            foreach (PropertyDescriptor prop in properties)
                    {
                        if (prop.GetValue(obj) != null)
                        {
                            SVALUE = prop.GetValue(obj).ToString() ?? DBNull.Value.ToString();
                            SNAME = prop.Name;
                }
            }
        }
        }
}

Group by and Sub group in Linq

2012-12-07T17:58:00.001+05:30

Created a result set (Using IBATIS.NET Datamapper technology to load object using Stored Procedure method) as on object.

IList<CLASS1> objReport1 = new List<CLASS1>();

IList<CLASS> objReportBase = DataLayer.MethodName(strParam, 1, "N");

if (objReportBase.Count > 0)

{

objReportNew = (from p in objReportBase

group p by new

{

p.USERID,

p.DISPLAYUSERID,

p.LASTNAME,

p.FIRSTNAME

} into g

orderby g.Key.LASTNAME, g.Key.SUITENAME

select new CLASS1

{

USERID = g.Key.USERID,

DISPLAYUSERID = g.Key.DISPLAYUSERID,

LASTNAME = g.Key.LASTNAME,

FIRSTNAME = g.Key.FIRSTNAME,

subPVCs = g.Select(l => new

{

l.COURSENAME,

l.MASTEREDDATE,

l.ASSIGNEDDATE,

l.MASTEREDSCORE,

}

).Distinct()

}).ToList<CLASS1>();

objReportBase = null;

}

public class BASECLASS

{

public virtual int USERID { get; set; }

public virtual string DISPLAYUSERID { get; set; }

public virtual string LASTNAME { get; set; }

public virtual string FIRSTNAME { get; set; }

public virtual string COURSENAME { gets; set; }

public virtual string MASTEREDDATE { get; set; }

public virtual string ASSIGNEDDATE { get; set; }

public virtual string MASTEREDSCORE { get; set; }

}

public class CLASS1

{

public virtual int USERID { get; set; }

public virtual string DISPLAYUSERID { get; set; }

public virtual string LASTNAME { get; set; }

public virtual string FIRSTNAME { get; set; }

public virtual IEnumerable subPVCs { get; set; }

}

public class subPVC

{

public virtual int USERID { get; set; }

public virtual string COURSENAME { gets; set; }

public virtual string MASTEREDDATE { get; set; }

public virtual string ASSIGNEDDATE { get; set; }

public virtual string MASTEREDSCORE { get; set; }

}

TOP 10 USEFULL MOBILE APPLICATION

2012-11-15T14:01:00.000+05:30

1) UNIVERSAL REMOTES - As smartphones don't have IR emitters, one has to install a dongle. MP3 mobile accessory (Rs 350) to be connected to the phone's 3.5 mm jack. Dijit Universal Remote for iOS needs to be paired with Griffin Technology's Beacon.

2) BUSINESS CARDS - scan business cards and copy the information on the card to the phone as well as on the cloud.
            i) CamCard
            ii) ScanBizCards
            iii) WorldCard Mobile

3) YOUR CAR KEY - This remote key comes in the form of the Viper SmartStart app for iOS, Android and BlackBerry smartphones. But it requires you to have the Viper Smart Start GPS device that costs around $400 (about Rs 21,200). You need to download the free app and pair it with the GPS device.

4) MEASURING TAPES - These commonly use trigonometry to calculate distances while some use GPS, better for irregular surfaces or areas.

5) HEALTH AND FITNESS GUIDES - You can find free yoga, cardio, weight training and other fitness guides in the application markets for Android and iOS.

6) PHYSICAL SWITCHES - This could be a little in the future.
            The Crestron Mobile control app for iPhone, iPad and Android devices does involve a sizable investment but it's worth it if you have the cash to spare.

7) YOUR WALLET - With Near-Field Communication (NFC) hardware coming to smartphones, everyone is expecting a gradual decline in the use of plastic cards and cash.

8) BARCODE AND QR READERS - Barcodes and QR codes are ubiquitous.

9) WI-FI ROUTERS - If you own the latest Android or Windows smartphone, you can use the phone's data connection to create a secure Wi-Fi network of your own. This option is available in your settings menu as 'Wi-Fi hotspot, Internet tethering or Internet sharing'. You can secure this network with a password and connect up to five devices to surf the Net.

10) CABLE TELEVISION - There are apps that enable you to stream live television onto a handset. Zenga TV, ditto TV, mimobiTV, MunduTV are some popular live streaming apps.

The iBATIS frameworks

2012-10-29T17:55:00.000+05:30

iBATIS consists of two separate frameworks

1. Data Mapper framework: specifically for OR mapping, Executes your SQL and maps the results back to .Net domain objects
2. DAO (Data Access objects) framework: gives your application a clean and consistent way to access underlying data.

Post data via Jquery ajax and response as Json in asp.net

2012-10-25T16:43:00.000+05:30

Populate select list dynamically using jquery ajax postback and return the string from process page as json.

Html page:

// Jquery script to be include in the page
<script type="text/javascript" src="folderpath/jquery-1.8.0.js"></script>

//Html controls on the page


<input type="button" id="btnGo" value="Click to Show Records - JSON"  />



<select id="lstUserList" name="lstUserList" size="12" multiple="multiple">

 <option value="" text="none"></option>

</select>

Javascript function:


<script type="text/javascript">



    $(document).ready(function() {

        $('#btnGo').click(function(){

  //clearing select options

            $('#lstUserList').empty();



            var hdndata = "test";// data to post for the process page

    

            var post = "hdndata=" + hdndata;

    

            $.ajax({

                type: "POST",

                url: "folderpath/pagename.aspx",

                data: post,

                contentType: "application/x-www-form-urlencoded; charset=UTF-8",

                dataType: "json",

                success: function(msg) {

                    $(outputlist(msg.Table));

                }

            });

        });

    });



    function outputlist(dataTable)

    {

        var listItems = [];

        for (var row in dataTable)

        {

            var strData = '';

            strData = dataTable[row]["LASTNAME"] + ' ' + dataTable[row]["FIRSTNAME"] + ' (' + dataTable[row]["DISPLAYUSERID"] + ')';

            listItems.push('<option class="ACTIVE' + dataTable[row]["CSSCLASS"] + '" value="' + dataTable[row]["USERID"] + '" title="' + strData + '">' + strData + '</option>');

        }

        $('#lstUserList').append(listItems.join(''));

    }

</script>

Process page:

'Process input parameter and get the result as dataset and pass it to the method ToJson on JsonMethods class

dim ds as new dataset
ds = obj.methodname(parameter)
Response.Write(JsonMethods.ToJson(ds))

Class file:

Imports System.Data
Imports System.Collections.Generic
Imports System.Runtime.Serialization.Json
Imports System.IO
Imports System.Text
Imports System.Web.Script.Serialization

Public Class JsonMethods
    Private Shared Function RowsToDictionary(ByVal table As DataTable) As List(Of Dictionary(Of String, Object))
        Dim objs As New List(Of Dictionary(Of String, Object))()
        For Each dr As DataRow In table.Rows
            Dim drow As New Dictionary(Of String, Object)()
            For i As Integer = 0 To table.Columns.Count - 1
                drow.Add(table.Columns(i).ColumnName, dr(i))
            Next
            objs.Add(drow)
        Next
        Return objs
    End Function

    Public Shared Function ToJson(ByVal table As DataTable) As Dictionary(Of String, Object)
        Dim d As New Dictionary(Of String, Object)()
        d.Add(table.TableName, RowsToDictionary(table))
        Return d
    End Function

    Public Shared Function ToJson(ByVal data As DataSet) As String  
        Dim d As New Dictionary(Of String, Object)()
        For Each table As DataTable In data.Tables
            d.Add(table.TableName, RowsToDictionary(table))
        Next
        Dim json As New JavaScriptSerializer
        json.MaxJsonLength = Int32.MaxValue
        Return json.Serialize(d)
    End Function

End Class

Temp Tables in Sql Server

2011-05-16T11:43:00.002+05:30

Four kinds of temp tables

1. Local Temp Table:

Local temp tables are only available to the current connection for the user; and they are automatically deleted when the user disconnects from instances

CREATE TABLE #CRSTYPES(COURSETYPEID TINYINT,COURSETYPENAME VARCHAR(32))

2. Table Variables:

A table variable is created in memory, and so performs slightly better than #temp tables. Table variables are automatically cleared when the procedure or function goes out of scope.

DECLARE @MYSCHEDULE TABLE(SCHEDULEID INT PRIMARY KEY)

3. Global Temp Table:

Global Temporary tables name starts with a double hash ("##").
Once this table has been created by a connection, like a permanent table it is then available to any user
by any connection. It can only be deleted once all connections have been closed.

CREATE TABLE ##CRSTYPES(COURSETYPEID TINYINT,COURSETYPENAME VARCHAR(32))

4. Common Table Expression (CTE) Varaible:

with exmp (COURSETYPEID, COURSETYPENAME) as
(
SELECT COURSETYPEID,COURSETYPENAME FROM COURSETYPES WHERE COURSETYPEID IN (17,18)
)
select * from exmp
select * from exmp WHERE COURSETYPEID IN (17)

Storage Location of Temporary Table

Temporary tables are stored inside the Temporary Folder of tempdb.
Whenever we create a temporary table, it goes to Temporary folder of tempdb database.

Using Temporary Tables Effectively

If you do not have any option other than to use temporary tables, use them effectively. There are few steps to be taken.

Only include the necessary columns and rows rather than using all the columns and all the data which will not make sense of using temporary tables. Always filter your data into the temporary tables.
When creating temporary tables, do not use SELECT INTO statements, Instead of SELECT INTO statements,create the table using DDL statement and use INSERT INTO to populate the temporary table.
Use indexes on temporary tables. Earlier days, I always forget to use a index on temporary. Specially, for large temporary tables consider using clustered and non-clustered indexes on temporary tables.
After you finish the using your temporary table, delete them. This will free the tempdb resources. Yes, I agree that temporary tables are deleted when connection is ended. but do not wait until such time.
When creating a temporary table do not create them with a transaction. If you create it with a transaction, it will lock some system tables (syscolumns, sysindexes, syscomments). This will prevent others from executing the same query.
Use the table variables instead of the temporary tables whenever possible.
Try to avoid using temporary tables inside your stored procedure.
Try avoiding using insensitive, static and keyset cursors whenever possible.
Use multi-statement table-valued functions to eliminate temporary table usage for intermediate result processing.
Try to avoid using temporary tables by rewriting your Transact-SQL statements to use only standard queries or stored procedures.
Use the derived tables or correlated sub-queries instead of the temporary tables whenever possible.
Use local temporary tables instead of SQL Server cursors.
Avoid creation temporary tables from within a transaction.
Avoid using global temporary tables.
Consider creation a permanent table instead of using temporary tables.
Because all temporary tables are stored in the tempdb database, consider spending some time on the tempdb database optimization.
Set a reasonable size for the tempdb database and a reasonable autogrow increment.

The 10 best IT certifications

2008-12-13T17:15:00.001+05:30

MCITP Microsoft Certified IT Professional credential
Track:

Database developer,
Database administrator,
Enterprise messaging administrator, and
Server administrator

MCTS - Microsoft Certified Technology Specialist
Track:

SQL Server 2008 Business Intelligence
SQL Server 2008 Database Development
SQL Server 2008 Implementation and Maintenance

Security+ - CompTIA’s Security+
MCPD - Microsoft Certified Professional Developer
Track:

Windows Developer 3.5
ASP.NET Developer 3.5 and
Enterprise Applications Developer 3.5

CCNA - Cisco Certified Network Associate
A+ - CompTIA’s A+
PMP - Project Management Professional
MCSE/MCSA - Microsoft Certified Systems Engineer/Microsoft Certified Systems Administrator
CISSP - Certified Information Systems Security Professional
LINUX+

Integrate Google Task into Gmail

2008-12-13T17:00:00.001+05:30

Google just rolled out functionality that can able to add task gadgets into your Gmail.
Settings --> Labs --> Enable (Select Google task) Option

The New OS from Microsoft - Windows Vienna

2008-12-12T15:11:00.002+05:30

Run Query on Two Different Database on Two Different Servers

2008-12-12T13:49:00.003+05:30

A linked server configuration allows Microsoft SQL Server to execute commands against OLE DB data sources on different servers. Linked servers offer these advantages:

Remote server access.
The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise.
The ability to address diverse data sources similarly.

Managing a Linked Server Definition

Register the connection information and data source information with SQL Server.

You can create or delete a linked server definition with stored procedures or through SQL Server Enterprise Manager.

With Stored Procedure:

Create a linked server definition using sp_addlinkedserver.
Syntax
sp_addlinkedserver [ @server = ] 'server'
[ , [ @srvproduct = ] 'product_name' ]
[ , [ @provider = ] 'provider_name' ]
[ , [ @datasrc = ] 'data_source' ]
[ , [ @location = ] 'location' ]
[ , [ @provstr = ] 'provider_string' ]
[ , [ @catalog = ] 'catalog' ]
Example
EXEC sp_addlinkedserver
@server = 'SEATTLE Mktg',
@srvproduct = 'OLE DB Provider for Jet',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@datasrc = 'C:\MSOffice\Access\Samples\Northwind.mdb'

Delete a linked server definition using sp_dropserver.
Syntax
sp_dropserver [ @server = ] 'server'
[ , [ @droplogins = ] { 'droplogins' | NULL} ]
Examples
sp_dropserver ‘SEATTLE Mktg', 'droplogins'

With SQL Server Enterprise Manager:

SQL Server Enterprise Manager Console -- Server objects -- Linked Servers
Right Click -- New Linked Server
Define the name, provider properties, server options, and security options for the linked server.
Edit a linked server definition by right-clicking the linked server and clicking Properties.
Delete a linked server definition by right-clicking the linked server and clicking Delete.

When executing a distributed query against a linked server, include a fully qualified, four-part table name for each data source to query.

This four-part name should be in the form linked_server_name.catalog.schema.object_name.

Select * From [linkedservername or IP].DatabaseName.sys.Columns

Pseudo Validator for a Pseudo Standard

2008-12-12T13:42:00.000+05:30

Web 2.0 validator tool:
http://web2.0validator.com/

Web 2.0 Technology

2008-12-12T13:30:00.005+05:30

Semantic web is an evolving extension of World Wide Web Consortium and It’s Director Tim Berner’s Lee founded in the year 1989.

Web 2.0 concepts have led to the development and evolution of web culture communities and hosted services, such as social-networking sites, video sharing sites, wikis, blogs, and folksonomies.

O'Reilly and John Battelle they frame the themes of Web 2.0.

Four levels in the hierarchy of Web 2.0 sites:

Level-3 applications, the most "Web 2.0"-oriented, exist only on the Internet. Examples: eBay, Craigslist, Wikipedia, del.icio.us, Skype, dodgeball, and AdSense.
Level-2 applications can operate offline but gain advantages from going online. Examples: Flickr.
Level-1 applications operate offline but gain features online. Examples: Google Docs & Spreadsheets and iTunes.
Level-0 applications work as well offline as online. Examples: MapQuest, Yahoo! Local, and Google Maps.

Web 2.0 websites typically include some of the following features/techniques

Rich-Internet application: Techniques to improve the user-experience in browser-based application such as AJAX, Adobe Flash, Flex, Java, Silverlight, Curl etc.
Server-Side software: Dynamic content management system by using much more robust database and workflow support.
Client-side software: Reduce server workloads and to increase responsiveness of the application by using scripting language such as JavaScript/AJAX, Flash, Curl Applets or Java Applets.
XML and RSS
Specialized protocols such as FOAF and XFN (both for social networking)
Web APIs which allow web-based access to data and functions: REST and SOAP
Search: Easily find the information in the site by specifying the keyword which makes the platform valuable.
Links: guides to important pieces of information. The best pages are the most frequently linked to.
Authoring: Able to post content by different users. While in blogs is increasing that posts and comments of individuals are accumulated over time.
Tags: categorize content by creating tags (one-word description) increase facilitate of searching.
Extensions: Automation some of the work and pattern matching by using algorithms e.g. amazon.com recommendations.
Signals: Notify users frequently about the changes that are made to the site by sending mails to them in the format of RSS (Really Simple Syndication) technology.

Current World Internet Usage and Population Statistics

Encoded file filename.php expired or corrupt error.

2008-12-12T13:02:00.001+05:30

SYMPTOMS
The encoded file filename.php has expired or is corrupt.

SOLUTION
This happens when one of the ionCube encoded files have not been uploaded in binary mode or have been tampered with.

The files are encoded on the fly when you click on the download button and your user information is written to the comments of the php file so is a file checksum, if the file is edited or tampered with in any way it becomes corrupt, same with uploading it in ASCII mode, it changes checksums because of the difference in uploading.

The resolution would be to try uploading the file again in binary mode, if that does not work I would suggest re-downloading the entire system from our members area and re-uploading it in binary mode.

Types of Encode/Decode in PHP

2008-12-12T12:54:00.001+05:30

You can encode or decode PHP file by using

Zend Encoder,
Zend SafeGuard,
IonCube,
PhpCipher,
Codelock,
Truebug,
Sourcecop,
Byterun,
ElearningForce,
PHPLockit,
Zorex Cryptz,
PHPion.

XAMPP Apache port change

2008-12-12T12:26:00.001+05:30

Find httpd.conf file in the folder path
apache --> conf --> httpd.conf

Open httpd.conf file in your text editor.

Find this line:
Listen 80

change it to:
Listen 8080

Save and restart Apache.

http://locahost:8080 would now be your XAMPP default pages.

Bounce Rate

2008-11-14T19:01:00.003+05:30

Bounce rate is the percentage of single page visits. If a visitor arrive at any page of a site and exits (either closes the browser or visits another website) without visiting any other page of the same site.

For example
64 pages were viewed a total of 477 visitors (i.e. Visit only a single page of a site).
(Single page visit / total page visits) * 100 = Bounce Rate
(64 / 477) * 100 = 67.73%

Importance of reducing bounce rate:

Visitors Time on the Page to be increased (i.e. visitors will stay longer in the site) and
Conversion rates will improve.

Determine Bounce Rate:

You can determine it by using Google Analytics tool

Go to Content -> Top Content.
Now you can view the Bounce Rate column (it shows bounce rate for particular page).

To reduce bounce rate:

No hard and fast rule to reduce bounce rate.

Increase the overall feel of that particular page.
Look at the navigational structure.
Take care when you assign a heading to the page or article and it should be more appropriate to the content because visitors are reading your headline and calling it off.
Show the high bounce pages to your friends/colleagues. Ask them what they find annoying. Listen to them carefully - implement it and see if there is a change in bounce rate.

Approving Certificate Requests to a Standalone Certificate Authority

2008-11-13T16:38:00.003+05:30

The stand-alone CA does not automatically issue a certificate when a certificate request is made. The reason is the standalone CA is not able to confirm the validity of the request. It does not check the information provided by the requestor against a directory, such as the enterprise CA does when validating credentials against the Active Directory.

You should keep this default behavior for your published standalone CA in order to prevent users on the Internet from obtaining certificates without your review. Perform the following steps to approve a certificate request:

1. Click Start and point to Administrative Tools. Click on the Certification Authority link.

2. In the Certification Authority console, expand the server name and then click on the Pending Certificates node. You see a list of pending certificate requests in the right pane of the console. You can see who requested the certificate by scrolling to the right and looking under the Requester Name column (not shown). Right click on the certificate request in the right pane of the console, point to All Tasks and click Issue. The certificate request is removed from the Pending Requests node.

3. Click on the Issued Certificates node in the left pane of the Certification Authority console. The certificate request you approved appears in the right pane of the console. This indicates the certificate request was approved. It does not indicate the machine issuing the request has returned to the Web enrollment site to retrieve the certificate.

Installing Microsoft Certificate Services

2008-11-13T15:54:00.003+05:30

We recommend that you install the stand-alone CA on a member server or domain controller on your internal network. This will allow the stand-alone CA’s certificate to be placed automatically into the Trusted Root Certification Authorities certificate store for all users and computers.

1. At a member server or domain controller in your internal network, log on as a domain administrator. Click Start, point to Control Panel and click Add/Remove Programs.

2. In the Add or Remove Programs window, click the Add/Remove Windows Components button.

3. In the Windows Components dialog box, click on the Certificate Services entry and click the Details button.

4. In the Certificate Services dialog box, put a checkmark in the Certificate Services CA checkbox. A Microsoft Certificate Services dialog box appears and informs you that you can not change the machine name or the domain membership of the machine while it acts as a certificate server. Read the information in the dialog box and click Yes.

5. Both the Certificate Services CA and Certificate Services Web Enrollment Support checkboxes are checked. Click OK in the Certificate Services dialog box.

6. Click Next in the Windows Components dialog box

7. Select the Stand-alone root CA option on the CA Type page. Click Next.

8. On the CA Identifying Information page, type in a Common name for this CA. The common name of the CA is typically the DNS host name or NetBIOS name (computer name) of the machine running Certificate Services. In this example, the name of the machine is WIN2003DC, so we will enter WIN2003DC in the Common name for this CA text box. The default Validity Period of the CA’s self-signed certificate is 5 years. Accept this default value unless you have a reason to change it. Click Next.

9. On the Certificate Database Settings page, use the default locations for the Certificate Database and Certificate Database Log. You do not need to specify a shared folder to store configuration information because this information will be stored in the Active Directory. Click Next.

10. Click Yes on the Microsoft Certificate Services dialog box informing you that Internet Information Services must be stopped temporarily.

11. Click Yes on the Microsoft Certificate Services dialog box informing you that Active Server Pages must be enabled on IIS if you wish to use the Certificate Services Web enrollment site.

12. Click Finish on the Completing the Windows Components Wizard page.

13. Close the Add or Remove Programs window.

The standalone Certificate Server is now ready to accept certificate requests.

Installing Microsoft Internet Information Services World Wide Web Service

2008-11-13T15:16:00.002+05:30

Perform the following steps to install IIS 6.0 on the Windows Server 2003 computer. The machine can be a standalone server, a member server in an Active Directory domain, or even a domain controller:

1. Click Start, point to Control Panel and click Add or Remove Programs.

2. Click the Add/Remove Windows Components button in the Add or Remove Programs.

3. On the Windows Components window, click on the Application Server entry and click the Details button.

4. On the Application Server page, click on the Internet Information Services (IIS) entry and click the Details button.

5. In the Internet Information Service (IIS) dialog box, put a checkmark in the World Wide Web Service checkbox and click OK.

6. Click OK on the Application Server dialog box.

7. Click Next on the Windows Components dialog box.

8. Click Finish on the Completing the Windows Components Wizard page.

Port Forwarding

2008-11-13T14:53:00.000+05:30

Port forwarding allows remote computers (e.g. public machines on the Internet) to connect to a particular computer within a private LAN.

Some examples can be when u setup an ftp server on my machine for other people to access, or you are running a bittorrent client such as utorrent, or when you want to play Age of Empires on the network.