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

Thursday, October 7, 2010

Cannot Debug with IE8 and Visual Studio 2005

I also discovered that the debugger in Visual Studio 2005 does not work with IE8.0. I researched this on the internet and found a solution. This method does not require that you close your IE windows first.




1.Open RegEdit

2.Browse to HKEY_LOCALMACHINE -> Software -> Microsoft - > Internet Explorer - > Main

3.Add a DWord value called TabProcGrowth

4.Set the TabProcGrowth value to 0.





http://stackoverflow.com/questions/663144/why-cant-i-debug-from-visual-studio-2005-after-installing-ie8

Monday, April 26, 2010

LINQ Programming With C# in .Net3.5

Language Integrated Query (LINQ) provides a revolutionary way to query and interact with objects, XML and databases. In this Blog you’ll be immersed in LINQ technologies and learn how to LINQ and lambda syntax along with C# 3.0 language features to increase productivity, write less code and more easily access the data your applications need. Topics covered include C# 3.0 language features, lambda expressions, LINQ to Objects, LINQ to DataSets, LINQ to XML, LINQ to SQL and LINQ to Entities. You’ll leave the blogwith a thorough understanding of how LINQ and its related technologies can be used in your company’s applications to increase overall productivity and simplify future maintenance.


This video that provides an introductory look at different LINQ technologies including:

  • Lambda Expressions
  • Extension Methods
  • LINQ to Objects
  • LINQ to XML
  • LINQ to SQL
  • LINQ to Entities


I hope its very helpful to all of you .

Thanks