Monday, November 7, 2011

Install SQL Server 2005 and 2008 on the same computer

By following the steps described, you can have both SQL Server 2005 and 2008 installed on a machine at the same time. The trick is simple, just change a Registry directory name of SQL Server 2005 Studio with the Registry editor. After the installation, you can then change it back.

1. Go to Windows > Run, enter “regedit” and click OK.
2. Browse to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsft SQL Server\90.
3. Rename “90? to something else, like “old”.

You can now rerun the process in SQL Server 2008 Express installation wizard. After installation has completed, you will notice that the old SQL Server 2005 doesn’t run when you try to launch it. No worries, to fix it, you can change the newly created directory “90? to “70?. Then change “old” that you changed from “90? before back to “90?. It should now work for both SQL Server 2005 and 2008 Studio Express.

Thursday, June 16, 2011

Function no special symbol input by using java script

function fncNoSplSymbl()
{

if(!((event.keyCode>=65 && event.keyCode<=90)||(event.keyCode>=97 && event.keyCode<=122)||event.keyCode==32||event.keyCode==48||event.keyCode==49||event.keyCode==50||event.keyCode==51||event.keyCode==52||event.keyCode==53||event.keyCode==54||event.keyCode==55||event.keyCode==56||event.keyCode==57||event.keyCode==13||event.keyCode==40||event.keyCode==41||event.keyCode==44||event.keyCode==45||event.keyCode==47))
{
event.returnValue=false;
}


}

Key Code For Java Script

Keyboard Keys and Key Code Values

The following tables list all the keys on a standard keyboard and the corresponding key code values and ASCII key code values that are used to identify the keys in ActionScript:

* Letters A to Z and standard numbers 0 to 9
* Keys on the numeric keypad
* Function keys
* Other keys

You can use key constants to intercept the built-in behavior of keypresses.

For more information on the on() handler, see on handler in the ActionScript 2.0 Language Reference. To capture key code values and ASCII key code values using a SWF file and key presses, draw a text field on the Stage. Select Input Text from the Text Type drop-down menu in the Properties panel, and click the Show border around text option. Then paste the following ActionScript code into the actions panel for the current Frame on the Timeline:

var keyListener:Object = new Object();

keyListener.onKeyDown = function() {
trace("DOWN -> Code: " + Key.getCode() + "\tACSII: " + Key.getAscii() + "\tKey: " + chr(Key.getAscii()));
};
Key.addListener(keyListener);


For more information on the Key class, see Key in ActionScript 2.0 Language Reference. To trap keys when you test a SWF file in the authoring environment (Control > Test Movie), make sure that you select Control > Disable Keyboard Shortcuts.
Letters A to Z and standard numbers 0 to 9

The following table lists the keys on a standard keyboard for the letters A to Z and the numbers 0 to 9, with the corresponding key code values that are used to identify the keys in ActionScript:

Letter or number key Key code ASCII key code

For additional key code and ASCII values, use the ActionScript at the beginning of this appendix and press the desired key to trace its key code.

To know key value of every key go to this link
http://help.adobe.com/en_US/AS2LCR/Flash_10.0/help.html?content=00000520.html

Tuesday, February 22, 2011

Connection String In Web Config

 appSettings

    add key="constr" value="Data Source=DILIPKAKANI-PC\SQLEXPRESS; Initial Catalog=chandak;uid=sa; pwd=sa;Connect Timeout=200;"

appSettings
    connectionStrings/
   

Regular Expression for Date In dd/MM/yyyy Format

Regular Expression for Date Format

TitleTestDetailsM/d/y Date
Expression
^(?:(?:(?:0?[13578]|1[02])(\/|-|\.)31)\1|(?:(?:0?[13-9]|1[0-2])(\/|-|\.)(?:29|30)\2))(?:(?:1[6-9]|[2-9]\d)?\d{2})$|^(?:0?2(\/|-|\.)29\3(?:(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|[2468][048]|[3579][26])00))))$|^(?:(?:0?[1-9])|(?:1[0-2]))(\/|-|\.)(?:0?[1-9]|1\d|2[0-8])\4(?:(?:1[6-9]|[2-9]\d)?\d{2})$
Description
This expression validates dates in the US m/d/y format from 1/1/1600 - 12/31/9999.
Matches
01.1.02 | 11-30-2001 | 2/29/2000
Non-Matches
02/29/01 | 13/01/2002 | 11/00/02


^(?:(?:(?:0?[13578]|1[02])(\/|-|\.)31)\1|(?:(?:0?[13-9]|1[0-2])(\/|-|\.)(?:29|30)\2))(?:(?:1[6-9]|[2-9]\d)?\d{2})$|^(?:0?2(\/|-|\.)29\3(?:(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|[2468][048]|[3579][26])00))))$|^(?:(?:0?[1-9])|(?:1[0-2]))(\/|-|\.)(?:0?[1-9]|1\d|2[0-8])\4(?:(?:1[6-9]|[2-9]\d)?\d{2})$

Link :http://regexlib.com/DisplayPatterns.aspx?cattabindex=4&categoryId=5