shashank mishra

Merge Statement SQL Server 2008

2009-09-17T11:44:00.003+05:30

MERGE statement is introduced in SQL Server 2008 that can greatly enhance the functionality for Data Warehouse and the staging servers.

The Merge statement allows you to perform DML actions on target table based on whether
or not a row matches information found in source table.

A common Merge scenario is moving data from one table to another.

Like User and UserHistory

User Table :

CREATE TABLE [dbo].[User]
(
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NOT NULL,
[Age] [int] NOT NULL,
[Is_Active] [bit] NULL,
[CREATE_DATE] [date] NOT NULL
)

GO

ALTER TABLE [dbo].[User] ADD CONSTRAINT [DF_User_CREATE_DATE] DEFAULT (getdate()) FOR [CREATE_DATE]

GO

AND
UserHistory Table is like:

CREATE TABLE UserHistory
(
HistoryId INT IDENTITY(1, 1),
Id INT NOT NULL,
Name VARCHAR(50) NOT NULL,
Age INT NOT NULL,
Is_Active BIT NULL,
Create_Date DATE NOT NULL
)

------------------------------------------------------------------------------------

Now insert some data in user table and try running this query more than once and look
on the results that are produced by OUTPUT and $action clauses:

MERGE INTO UserHistory AS UH
USING [User] as U
ON U.Id = UH.Id
WHEN MATCHED THEN
UPDATE SET UH.Id = U.Id, UH.Name = U.Name
,UH.Is_Active = U.Is_Active, UH.Create_date = U.Create_date
WHEN NOT MATCHED BY TARGET THEN
INSERT (Id, Name, Age, Is_Active, Create_Date)
VALUES (Id, Name, Age, Is_Active, Create_Date)
WHEN NOT MATCHED BY SOURCE THEN
Update SET IS_ACTIVE = 0
Output $action, inserted.*;

-------------------------------------------------------------------------------------
You can perform insert, update and delete operation by matching the Source Table (User)
and the Target Table (UserHistory) in a single operation and can have the details about the
action from OUTPUT clause and using $action you can know the operation performed

SQL Server 2008:Output Clause Sample

2009-09-16T17:41:00.002+05:30

So with SQL Server 2008 we have output clause available inside the query that means we can access the inserted, deleted or updated value form the output clause inside a Stored Procedure and we need not to write a trigger

Ex.
Suppose we have a user table on inserting the data we need to insert the same value to a table type variable, we can accomplish this task as given below:

DECLARE @User TABLE (ID INT, Name VARCHAR(50), Age INT, Is_Active BIT, CREATE_DATE DATETIME)
INSERT INTO [User] (Name, Age, Is_Active, CREATE_DATE)
OUTPUT inserted.* INTO @User VALUES ('TESTING', '26', 1, GETDATE())

SELECT * FROM @User

Create class variables and properties from database table

2009-06-30T14:59:00.002+05:30

Use the below given query to create variables and properties from your schema.

Just replace the @tableName variable with the table name for which you want to generate the variables and properties.

This makes use of systypes and syscolumns system defined views to get the name of columns from the table and their type. Also add more types as per your requirement.

-----------------------------------------------------------------------------

declare @tableName varchar(50)

set @tableName = 'tbTest'

SELECT 'private ' + (

case systypes.name

when 'varchar' then 'string'

when 'decimal' then 'decimal'

when 'datetime' then 'DateTime'

when 'int' then 'int'

else systypes.name end) + ' _' + lower(substring(syscolumns.name, 1, 1)) + right(syscolumns.name, len(syscolumns.name) -1) + ';'

FROM syscolumns inner join systypes on

syscolumns.xtype = systypes.xtype

where id = Object_ID(@tableName)

order by colorder

SELECT 'public ' + (

case systypes.name

when 'varchar' then 'string'

when 'decimal' then 'decimal'

when 'datetime' then 'DateTime'

when 'int' then 'int'

else systypes.name end)+ ' ' + syscolumns.name + char(10) +

'{' + char(10) + 'get { return' +

' _' + lower(substring(syscolumns.name, 1, 1)) + right(syscolumns.name, len(syscolumns.name) -1) + '; }'

+ char(10) + 'set { _' + lower(substring(syscolumns.name, 1, 1)) + right(syscolumns.name, len(syscolumns.name) -1) + ' = value; }' + char(10) + '}'

FROM syscolumns inner join systypes on

syscolumns.xtype = systypes.xtype

where id = Object_ID(@tableName)

order by colorder

-----------------------------------------------------------------------------

SQL Server 2008 Features

2009-06-18T14:12:00.003+05:30

What's New in Sql Server 2008

Power of Reflection Emit

2009-03-14T15:21:00.003+05:30

Some time ago I came across a situation where the end user of my application was willing to add new types at his own. Obviously I was not having any other solution rather using Reflection Emit.

It was great creating new types, dynamic methods at run time.

So as I did earlier similarly I will produce some code (to create new type (compiled class) with some properties and methods) out here with a little description.

But before working with Emit you should look on the MSIL Disassembler to know how the things looks alike after compilation and before JIT compiler processing.

------------------------------ Creating A Whole New Type ------------------------------------

using System;
using System.Collections.Generic;
using System.Text;
using System.Reflection;
using System.Reflection.Emit;
using DataFramework;
using System.Data;

namespace Generator
{
public class ClassGenerator
{
public ClassGenerator()
{

}

public void GenerateClass(string assemblyName, string className, List fieldWithType)
{
AssemblyName an = new AssemblyName(assemblyName);
AppDomain ad = AppDomain.CurrentDomain; // Use same app domain otherwise to use
// the generated classes you need to use
// remoting like - object handle unwrap
AssemblyBuilder ab = ad.DefineDynamicAssembly(an, AssemblyBuilderAccess.RunAndSave, AppDomain.CurrentDomain.BaseDirectory);

ModuleBuilder mb = ab.DefineDynamicModule(an.Name, "CustomClasses.dll");

TypeBuilder tb = mb.DefineType(className, TypeAttributes.Class | TypeAttributes.Public);

ConstructorInfo ci = tb.DefineDefaultConstructor(MethodAttributes.Public);

foreach (FieldStructure fieldName in fieldWithType)
{
Type type = GetType(fieldName.type);// Type.GetType(fieldWithType[fieldName], false, true);

FieldBuilder fb = tb.DefineField(fieldName.name, type, FieldAttributes.Private);

CreateProperty(tb, type, fb, fieldName.name);
}

Type generatedType = tb.CreateType();
ab.Save("CustomClasses." + className + ".dll");
}

#region Create Property for field
private void CreateProperty(TypeBuilder tb, Type fieldType, FieldBuilder fb, string key)
{
PropertyBuilder pb = tb.DefineProperty(SystemConstants.GetPropertyName(key), System.Reflection.PropertyAttributes.HasDefault, fieldType, Type.EmptyTypes);

MethodAttributes getSetAttr = MethodAttributes.Public | MethodAttributes.SpecialName | MethodAttributes.HideBySig;

MethodBuilder mbGet = tb.DefineMethod(SystemConstants.getPrefix + key, getSetAttr, fieldType, Type.EmptyTypes);

ILGenerator getIL = mbGet.GetILGenerator();
// For an instance property, argument zero is the instance. Load the
// instance, then load the private field and return, leaving the
// field value on the stack.
getIL.Emit(OpCodes.Ldarg_0);
getIL.Emit(OpCodes.Ldfld, fb);
getIL.Emit(OpCodes.Ret);

MethodBuilder mbSet = tb.DefineMethod(SystemConstants.setPrefix + key, getSetAttr, null, new Type[] { fieldType });

ILGenerator setIL = mbSet.GetILGenerator();
// Load the instance and then the numeric argument, then store the
// argument in the field.
setIL.Emit(OpCodes.Ldarg_0);
setIL.Emit(OpCodes.Ldarg_1);
setIL.Emit(OpCodes.Stfld, fb);
setIL.Emit(OpCodes.Ret);

// Last, map the "get" and "set" accessor methods to the
// PropertyBuilder. The property is now complete.
pb.SetGetMethod(mbGet);
pb.SetSetMethod(mbSet);
}
#endregion

#region Get type based on string representation
private Type GetType(string typeName)
{
switch (typeName.ToLower())
{
case "string":
return typeof(String);
case "int32":
return typeof(Int32);
case "long":
return typeof(long);
case "float":
return typeof(float);
case "decimal":
return typeof(decimal);
default:
return typeof(object);
}
}
#endregion
}
}

----------------------- Helper Classes (SystemConstants)-----------------------------------
using System;
using System.Collections.Generic;
using System.Text;

namespace Generator
{
public class SystemConstants
{
public const string getPrefix = "get_";
public const string setPrefix = "set_";
public const string variablePrefix = "m_";
public const string idVariableForClasses = "ID";
public const string idVariableType = "int32";

private static bool IsFieldDicContainsId(Dictionary fieldWithType)
{
foreach (string fieldName in fieldWithType.Keys)
{
if (fieldName.ToUpper() == idVariableForClasses)
{
return true;
}
}
return false;
}

public static Dictionary GetFinalDictionary(Dictionary fieldWithType)
{
if (IsFieldDicContainsId(fieldWithType))
{
if (fieldWithType.ContainsKey(idVariableForClasses))
{
fieldWithType.Remove(idVariableForClasses);
}
}

return fieldWithType;
}

internal static string GetPropertyName(string key)
{
// Implement Logic to create property like m_name ==> Name right now its NAME
return key.ToUpper();
}
}
}

----------------------- Helper Structure (FieldStructure)-----------------------------------

using System;
using System.Collections.Generic;
using System.Text;

namespace Generator
{
public struct FieldStructure
{
public string name;
public string type;
public bool isIdentity;
public bool isReference;
public string referenceClassName;
public string referenceColumnName;

}
}

--------------------------------- Code to be called from UI ------------------------------------

ClassGenerator cg = new ClassGenerator();

FieldStructure fStructA = new FieldStructure();
fStructA.name = "name";
fStructA.type = "string";
fStructA.isIdentity = false;

FieldStructure fStructB = new FieldStructure();
fStructB.name = "id";
fStructB.type = "int32";
fStructB.isIdentity = true;

List allFields = new List();
allFields.Add(fStructA);
allFields.Add(fStructB);

cg.GenerateClass("test", "Test", allFields);
}

Thats it. Try to use it, a .dll file will be saved in your application root directory, but beware if you are using web application and you intended to save any .dll file in the bin folder the application domain will reload and all your sessions will be lost as one of the application domain reloading is any change in the bin directory is.

For more reading you can look at this msdn link.

Let me know for your queries.
Shashank.... enjoy coding ....

Microsoft Product Code Names

2008-05-06T13:05:00.000+05:30

Know Microsoft Product Code Names:

Current

11/12/2007 4:33:10 AM - Zeus

CodeNames

Avalon	Windows Presentation Foundation, WPF is the presentation subsystem class libraries in Click to read this topic 5/8/2005 7:52:01 PM - WinFX.
Aero	UI in Windows Vista
Aruba	Windows Media Platform for Blackcomb
Ajax	New Set of asynchonous technologies for web applications enabling richer user experiences
Blackcomb	Successor to Vista
Cairo	Base collection of technologies which largely evolved into the core technologies in 1.Vista.
Cider	VS Designer for Windows Presentation Foundation
Longhorn	Windows Vista
Monad	Longorn Command Shell. Msh is the new
Vienna	Office Live Communication Server 2005
Whidbey	Visual Studio .NET 2005
Orcas	Visual Studio 2008
Hawaii	Future version of Visual Studio (after the Orcas release).
Whitehorse	VS.NET 2005 Design Tool Suite
Click to read this topic 5/8/2005 7:52:01 PM - WinFx	The set of next-generation managed APIs provided by Microsoft
Yukon	SQL Server 2005 scripting and automation environment for Windows
Acrylic	Microsoft Expression Graphic Designer. A new professional graphics software.
Sparkle	Microsoft Expression Interactive Designer.
Quartz	Microsoft Expression Web Designer.
Click to read this topic 12/19/2006 5:17:49 AM - WinFS	Next-generation Unified Storage Sub-system for Windows.

Operating System Components / Versions

Avalon	Windows Presentation Foundation, WPF is the presentation subsystem class libraries in Click to read this topic 5/8/2005 7:52:01 PM - WinFX.
Asteroid	Windows 2000 SP1
Aero	UI in Windows Vista
Bearpaw	Windows Terminal Services for Windows Server 2003
Blackcomb	Is the server version of Vista
Bobcat	Windows Server 2003 Small Business Edition
Cairo	Base collection of technologies which largely evolved into the core technologies in Vista.
Chicago	Windows 95
Daytona	Windows NT 3.5
Detroit	Windows 95 OSR 2
Freestyle	Windows XP Media Center Edition
Frosting	Windows 95 Plus!
Harmony	Windows XP Media Center Edition 2004
Impala	Windows NT4 Embedded
Indigo	Communications services used in Vista, also called WCF(Windows Communication Foundation)
Janus	Windows 3.1
Lonestar	Windows XP Tablet PC Edition 2005
Longhorn	Windows Vista
Mantis	Windows XP Embedded 5.1
Memphis	Windows 98
Mesquite	Batch Management tools for Windows NT/Windows 2000 Server
Millenium/Georgia	Windows ME
Mir	Internal Mercury release
NAS 3.0	Windows Storage Server 2003
Nashville	Internet Explorer 4, for Windows 95
Neptune	Cancelled successor to Windows 98
Newshell	Alpha shell update for Windows NT 3.x
Panther	Abandoned port of Windows NT, replaced by Chicago
Slalom	Windows Media Center for Vista
Sparta	Windows for Workgroups 3.1
Springboard	Backporting of Vista technologies to Windows XP Service Pack 2 6/29/2005 6:01:27 PM - RaiN SP2
Snowball	Windows for Workgroups 3.11
Sundown	Windows XP 64-bit
SUR	Patch to Windows 3.51
Symphony	Windows XP Media Center Edition 2005
Whistler	Windows XP
Windows	Windows 1.0
Windows 286	Windows 2.0
Click to read this topic 5/8/2005 7:52:01 PM - WinFx	The set of next-generation managed APIs provided by Microsoft

Server Products

SQL

Starfighter	SQL Server 6.0
Hydra	SQL Server 6.5
Sphinx	SQL Server 7.0
Plato	SQL Server 7.0 OLAP Services
Shiloh	SQL Server 2000
Liberty	SQL Server 2000 64-bit Edition
Rosetta	SQL Server 2000 Reporting Services
Aurum	SQL Server 2000, data mining toolkit
Yukon	SQL Server 2005
Katmai/Acadia	SQL Server 2008

Exchange

Osmium	Exchange Server 5.5
Platinum	Exchange Server 2002
Titanium	Exchange Server 2003
Kodiak	Abandoned successor to Exchange 2003.
Magma	Embedded Exchange

SharePoint Portal Server 2003 links

9/14/2004 12:10:55 AM - roberdan

SharePoint

Tahoe	Sharepoint Server 2001
Matrix	Sharepoint Portal Server v2

9/2/2004 3:33:27 PM - kevinh

BizTalk

Latinum	9/2/2004 3:33:27 PM - kevinh BizTalk 2000
Bizet	9/2/2004 3:33:27 PM - kevinh BizTalk 2002

Misc

Falcon	Message Queue Server (MSMQ)
Viper	Transaction Server 2.0
Hydra	Windows NT Terminal Services
Babylon	Host Integration Server
Cedar	COM Transaction Integrator for CICS and IMS (COMTI)
Wolfpack	Cluster Server
Vienna	Office Live Communication Server 2005
Hermes	System Management Server
Kahiltna	Commerce Server 2.0
Comet	ISA 2000

Mobile PC

Lonestar	Windows XP Tablet PC Edition 2005
Haiku	Post-2007 mobile PC hardware design

Mobile Platforms

Alder	Windows CE 2.1
Apolllo	Windows CE for Auto PC
Axe	Embedded Toolkit for Windows CE 2.0 and 2.1
Brich	Windows CE 2.11 and 2.12
Cedar	Windows CE 3.0
Chainsaw	Windows CE Platform Builder 3.0
Galileo	Windows CE for Handheld PC 2000
Goldeneye	Windows CE for AutoPC
Gryphon	Windows CE 2.0 for palm-sized PCs
Hai Ku	Multimedia Extension for Windows
Hermes	Windows CE for webphones
Jameson	Windows CE.NET Update
Jupiter	Windows CE for Handheld PC Pro 3.0 (or Macallan Windows CE.NET Corporate Edition??)
Laguna	Upcoming version of SQL Server, for Windows CE
McKendrick	Windows CE for Media2G0
Mercury	Windows CE for Hanheld PC
Merlin	Pocket PC 2002 (or Windows CE 2002??)
Mira	Windows CE for Smart Display Devices
Orion	Windows CE for Chinese Handheld PC
Ozone	Pocket PC 2003
Pegasus	Windows CE 1.0
Rapier	Windows CE for 2/11/2007 4:22:22 AM - abhishek85gupta PocketPC 2000
Stinger	Smartphone 2002 (or Windows CE for Smartphones 1.0??)
Starlite	.NET Compact Framework 1.0
Talisker	Windows CE .NET
Tazz	Microsoft Phone
Visine	Novell Netware Migration Tool
Venus	Windows CE for webTV
Wyvern	Windows CE for Color Palm PC

Miscellaneous

Trident	Dynamic HTML
Springboard	Microsoft's security excellence and review project, who's fruits were deployed via Office 2003 SP1, Windows XP SP1 and Windows Server 2003 SP1
Palladium	An on-again off-again secure runtime environment called Next Generation Secure Computing Base (NGSCB
AirStream	Services for wireless connections to Exchange
Avalanche	Internet-Information-Services 5.0
Argo	Query-Services for SQL-Server 2000
Aruba	Windows Media Platform for Blackcomb
Athena	Outlook Express
Athens	New prototype PC design (with HP)
Blackbird	MSN SDK
Blizzard	Business oriented Set of Services in .NET My Services
Basecamp	VPN dial-up networking update (PPTP) for win95
Calais	Smart-Card Technologies
Cascade	Windows Active-Directory
Cayman	NetMeeting 3.0 Version 3.01 4.4.3400
Chrome	ChromeEffects (GUI-Feature)
Cirrus	Access 1.0
Comet	Network-Tools for Windows 2000
Corona	Windows Media-Technologies 9.0
Coyote	Distributed Views for SQL-Server 2000
Darwin	Windows Installer 1.1 Version 1.1
Dart	Setup for Oracle, SQL-Server ODBC-driver
DaVinci	Database-Design & Query-Tools
Denali	Active Server Pages
Europa	New GUI for the MSN-Community
Fahrenheit	A defunct collaboration between Microsoft & SGI Graphics to combine Direct3D and OpenGL by creating a unified 3D API.
Falcon	Windows Messaging Queuing Server
Fusion	Technologies for DLL improvements
Gemini	Succesor GUI "Europa" for MSN-Community
Gibraltar	Internet-Information-Server 1.0 Version 3.0
Grizzly	Workflow-Designer for SQL-Server 2000
Hailstorm	XML Message Interface
Hailstorm	.NET My Services
HardeningPack	Internet Explorer Enhanced Security (Windows Server 2003)
Hydra	Windows NT Terminal Services
Idaho	Preliminary/alpha version of the next Windows-Longhorn
Jakarta	JAVA-Engine for Internet Explorer 3.0
Kagera (Kajera??)	OLE-DB Provider for ODBC-Data
Kahuna	Windows Live Mail
K2	Internet-Information-Server 4.0
Lightning	.NET Common Language Runtime (CLR)
Luna	Theme technology for Windows XP
Luxor	OLE-Provider-Services for Yukon
Magic Carpet	Passport-Technologien
Marvel	Microsoft Network (MSN)
Merlin	Microsoft® Internet Explorer for Dreamcast (cancelled circa 1999).
Mercury	DUN 1.2 update for Win95
Monad	Longorn Command Shell. Msh is the new scripting and automation environment for Windows
NGWS	(Next Generation Windows/Web Services) .Net
Normandy	Microsoft Commercial Internet System (MCIS)
Oprah	Netmeeting
Nile	OLE-DB
O'hare	Internet Explorer 1.00.
Plato	OLAP-Server
Project 42	(from Lightning) .NET Common Language Runtime (CLR)
Ren	Outlook
Quartz	Direct Show
Sideshow	Task Shelf of Longhorn (MS research)
Slate	Microsoft Management-Console (MMC)
Spark	Integration of Windows SharePoint Portal Server 2003 links 9/14/2004 12:10:55 AM - roberdan SharePoint Services and CMS
Steelhead	Windows NT Routing & Remote-Access Services (RAS)
Tahiti	SharedView Beta2
Talisman	3D Graphic- und Multimedia Architecture
Tensor	OLE-DB Extensions for OLAP
Touchdown	Outlook 97 (Also mentioned:Public folders for MS Exchange)
Trident	Dynamic HTML (DHTML)
Tungsten	Microsoft Rights Management Services (RMS)
Whisper	Speech Recognition (speech-to-text)
Xenon	Xbox 360

Read Write and Search XML Document in ASP.NET

2008-05-06T12:34:00.001+05:30

You often need to read, write or search some phrase in an XML document and you can use XmlDocument or any class among a lot present in .NET framework but what
if you wish to bind your business objects the list of business objects to the XmlDocument.

You can use the code below to do this.

What you need to do for this is to keep the name of properties of your business objects same as the name of attributes are present in the XML file you wanna load.

This class make use of XmlReader and XmlWriter base classes provided by .NET framework.

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Xml;
using System.Reflection;
using System.IO;

///

/// XMLDataHelper provides way to access nodes and bind them directly to custom objects.
/// Also Save XMLFragment at the end of the Xml File
///

public class XMLDataHelper : IDisposable
{
#region Variables

private static string _baseDirectory = AppDomain.CurrentDomain.BaseDirectory;
private static string _documentDirectory = _baseDirectory + "App_Data/";

protected string _query;
protected XmlReader xmlReader;
protected XmlWriter xmlWriter;
#endregion

#region constructors
public XMLDataHelper()
{
string xmlFile = ConfigurationManager.AppSettings["XmlFileName"].ToString();
xmlReader = XmlReader.Create(xmlFile);
}

public XMLDataHelper(string xmlFile)
{
xmlReader = XmlReader.Create(xmlFile);
}
public XMLDataHelper(string xmlFile, string xmlFileForWriter)
{
xmlReader = XmlReader.Create(xmlFile);
xmlWriter = XmlWriter.Create(xmlFileForWriter);

}
#endregion

#region Load Object
public T LoadObject(string nodeName, Dictionary attrFieldsLookUp) where T : new()
{
T obj = new T();
if (string.IsNullOrEmpty(nodeName))
{
throw new Exception("Node not specified.");
}
bool IsRequestedItem = true;
PropertyInfo[] objPropInfo = obj.GetType().GetProperties();
while (xmlReader.ReadToFollowing(nodeName))
{
if (xmlReader.NodeType == XmlNodeType.Element && xmlReader.NodeType != XmlNodeType.Document)
{
XmlReader nodeXmlReader = xmlReader.ReadSubtree();
while (nodeXmlReader.Read())
{
IsRequestedItem = false;
foreach (string key in attrFieldsLookUp.Keys)
{
if (attrFieldsLookUp[key.ToUpper()] == nodeXmlReader.GetAttribute(key))
{
IsRequestedItem = true;
}
else
{
IsRequestedItem = false;
break;
}
}
if (IsRequestedItem)
{
GetObjectFromReaderNode(ref obj, ref nodeXmlReader, ref objPropInfo, true, nodeName);
}
}
}
}
if (xmlReader.ReadState != ReadState.Closed)
{
xmlReader.Close();
}
return obj;
}
#endregion

#region GetObjectFromReaderNode
private void GetObjectFromReaderNode(ref T obj, ref XmlReader nodeXmlReader, ref PropertyInfo[] objPropInfo, bool AreElementsReq, string nodeName)
{
Dictionary xmlFileValues = new Dictionary();
while (nodeXmlReader.MoveToNextAttribute())
{
xmlFileValues.Add(nodeXmlReader.Name.ToUpper(), nodeXmlReader.Value);
}
foreach (PropertyInfo pi in objPropInfo)
{
if (pi.Name == "DEPTH")
{
pi.SetValue(obj, (object)(nodeXmlReader.Depth + 1), null);
}
else
{
string currAttrVal;
if (xmlFileValues.TryGetValue(pi.Name.ToUpper(), out currAttrVal))
{
if (pi.PropertyType == typeof(Boolean))
{
pi.SetValue(obj, Convert.ToBoolean(currAttrVal.ToLower()), null);
}
else
{
pi.SetValue(obj, (object)currAttrVal, null);
}
}
}
}
if (AreElementsReq)
{
bool firstOccur = true;
while (xmlReader.Read() && firstOccur)
{
if (xmlReader.NodeType == XmlNodeType.Element && xmlReader.NodeType != XmlNodeType.Document)
{
string elementName = nodeXmlReader.Name;
// To Stop Retrieving Inner Elements value
if (elementName == nodeName)
{
firstOccur = false;
}
string currElementVal;
foreach (PropertyInfo pi in objPropInfo)
{
if (pi.Name.ToUpper() == elementName.ToUpper())
{
pi.SetValue(obj, (object)nodeXmlReader.ReadElementString(), null);
}
}
}
}
}
}
#endregion

#region LoadList
public List LoadList(string nodeName, bool includeElement) where T : new()
{
T obj = new T();
List retList = new List();
if (string.IsNullOrEmpty(nodeName))
{
throw new Exception("Node not specified.");
}
bool IsRequestedItem = true;
PropertyInfo[] objPropInfo = obj.GetType().GetProperties();
while (xmlReader.Read())
{
if (xmlReader.NodeType == XmlNodeType.Element && xmlReader.NodeType != XmlNodeType.Document)
{
if (xmlReader.Name == nodeName)
{
obj = new T();
GetObjectFromReaderNode(ref obj, ref xmlReader, ref objPropInfo, includeElement, nodeName);
retList.Add(obj);
}
}
}
if (xmlReader.ReadState != ReadState.Closed)
{
xmlReader.Close();
}
return retList;
}
#endregion

#region SaveXmlFragment
// Summary:
// To Save XmlFragment at the end of the file
public void SaveXmlFragment(string rawXmlFragment, string rootItem)
{
try
{
using (xmlReader)
{
while (xmlReader.Read())
{
if (xmlReader.NodeType == XmlNodeType.Element && xmlReader.Name == rootItem)
{
xmlWriter.WriteStartElement(rootItem);
xmlWriter.WriteRaw(xmlReader.ReadInnerXml());
xmlWriter.WriteRaw(rawXmlFragment);
xmlWriter.WriteEndElement();
}
else if (xmlReader.NodeType == XmlNodeType.Comment || xmlReader.NodeType == XmlNodeType.Text || xmlReader.NodeType == XmlNodeType.Whitespace)
{

}
else
{
xmlWriter.WriteNode(xmlReader, true);
}
}
xmlWriter.Flush();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
xmlReader.Close();
xmlWriter.Close();
FileInfo fi = new FileInfo(_documentDirectory + "SiteData.xml");
File.Copy(_documentDirectory + "_tempSiteData.xml", fi.FullName, true);
}
}
#endregion

#region Search Document
// Summary:
// To Save XmlFragment at the end of the file
public SortedDictionary> SearchDocument(string searchText, string nodeName, string propertyNameToLookFor) where T : new()
{
List searchWords = new List();

string[] allWords = searchText.Split(' ');

for (int i = 0; i <>> retDictionary = new SortedDictionary>();

T obj = new T();

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

List retList = this.LoadList(nodeName, true);

foreach (T item in retList)
{
string content = "";
int relevance = 0;
foreach (PropertyInfo pi in piAll)
{
if (pi.Name == propertyNameToLookFor)
{
content = Convert.ToString(pi.GetValue(item, null));
}
}
string[] contentSplitted = content.Split(' ');
foreach (string word in searchWords)
{
for (int i = 0; i <> relCorrList = new List();
relCorrList.Add(item);
retDictionary.Add(relevance, relCorrList);
}
else
{
retDictionary[relevance].Add(item);
}
}
}
return retDictionary;
}
#endregion

#region IDisposable Members
public void Dispose()
{
if (xmlReader.ReadState != ReadState.Closed)
{
xmlReader.Close();
xmlWriter.Close();
}
}

#endregion

}

if you are getting it difficult to understand or have some queries you can put a reply or mail me at
shashank.abes at gmail.com

Some Useful Sql Server Queries

2008-05-06T12:18:00.000+05:30

Some Useful Sql Server Queries

Get Number Of Days in a Month:

SQL Query to get No of Days in a month:-

SELECT DAY(DATEADD(MONTH, 1, GETDATE()) - DAY(DATEADD(MONTH, 1, GETDATE())))

Reading XMl from Sql Server

DECLARE @FileName varchar(255)

DECLARE @ExecCmd VARCHAR(255)

DECLARE @y INT

DECLARE @x INT

DECLARE @FileContents VARCHAR(8000)

CREATE TABLE #tempXML(PK INT NOT NULL IDENTITY(1,1), ThisLine VARCHAR(255))

SET @FileName = Full Path To Xml \General.xml'

SET @ExecCmd = 'type ' + @FileName

SET @FileContents = ''

INSERT INTO #tempXML EXEC master.dbo.xp_cmdshell @ExecCmd

SELECT @y = count(*) from #tempXML

SET @x = 0

WHILE @x <> @y

BEGIN

SET @x = @x + 1

SELECT @FileContents = @FileContents + ThisLine from #tempXML WHERE PK = @x

END

SELECT @FileContents as FileContents

DROP TABLE #tempXML

Grouping Records in Sql Server 2005

declare @NO_OF_PARTITION int

set @NO_OF_PARTITION = 10

SELECT c.First_Name, c.Last_Name , C.DIVISION_ID

,NTILE(@NO_OF_PARTITION)

OVER(PARTITION BY DIVISION_ID ORDER BY DIVISION_ID ASC) AS 'GROUP_ID'

FROM EMPLOYEE C

WHERE division_id = 2

ORDER BY DIVISION_ID ASC

Replacement to IN and NOT IN from INTERSECT and EXCEPT

SELECT EMPLOYEE_ID FROM EMPLOYEE

INTERSECT

SELECT EMPLOYEE_ID FROM LEAVE_DETAILS

SELECT EMPLOYEE_ID FROM EMPLOYEE

EXCEPT

SELECT EMPLOYEE_ID FROM LEAVE_DETAILS

Using NTILE to tile (group) your records

SELECT c.First_Name, c.Last_Name , C.DIVISION_ID

,NTILE(2)

OVER(PARTITION BY DIVISION_ID ORDER BY DIVISION_ID ASC) AS 'GROUP_ID'

FROM EMPLOYEE C

WHERE EMPLOYEE_ID < 13

ORDER BY DIVISION_ID ASC

Get Serial No. with the query result (ROW_NUMBER function SQL Server 2005)

SELECT ROW_NUMBER() OVER (ORDER BY DIVISION_ID ASC) AS ROWID, * FROM EMPLOYEE

Using Pivot Keyword SQL Server 2005

CREATE TABLE dbo.SalesByQuarter
(
Y INT,
Q INT,
sales INT,
PRIMARY KEY (Y,Q)
)
GO

INSERT dbo.SalesByQuarter(Y,Q,Sales)
SELECT 2003, 2, 479000
UNION SELECT 2003, 3, 321000
UNION SELECT 2003, 4, 324000
UNION SELECT 2004, 1, 612000
UNION SELECT 2004, 2, 524000
UNION SELECT 2004, 3, 342000
UNION SELECT 2004, 4, 357000
UNION SELECT 2005, 1, 734000
GO

SELECT Y,
[1] AS Q1,
[2] AS Q2,
[3] AS Q3,
[4] AS Q4
FROM
(SELECT Y, Q, Sales
FROM SalesByQuarter) s
PIVOT
(
SUM(Sales)
FOR Q IN ([1],[2],[3],[4])
) p
ORDER BY [Y]
GO

DROP TABLE dbo.SalesByQuarter
GO

Generic List Predicates

2008-04-05T17:10:00.000+05:30

Have you ever considered of searching on a list based upon a single value, for example we have a List and Employee contains a Property names Name and EmpCode.

There are many ways to search for it, we can walk through a foreach loop, or call our database, or whatsoever But we also have functions called Find and FindAll that expects a function the returns a bool value.

Now how we can use it. Suppose we are having a list of Employees say :

List lstEmployee

and we want to search an employee that contains EmpCode = 0.

We can write a function like:

int _empCode = 4;

Employee empWithCode = lstEmployee.FindAll(new Predicate(GetSingleEmployeeForCode));

private void GetSingleEmployeeForCode(Employee emp)

{

if (emp.EmpCode == _empCode)

{

return true;
}

return false;

}

This will return us the employee with EmpCode 4.

Now how can we search for items that may have same value for different objects in list.

We have function like :

List maleEmpList;

maleEmpList = lstEmployee.FindAll(new Predicate(GetMaleEmployees));

private void GetMaleEmployees (Employee emp)

{

if (emp.Gender == "Male")

{

return true;
}

return false;

}

How to perform Sort operation in List Generic List

2008-04-05T17:09:00.001+05:30

Today I am coming with a small but efficient code for performing Sort operation in List. I am not going to explain it in much details as the code is

self understandable.

List braList;

braList = _branManager.GetBranchList();

braList.Sort

(

delegate(Branch braA, Branch braB)

{

if (CompanySortDirection == SortDirection.Ascending)

{

return braA.BranchCode.CompareTo(braB.BranchCode);

}

else// if (CompanySortDirection == SortDirection.Descending)

{

return braB.BranchCode.CompareTo(braA.BranchCode);

}

);

Depending upon the Sort Direction the list get sorted.

Use of Generics with C#

2008-03-21T10:13:00.000+05:30

Its a long time when I last posted...

Now I am coming up with a brief but self explanatory article on C# Generics that will explain use of generics to less experienced persons in C#.

Before continuing to this post I would like to say if you are not using the concept of objects and classes (or say OOPS principles) in your development than the principle of Generics is not going to help you much.

However, what are Generics?

In a lot of articles you will get the Generics are similar to C++ Templates. Yes it is. The concept is same as C++ Templates but the internal implementation and advantage is the place where both of these differs slightly.

Basically Generics is to do once and use multiple concept.

Now we will write a simple example to let you know about the Generic functions:

Say we want to write a function where we will pass any object:

The function definition will look like this:

public string GetStringRepresentation(T t, string propertyNameToLookFor) where T : new()

{

return "";

}

Now here we are declaring that our first parameter T t is a generic Type.

Now what we can do with this. To use this lets take a look on to the enhanced function below:

public string GetStringRepresentation(T t, string propertyNameToLookFor) where T : new()

{

t = default(T); // specifying the default value to the coming type

return t.ToString();

}

Role of default keyword in generics:

The default keyword let us specify the initial value for the coming type if it is int the default value will go to 0, if the coming type is string it will be assigned to “” or if it is an object the default value will go to null.

For more information follow the link.

Putting constraints on the coming T types in a function:

Suppose you want to put some constraints on the parameter T so that you can look for

using System;

using System.Collections.Generic;

using System.Text;

using System.Reflection;

namespace GenericTest

{

public interface IConstraint

{

void Constraints();

}

public class DummyClass : IConstraint

{

#region IConstraint Members

public void Constraints()

{

// Constraint Applied

}

#endregion

}

public class TypeTProceesing

{

public T ProcessT() where T : IConstraint, new()

{

T t = new T();

t.Constraints(); // As we are putting constraint on the

// parameter T that it will be

// implementing interface IConstraint

// That's why we are able to call the

// function Constraints() here.

return t;

}

If you have any query regarding how to utilize the concepts of Generics

Let me know as a reply for this post or contact me at

Shashank.abes@gmail.com

Basics of NHibernate

2007-04-25T17:51:00.000+05:30

NHibernate: An Object to Relational Mapping Tool.

This post is to just let you know how to start working with NHibernate a tool that let you save your real world objects directly to your relational database.
It handles persisting plain .NET objects to and from an underlying relational database. Given an XML description of your entities and relationships, NHibernate automatically generates SQL for loading and storing the objects.

For detailed description and downloading NHibernate please visit the site:
http://www.hibernate.org
However the following lines let you know how you can start working with NHibernate.
The environment that I am choosing is .NET 2003, SQL Server 2000, NHibernateContrib-1.0.4.0.zip, Language : C#

First create a website and add the reference of NHibernate.dll found under the folder NHibernateContrib-1.0.4.0\bin\

Add reference of NHibernate.dll and add the rest of the dlls in your projects bin directory.

So now you are able to add NHibernate code but remember to build to check whether you are using the right version of NHibernate or not…..

Ok, Now lets start working with a class whose object you want to store in your database.

I am naming this class as Cat.
FIRST PERSISTENT CLASS : CAT

using System;

namespace testa
{
///

/// Summary description for Cat.
///

public class Cat
{
private string id;
private string name;
private char sex;
private float weight;

public string Id
{
get
{
return id;
}
set
{
id = value;
}
}
public string Name
{
get
{
return name;
}
set
{
name = value;
}
}
public char Sex
{
get
{
return sex;
}
set
{
sex = value;
}
}
public float Weight
{
get
{
return weight;
}
set
{
weight = value;
}
}

public Cat()
{
//
// TODO: Add constructor logic here
//
}
}
}

This is a normal C# class with some properties whose object you want to store to your database.

MAPPING THE CAT
Create an xml file but remember to put it in the same directory where your class resides and name it Cat.hbm.xml. The content of Cat.hbm.xml will look like this:

Do remember to make the Cat.hbm.xml an embed reource in your application by clicking on the Cat.hbm.xml and pushing F4 in your keyboard and then choose Build Action as: Embedded Resource

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" namespace="testa" assembly="testa">
<class name="Cat" table="Cat">
<id name="Id">
<column name="CatId" sql-type="char(30)" not-null="true" />
<generator class="uuid.hex" />
</id>
<property name="Name">
<column name="Name" length="16" not-null="true" />
</property>
<property name="Sex" />
<property name="Weight" />
</class>
</hibernate-mapping>

The table cat in the database will look like this:
Column Type
CatId char(32)
Name nvarchar(16)
Sex char(1)
Weight float

Meanwhile something about NHibernate’s ISession. Its an interface that let you store and retrieve objects from the database.
To get ISession from the ISessionFactory:

ISessionFactory sessionFactory =
new Configuration().Configure().BuildSessionFactory();

An ISessionFactory is usually only built once, e.g. at startup inside Application_Start event handler. This also means you should not keep it in an instance variable in your ASP.NET pages, but in some other location. Furthermore, we need some kind of Singleton, so we can access the ISessionFactory easily in application code. The approach shown next solves both problems: configuration and easy access to a ISessionFactory.

We will do this by Impleting a helper calss that will take care for all the Sessions open for the applications:
Implementing the NHibernate Helper Class:

using System;
using System.Web;
using NHibernate;
using NHibernate.Cfg;

namespace testa
{
///

/// Summary description for NHibernateHelper.
///

public sealed class NHibernateHelper
{
private const string CurrentSessionKey = "nhibernate.current_session";
private static readonly ISessionFactory sessionFactory;

static NHibernateHelper()
{
sessionFactory = new Configuration().Configure().BuildSessionFactory();
}

public static ISession GetCurrentSession()
{
HttpContext context = HttpContext.Current;
ISession currentSession = context.Items[CurrentSessionKey] as ISession;

if (currentSession == null)
{
currentSession = sessionFactory.OpenSession();
context.Items[CurrentSessionKey] = currentSession;
}
return currentSession;
}

public static void CloseSession()
{
HttpContext context = HttpContext.Current;
ISession currentSession = context.Items[CurrentSessionKey] as ISession;

if (currentSession == null)
{
return;
}

currentSession.Close();
context.Items.Remove(CurrentSessionKey);
}

public static void CloseSessionFactory()
{
if (sessionFactory != null)
{
sessionFactory.Close();
}
}
}
}

Now if we have all the sessions available we can use it for persisting our objects.

Make a webform from where you want to save your objects.
I called it CallToHibernate.aspx and in the Codebehind class use the following code.

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using NHibernate;
using NHibernate.Cfg;

namespace testa
{
///

/// Summary description for CallToHibernate.
///

public class CallToHibernate : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
ISession currentSession = NHibernateHelper.GetCurrentSession();
ITransaction tx = currentSession.BeginTransaction();

Cat myCat = new Cat();

myCat.Name = "Nina";
myCat.Sex = 'F';
myCat.Weight = 32.23f;

// To persist data to the database
currentSession.SaveOrUpdate(myCat); // or call only the Save method
/* To load data based upon the identifier.
Use the currentSession.Load(object type, object identifier) method.
* */
tx.Commit();

NHibernateHelper.CloseSession();
}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion
}
}

Now just open your browser and call the CalltoHibernate.aspx page and see the database. You have a Cat in your database named Nina.

This level of abstraction is really appreciable in real world applications.

For any query mail me at
shashank@bnkinfotech.com

Background Worker Class in .NET

2007-04-23T14:42:00.000+05:30

The BackgroundWorker class allows you to run an operation on a separate, dedicated thread. Time-consuming operations like downloads and database transactions can cause your user interface (UI) to seem as though it has stopped responding while they are running. When you want a responsive UI and you are faced with long delays associated with such operations, the BackgroundWorker class provides a convenient solution.

and here is an example how you can do this:

Step 1: Create an instance of BackgroundWorker class:

private BackgroundWorker bw = new BackgroundWorker();

Step 2: Define DoWorkEventHandler and RunWorkerCompleted events before Page_Render events :

protected override void OnPreLoad(EventArgs e)
{
bw.DoWork += new DoWorkEventHandler(bw_DoWork);

bw.RunWorkerAsync();

bw.RunWorkerCompleted += new
RunWorkerCompletedEventHandler(bw_RunWorkerCompleted);

}

void bw_DoWork(object sender, DoWorkEventArgs de)
{
// Do your background work here
}

void bw_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
BackgroundWorker bgworker = sender as BackgroundWorker;
// Finalization of your backgroundworker
}

Step 4: Also set Async="true" on your aspx page.

Thats it your background worker instance is ready to work.
To read more about BackGroundWorker class go to this link

Apply themes to your ASP.NET Pages

2007-04-02T10:41:00.000+05:30

So you want to apply themes in your ASP.NET pages.......
The simplest way to do so is to write the following code in your Page_PreInit function like this:

protected void Page_PreInit(object sender, EventArgs e)
{
Page.Theme = "StyleShhetThemeName";
}

So you have done....

Implementing Web based Chat System in ASP.NET

2007-03-21T15:54:00.000+05:30

So do you want to develop a web based chat application.
First of all I want to tell you something about
COMET.

So what is Comet?

Its a technology to push the data to Client from the Server in a Web Environment.
However a general web based application supports request/response model that is first the client requests than the server gives the response.
But we need the opposite of this.......................Server response without the client's request. There are various ways you can do this thing and a lot of implementation are
here

Thinking about Open Source Content Management in ASP.NET

2007-03-20T10:29:00.000+05:30

Thinking about Open Source Content Management in ASP.NET:

If you are thinking to have a versatile, User Friendly, Powerful, Feature Rich, Extensible as well as Open Source Content Management then you are looking for:

DotNetNuke

Learn more about DotNetNuke:
http://www.dotnetnuke.com/

View what you can do with DotNetNuke even more than this...at the bottom of this link

Simplest Way to perform Database operations in ASP.NET

2007-03-15T17:18:00.000+05:30

This is the simplest way to perform Database operation using C#.NET for beginners.
This function just give you the step by step explanation to perform the database operations. However the best way to perform db operations is to build a business logic and dbOperations layer seperately but for beginners who wants to know how to perform database operations this is the best approach to learn.

private void SaveDataToDB() // Function to perform db operation
{
/* Putting your connection string inside web.config will make the easy transportation of your code without recompilation. you just need to write your connection string once and use it through out your project. Also changing the connection string doesn't need the code compilation however if you will put your connection code in CS file (in the code) you need to recompile the code each time you will migrate from one server to another.
*/

/* Reading Connection String from your configuration settings */
string conn = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString();
/*
Or you can specify your connection string directly here.
*/
string query = @"insert into TABLE_BASIC_INFO
(LAST_NAME, FIRST_NAME, EMAIL_ID, NO_OF_CORRECT_ANS, DATE_OF_TEST)
values ('" + tbLastName.Text + "', '" + tbFirstName.Text + "', '" + tbEmailID.Text + "', " +
int.Parse(Session["ScoreQuestionDetail"].ToString())+ ",'" + System.DateTime.Now.ToShortDateString () + "')";

SqlConnection mySqlConnection = new SqlConnection(conn); // New SQLConnection Object
SqlCommand sqlComm = new SqlCommand(query, mySqlConnection);
try
{
mySqlConnection.Open ();
sqlComm.ExecuteNonQuery(); // Performing query to the database
mySqlConnection.Close();
}
catch (SqlException se)
{
Response.Write("Currently Facing Problem with Server " + "
" + se.ToString());
}

// Response.Write("Somewhat Problem with dbOperation "+se.ToString());
}

Writing your own JSP Tag Library

2007-02-20T10:37:00.001+05:30

Writing your own JSP Tag Library:
This is not too hard to write your own custom tag libraries that can be reused over and over also it is simple enough to do so. Just go step by step and do as said in the tutorial. I have used Tomcat Server so the directory structure may need to be changed.

Step 1:
Write a file with .tld extension that will explain the feature of your tag that you are going to build and place it in tld folder under WEB-INF directory and Name it whatever you want. An example bnk.tld file is :

*********************** Bnk.tld *************************

<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE taglib PUBLIC "-//Sun Microsystems, Inc.//DTD JSP Tag Library 1.1//EN"
"http://java.sun.com/j2ee/dtds/web-jsptaglibrary_1_1.dtd">

<taglib>
<tlibversion>1.0</tlibversion>
<jspversion>1.1</jspversion>
<shortname>BNKTagLib</shortname>
<info>BNK Tag library</info>
<tag>
<name>Repeater</name>
<tagclass>BNK.TAGS.Repeater</tagclass>
<bodycontent>empty</bodycontent>
<info>
This is a simple BNK tag.
</info>


<attribute>
<name>sqlQuery</name>
<required>true</required>
<rtexpvalue>false</rtexpvalue>
</attribute>
<attribute>
<name>cssClass</name>
<required>false</required>
<rtexpvalue>false</rtexpvalue>
</attribute>
</tag>
</taglib>

********************* Bnk.tld **********************

Step 2:

Create a java file that will explain the function as you want by your tag. For example my tag will create a table that will display all the information returned by a query.
And the query is the parameter passed to my tag with the class applied to the tag. These classes need to be placed within the classes subfolder of WEB-INF directory.

********************* Repeater.java **********************
The Repeater.java file will look like this:

package BNK.TAGS;

import javax.servlet.jsp.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.tagext.*;
import javax.servlet.ServletResponse;
import java.sql.*;
import BNK.TAGS.DataAccess;

public class Repeater extends TagSupport
{

private String sqlQuery;
private String cssClass;
/*
Getter Setter for the attributes
*/
public String getSqlQuery()
{
return this.sqlQuery;
}
public void setSqlQuery(String query)
{
this.sqlQuery = query;
}

public String getCssClass()
{
return this.cssClass;
}
public void setCssClass(String css)
{
this.cssClass = css;
}

public int doStartTag() throws JspTagException
{
getSqlQuery();
DataAccess da = new DataAccess(this.sqlQuery);

//DataAccess.DataAccessClassName();
//da.sqlQuery = this.sqlQuery;
ResultSet rs = da.DataAccessQueryFunction();

JspWriter out = pageContext.getOut();
try
{

if (rs != null)
{
int i = 1;

out.println("<table cellpadding='2' border='1' cellspacing='0'" + "class=" + "'"+ cssClass +"'" + ">");

while (rs.next())
{

out.println("<tr>");

out.println("<td>");
out.println(rs.getString("SKILL_ID"));
out.println("</td>");

out.println("<td>");
out.println(rs.getString("SKILL_NAME"));
out.println("</td>");

out.println("</tr>");
i ++;
}

out.println("</table>");
}
else
{
out.println(rs);
}
}
catch (Exception ex)
{
throw new JspTagException("All is not well in the world." + ex.toString() );
}
// Evaluate the body if there is one
return SKIP_BODY;
}

/**
* doEndTag is called by the JSP container when the tag is closed
*/
public int doEndTag(){
try {
//JspWriter out = pageContext.getOut();
//out.println("</table>");
} catch (Exception ex){
throw new Error("All is not well in the world.asdasd");
}
return SKIP_BODY;
}
}
********************* Repeater.java **********************

Also I have used a reference to the DataAccess class that will provide the interface to perform queries to the database and will return a ResultSet containing the result.
This is also need to be placed in the same directory where we put our Repeater.java file.

********************* DataAccess.java *********************
package BNK.TAGS;

import java.sql.*;

public class DataAccess
{
private static String URL = "jdbc:mysql://localhost:3306/Testing?autoReconnect=true";
private static String user = "userName";
private static String password = "password";

public ResultSet results = null;
public String error = "";
public String sqlQuery = "";

public DataAccess(String sql)
{
this.sqlQuery = sql;
}

public ResultSet DataAccessQueryFunction()
{
error += sqlQuery;
try
{
Class.forName ("com.mysql.jdbc.Driver").newInstance();
}

catch (Exception e)
{

}
finally
{
}
try
{
Connection connection = DriverManager.getConnection(URL, user, password);

Statement statement = connection.createStatement();

results = statement.executeQuery(this.sqlQuery);
}
catch (SQLException e)
{
System.err.println("Exception " +e.toString());
error += "<br />" + e.toString();
}

return results;
}
}

********************* DataAccess.java *********************

Step 3:
Calling the tag………………

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>

<%--
The next line calls our bnk.tld file so that the repeater control will be available here.
--%>

<%@ taglib uri="/WEB-INF/tld/bnk.tld" prefix="bnk" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>BNK Sample Tag Library</title>
</head>
<body>

<h1> BNK Sample Tag Library </h1>

<bnk:Repeater sqlQuery = "select * from tablename" cssClass="tableClass" />

</body>
</html>

Just watch the output on your web page.

So now you can use this tag wherever required.
Isn’t it simple enough !

Javascript window_onbeforeunload Event

2007-02-13T17:05:00.000+05:30

shashank's Work

2007-02-09T17:26:00.000+05:30

1. Betting System for Mindshift Technologies

Duration - 5 Weeks

Front End - ASP.NET 2.0 (using C#)

Database - MS Sql Server 2000

Client - Mindshift Technologies

Project Description: It was a betting system for Mindshift Technologies, in which their employees can bet on the pools created by the administrator and can view the pool results.

Link:http://dev.bnkinfotech.com/Mindshift

2. Kikora Educational Software

Duration - 8 Weeks

Front End - JSP

Database - My Sql

Group - 3 People

Project Description: It was an online mathematical testing system for relatively small children in which the random exercise generation was based upon the input algorithms.

Link:http://delhi.conversationtech.com:8083/Kikora

3. XML File Editing Tool for Arora Board Review

Duration - 4 Weeks

Front End - ASP.NET using C#

Client - Arora Board Review

Project Description: It was an online XML File editing tool that let the user update the XML file.

4. HFT Music Bulk Mailing System

Duration - 3 Weeks

Front End - ASP.NET using C#

Database - MS Sql Server 2000

Client - HFT Music

Project Description: It was a mailing system to send bulk mail at once. It was getting the email address of subscribers through database and send them all the mail.

5. EXTOP for World Bank Publication

Duration - 40 Weeks

Front End - ASP.NET using C#

Database - Oracle 9i

Client - World Bank Publication

Project Description: It was the conversion of an existing workflow management system (in Tickle) of Worldbank Publication house that we converted into ASP.NET version.

6. Dot Net Nuke Skinning Work to provide CMS to the Clients

a. BNK Infotech Pvt. Ltd. Website (http://www.bnkinfotech.com)

b. Global Strategy Project website (demo at http://dev.bnkinfotech.com/gsp/)

c. Skin for Devcomm site of Worlbank (demo at http://dev.bnkinfotech.com/devcomm/)

d. Skin for Outreach site of Worlbank (demo at http://dev.bnkinfotech.com/devoutreach/)

e. Skin for PS Energy Website (demo at http://dev.bnkinfotech.com/PSEnergyF/)

f. Skin for Logsup Website (demo at http://dev.bnkinfotech.com/Logsup /)

g. Skin for Earthday Network Website (demo at http://dev.bnkinfotech.com/earthday/)

h. Skin for Integrated Business Technologies Website (demo at http://dev.bnkinfotech.com/IBT/)

Hi from shashank

2007-02-09T16:40:00.000+05:30

Hi! I am Shashank Mishra.

shashank mishra

Merge Statement SQL Server 2008

SQL Server 2008:Output Clause Sample

Create class variables and properties from database table

SQL Server 2008 Features

Power of Reflection Emit

Microsoft Product Code Names

Current '''ProductCodeNames''' - Various Microsoft product codenames from over the years.

11/12/2007 4:33:10 AM - Zeus

CodeNames

Operating System Components / Versions

Server Products

SQL

Exchange

SharePoint Portal Server 2003 links

9/14/2004 12:10:55 AM - roberdan

SharePoint

add a one or paragraph summary or description of what's discussed here; put yours after 'Summary:'

9/2/2004 3:33:27 PM - kevinh

BizTalk

Misc

Mobile PC

Mobile Platforms

Miscellaneous

Read Write and Search XML Document in ASP.NET

Some Useful Sql Server Queries

Generic List Predicates

How to perform Sort operation in List Generic List

Use of Generics with C#

Basics of NHibernate

NHibernate: An Object to Relational Mapping Tool.

Background Worker Class in .NET

Apply themes to your ASP.NET Pages

Implementing Web based Chat System in ASP.NET

Thinking about Open Source Content Management in ASP.NET

Simplest Way to perform Database operations in ASP.NET

Writing your own JSP Tag Library

Javascript window_onbeforeunload Event

shashank's Work

Hi from shashank

Current