Thursday, October 15, 2009

SQL Management Studio Find and Replace Generated Script Tag with Variable

Replace generated script tags for values with variable

e.g. ,[SURNAME] =

becomes
,[SURNAME] = @SURNAME

use find and replace with regular expression
find expression: \<{:w+},[^\>]+\>
replace expression: @\1

This is useful for sql studio generated insert and update script

Thursday, July 2, 2009

Turn off File Readonly Attribute

alway turn it off
fi.Attributes &= ~FileAttributes.ReadOnly;

flip
fi.Attributes ^= FileAttributes.ReadOnly;

Regular Expression CSV Tokeniser Update

see this link for previous blog http://me7486.blogspot.com/2008/06/regular-expression-for-parsing-csv-file_729.html

in addition to previous blogs, if you have situation like "this ""is"" not working",",right". you will need to use the following expression
((?(?=\x22)(?:\x22{1})(?<column>.*?)(?:\x22{1})|(?<column>[^,\r\n]*))(?:[,\r\n]))




Friday, June 12, 2009

Remote Desktop Automatic Logon in Windows XP (User Password Not Required)

micrsoft support link http://support.microsoft.com/kb/281262

This article describes how to turn on Remote Desktop automatic logon. By default, this version of Windows XP is configured to prompt each user to enter a password when connecting through the Remote Desktop client. This behavior holds true even when a correct user name and password are entered in the Remote Desktop Connection box before logon. This article describes how to alter this behavior.


Back to the top
Enable Remote Desktop Logon
To allow automatic logon to a computer running this version of Windows XP through Remote Desktop, follow these steps while logged on as an Administrator:

   1. Click Start, click Run, type MMC, and then press ENTER.
   2. Click File, and then click Add/Remove Snap-in.
   3. Click Add, select Group Policy, click Add, and then click Finish.
   4. Click Close, and then click OK.
   5. Navigate to the following directory:
      Local Computer Policy/Computer Configuration/Administrative Templates/Windows Components/Terminal Services/Encryption and Security
   6. Double-click Always prompt client for password upon connection.
   7. Click the Disabled box, and then click OK. You may now quit the MMC snap-in. Remote Desktop clients should now be able to connect to this Windows XP computer using the automatic logon feature of the Remote Desktop client.

Auto Scrolling C# List Box

source from this article http://www.java2s.com/Code/CSharp/GUI-Windows-Form/SetTopIndextoautoscrollListBox.htm

the key code:

eventLogList.Items.Add(data);

int itemsPerPage = (int)(eventLogList.Height / eventLogList.ItemHeight);

eventLogList.TopIndex = eventLogList.Items.Count - itemsPerPage;

Friday, May 8, 2009

Windows XP Auto Logon

http://www.microsoft.com/windowsxp/using/setup/tips/advanced/autologon.mspx

1. Run (windows run...) "control userpasswords2" and click OK.
2. Clear the Users must enter a user name and password to use this computer check box. Click OK
3. Click the User name box, type the user name that was displayed on the Start menu in step 1. If you normally type a password to log on, type your password in both the Password and Confirm Password boxes. Otherwise, leave these boxes blank. Click OK.

This will allow windows to auto logon with out asking you for password

Thursday, March 12, 2009

How to stop Windows restart after an update

Solution
Windows may need to be restarted after an update has occurred, in order to allow files that are in use to be replaced. If you would prefer to restart the computer at your convenience, and not be nagged to do so, try one of the following solutions:

Method 1
Click Start, Run and enter the command net stop wuauserv
This will stop the Windows Update service until the next restart of the computer, which will stop the reminders to restart your computer for this update.

Method 2
If you are running Windows XP Professional, the following steps will increase the period between restart reminders to the maximum possible.

Click Start, Run and enter the command gpedit.msc
Select Local Computer Policy, Computer Configuration, Administrative Templates, Windows Components, Windows Update
Double-click Re-prompt for restart with scheduled installations
Change the value to 1440
Close the Group Policy Editor
Click Start, Run and enter the command gpupdate /force
This will stop the repeated reminders for this and all future Windows updates.


Here's how to prevent Automatic Update from rebooting your machine:

Start -> Run
Type: gpedit.msc
Expand Local Computer Policy / Computer Configuration / Administrative Templates / Windows Components / Windows Update
Double-click "No auto-restart for scheduled Automatic Updates installations"
Select "Enabled", then OK. Close the Group Policy configuration program.


Sunday, February 15, 2009

RUN .NET Windows Application (.exe) in OSX

Install Mono http://www.mono-project.com/Main_Page

To run .NET Application Assembly exe

browse the directory contain the application and type
   
     mono YourApplication.exe

Apple Script
do shell script "mono /Users/YOU/Downloads/YourApplication.exe"


Wednesday, February 11, 2009

Remote Desktop Switch Full Screen Keyboard Shortcut

To switch to full screen with remote desktop (remote desktop will capture special key stroke such as alt+tab in full screen mode)

control + alt + pause



Monday, February 2, 2009

Vodafone New Zealand Internet APN Setting

What are Vodafone’s Internet APN’s?

Vodafone provide a range of APN’s (Access Point Names) that can change your connection characteristics when using 3G broadband, 3G or GPRS. The default APN used by devices will cater to the majority of Internet-based applications, however the table below contains other APN’s that are available to cater to the more specific requirements of other applications.


APN name


IP Addressing


Optimisation


Security

www.vodafone.net.nz


Public


When connection initiated in GPRS coverage


Unsolicited inbound traffic is blocked

internet


Public


No


Unsolicited inbound traffic is permitted

direct.vodafone.net.nz


Private


No


Unsolicited inbound traffic is blocked

www.vodafone.net.nz
This is the default APN used to access the Internet from the Vodafone network. It assigns public IP addresses. It will provide users with an optimised experience when the connection is created in GPRS coverage areas. Sessions initiated in 3G / 3G broadband coverage will bypass the optimisers. The security policy utilised by this APN restricts inbound initiated traffic – reducing the threat of unsolicited traffic from the internet.

Internet
The Internet APN has been designed with a more flexible security policy. It allows inbound initiated traffic, which is a requirement for some services. It is important to note that you will be exposed to and charged for this any unsolicited traffic from the Internet. This APN assigns public IP addresses and is un-optimised for all networks.

direct.vodafone.net.nz
The ‘direct’ APN bypasses the optimisers for all radio access types. It assigns private NAT’d IP addresses and employs the same security policy as the ‘www’ APN.

opt.vodafone.net.nz
The ‘opt’ APN has been created to provide a fully optimised experience across all network types. It assigns private NAT’d IP addresses and employs the same security policy as the ‘www’ APN.

Wednesday, January 21, 2009

ASCII Character Table

The Control Characters

The first 32 values are non-printing control characters, such as Return and Line feed. You generate these characters on the keyboard by holding down the Control key while you strike another key. For example, Bell is value 7, Control plus G, often shown in documents as ^G. Notice that 7 is 64 less than the value of G (71); the Control key subtracts 64 from the value of the keys that it modifies.


Control Characters

CharOctDecHexControl-KeyControl Action
NUL000^@Null character
SOH111^AStart of heading, = console interrupt
STX222^BStart of text, maintenance mode on HP console
ETX333^CEnd of text
EOT444^DEnd of transmission, not the same as ETB
ENQ555^EEnquiry, goes with ACK; old HP flow control
ACK666^FAcknowledge, clears ENQ logon hand
BEL777^GBell, rings the bell...
BS1088^HBackspace, works on HP terminals/computers
HT1199^IHorizontal tab, move to next tab stop
LF1210a^JLine Feed
VT1311b^KVertical tab
FF1412c^LForm Feed, page eject
CR1513d^MCarriage Return
SO1614e^NShift Out, alternate character set
SI1715f^OShift In, resume defaultn character set
DLE201610^PData link escape
DC1211711^QXON, with XOFF to pause listings; ":okay to send".
DC2221812^RDevice control 2, block-mode flow control
DC3231913^SXOFF, with XON is TERM=18 flow control
DC4242014^TDevice control 4
NAK252115^UNegative acknowledge
SYN262216^VSynchronous idle
ETB272317^WEnd transmission block, not the same as EOT
CAN302417^XCancel line, MPE echoes !!!
EM312519^YEnd of medium, Control-Y interrupt
SUB32261a^ZSubstitute
ESC33271b^[Escape, next character is not echoed
FS34281c^\File separator
GS35291d^]Group separator
RS36301e^^Record separator, block-mode terminator
US37311f^_Unit separator

Printing Characters

CharOctalDecHexDescription
SP403220Space
!413321Exclamation mark
"423422Quotation mark (" in HTML)
#433523Cross hatch (number sign)
$443624Dollar sign
%453725Percent sign
&463826Ampersand
`473927Closing single quote (apostrophe)
(504028Opening parentheses
)514129Closing parentheses
*52422aAsterisk (star, multiply)
+53432bPlus
,54442cComma
-55452dHyphen, dash, minus
.56462ePeriod
/57472fSlant (forward slash, divide)
0604830Zero
1614931One
2625032Two
3635133Three
4645234Four
5655335Five
6665436Six
7675537Seven
8705638Eight
9715739Nine
:72583aColon
;73593bSemicolon
<74603cLess than sign (< in HTML)
=75613dEquals sign
>76623eGreater than sign (> in HTML)
?77633fQuestion mark
@1006440At-sign
A1016541Uppercase A
B1026642Uppercase B
C1036743Uppercase C
D1046844Uppercase D
E1056945Uppercase E
F1067046Uppercase F
G1077147Uppercase G
H1107248Uppercase H
I1117349Uppercase I
J112744aUppercase J
K113754bUppercase K
L114764cUppercase L
M115774dUppercase M
N116784eUppercase N
O117794fUppercase O
P1208050Uppercase P
Q1218151Uppercase Q
R1228252Uppercase R
S1238353Uppercase S
T1248454Uppercase T
U1258555Uppercase U
V1268656Uppercase V
W1278757Uppercase W
X1308858Uppercase X
Y1318959Uppercase Y
Z132905aUppercase Z
[133915bOpening square bracket
\134925cReverse slant (Backslash)
]135935dClosing square bracket
^136945eCaret (Circumflex)
_137955fUnderscore
`1409660Opening single quote
a1419761Lowercase a
b1429862Lowercase b
c1439963Lowercase c
d14410064Lowercase d
e14510165Lowercase e
f14610266Lowercase f
g14710367Lowercase g
h15010468Lowercase h
i15110569Lowercase i
j1521066aLowercase j
k1531076bLowercase k
l1541086cLowercase l
m1551096dLowercase m
n1561106eLowercase n
o1571116fLowercase o
p16011270Lowercase p
q16111371Lowercase q
r16211472Lowercase r
s16311573Lowercase s
t16411674Lowercase t
u16511775Lowercase u
v16611876Lowercase v
w16711977Lowercase w
x17012078Lowercase x
y17112179Lowercase y
z1721227aLowercase z
{1731237bOpening curly brace
|1741247cVertical line
}1751257dCloing curly brace
~1761267eTilde (approximate)
DEL1771277fDelete (rubout), cross-hatch box



Programming code Source http://academic.evergreen.edu/projects/biophysics/technotes/program/ascii_ctrl.htm

Programming

ASCII Control Codes
Control
Code
To Enter With
Echo
AbbreviationFull NameDecHexAlt-KeyCtrl-Key

NULNull000 Ctrl-@^@
SOHStart of heading101Alt-1Ctrl-A^A
STXStart of text202Alt-2Ctrl-B^B
ETXEnd of text303Alt-3Ctrl-C^C
EOTEnd of transmission404Alt-4Ctrl-D^D
ENQEnquiry505Alt-5Ctrl-E^E
ACKAcknowledge606Alt-6Ctrl-F^F
BELBell707Alt-7Ctrl-G^G
BSBackspace808Alt-8Ctrl-H^H
HTHorizontal tab909Alt-9Ctrl-I^I
LFLine feed100AAlt-10Ctrl-J^J
VTVertical tab110BAlt-11Ctrl-K^K
FFForm feed120CAlt-12Ctrl-L^L
CRCarriage return130DAlt-13Ctrl-M^M
SOShift out140EAlt-14Ctrl-N^N
SIShift in150FAlt-15Ctrl-O^O
DLEData line escape1610Alt-16Ctrl-P^P
DC1Device control 11711Alt-17Ctrl-Q^Q
DC2Device control 21812Alt-18Ctrl-R^R
DC3Device control 31913Alt-19Ctrl-S^S
DC4Device control 42014Alt-20Ctrl-T^T
NAKNegative acknowledge2115Alt-21Ctrl-U^U
SYNSynchronous idle2216Alt-22Ctrl-V^V
ETBEnd transmission block2317Alt-23Ctrl-W^W
CANCancel2418Alt-24Ctrl-X^X
EMEnd of medium2519Alt-25Ctrl-Y^Y
SUBSubstitute261AAlt-26Ctrl-Z^Z
ESCEscape271BAlt-27Ctrl-[^[
FSFile separator281CAlt-28Ctrl-\^\
GSGroup separator291DAlt-29Ctrl-]^]
RSRecord separator301EAlt-30Ctrl-^^^
USUnit separator311FAlt-31Ctrl-_^_


ASCII Standard Character Set
CharCtrlDecHex
CharDecHex
CharDecHex
CharDecHex

NUL^@0003220@6440`9660
SOH^A101!3321A6541a9761
STX^B202"3422B6642b9862
ETX^C303#3523C6743c9963
EOT^D404$3624D6844d10064
ENQ^E505%3725E6945e10165
ACK^F606&3826F7046f10266
BEL^G707'3927G7147g10367
BS^H808(4028H7248h10468
HT^I909)4129I7349i10569
LF^J100A*422AJ744Aj1066A
VT^K110B+432BK754Bk1076B
FF^L120C,442CL764Cl1086C
CR^M130D-452DM774Dm1096D
SO^N140E.462EN784En1106E
SI^O150F/472FO794Fo1116F
DLE^P161004830P8050p11270
DC1^Q171114931Q8151q11371
DC2^R181225032R8252r11472
DC3^S191335133S8353s11573
DC4^T201445234T8454t11674
NAK^U211555335U8555u11775
SYN^V221665436V8656v11876
ETB^W231775537W8757w11977
CAN^X241885638X8858x12078
EM^Y251995739Y8959y12179
SUB^Z261A:583AZ905Az1227A
ESC^[271B;593B[915B{1237B
FS^\281C<603C\925C|1247C
GS^]291D=613D]935D}1257D
RS^^301E>623E^945E~1267E
US^_311F?633F_955F1277F





Notes
ASCII (American Standard Code for Information Interchange)
is
a 7-bit character code that was introduced by American National
Standards Institute (ANSI) and is used by most U.S. personal and
workstation computers.
 
Other Common Alphanumeric Codes
EBCDIC (Extended Binary Coded Decimal Interchange Code)
was developed by IBM for use on their mainframe computers.
Unicode
is
a character coding system designed to support the worldwide interchange
and display of written texts of diverse languages by providing a unique
number for every character.


Thursday, January 15, 2009

Safari Shortcut LIst OS X

 using the following link file:///Applications/Safari.app/Contents/Resources/Shortcuts.html

or

browse the content of safari application package by right click on the safari application and show package content , it is under contents/Resource

Thursday, January 8, 2009

How to install / uninstall activeX OCX Component Windows IE

HOW TO UNINSTALL ACTIVE X COMPONENT

http://support.microsoft.com/kb/154850

Internet Explorer 3.0, 3.01, and 3.02

  1. Click Start, point to Settings, click Control Panel, double-click Add/Remove Programs, and then click the Install/Uninstall tab.
  2. If the ActiveX control you want to remove appears in the list of installed programs, click the ActiveX control, click Add/Remove, and then follow the instructions on the screen. If the ActiveX control does not appear in the list of installed programs, continue with the next step.
  3. Click Start, click Run, type the following line in the Open box, and then click OK:
    regsvr32 drive:\windows\occache\filename.ocx /u
    NOTE: drive is the drive letter on which the Windows folder is located, windows is the name of the folder in which Windows is installed, and filename.ocx is the ActiveX control you want to remove.

    NOTE: If you do not know the file name of the ActiveX control (.ocx) you want to remove, you may be able to determine the file name by viewing the Hypertext Markup Language (HTML) source of a Web page that installs or uses the ActiveX control. To view the HTML source of a Web page, right-click an empty area of the Web page, and then click View Source.
  4. In Windows Explorer or Windows NT Explorer, click the .ocx file in the Windows\Occache folder, and then click Delete on the File menu.
Occache is the name of the folder where ActiveX controls are installed in all versions of Internet Explorer 3.x. The Regsvr32.exe file is installed by Internet Explorer and can be used to register and remove registry entries for ActiveX controls.

Internet Explorer 4.x or Later (All Platforms)

Internet Explorer 4.x or later, include the Occache.dll file, which is used to enumerate, update, and safely uninstall ActiveX controls using a "shell folder."
  1. Click Start, point to Settings, click Control Panel, double-click Add/Remove Programs, and then click the Install/Uninstall tab.
  2. If the ActiveX control you want to remove appears in the list of installed programs, click the ActiveX control, click Add/Remove, and then follow the instructions on the screen. If the ActiveX control does not appear in the list of installed programs, continue with the next step.
  3. In Windows Explorer or Windows NT Explorer, double-click the Windows\Downloaded Program Files folder or the Winnt\Downloaded Program Files folder, right-click the ActiveX control you want to remove, and then click Remove.
  4. When you are prompted to remove the ActiveX control, click Yes.
IMPORTANT: The following ActiveX controls should not be removed if you are running Internet Explorer 4.0:
  • DirectAnimation Java Classes
  • Internet Explorer Classes for Java
  • Microsoft XML Parser for Java
  • Win32 Classes
Internet Explorer 5.0 or later does not require these components in the Downloaded Program Files files.

Error Messages Removing ActiveX Controls

When you attempt to remove an ActiveX control using an Occache shell folder, you may receive one of the following messages:
  • Share Violation These program files are currently being used by one or more programs. Please close some programs, and try again. You may need to restart Windows.
  • Component Removal About to remove a Windows system DLL: (). Okay to delete?
Share Violation:

This message occurs if the ActiveX control you are trying to remove is currently loaded in memory by Internet Explorer or the Active Desktop component.

To resolve this error message, follow these steps:
  1. Close all open Internet Explorer windows.
  2. Disable the Active Desktop. To do so, right-click an empty area on the desktop, point to Active Desktop, and then click View As Web Page to clear the check mark.
  3. Remove the ActiveX control by following the steps in the "Internet Explorer 4.0 or Later" section earlier in this article.

    NOTE: You may need to restart Windows before you remove the ActiveX Control.
Component Removal:

This message occurs only in versions of Internet Explorer 4 prior to 4.01 Service Pack 1 (SP1) when the ActiveX control you are removing installed files into a folder other than a registered Occache folder (for example, Windows\System or Winnt\System32). Occache cannot always determine if those files are shared by their programs.

If you are certain the file or files displayed in the message are not being used by Windows or another program, click Yes. Otherwise, click No.

NOTE: In Internet Explorer 4.01 SP1 and later, Occache does not remove (or prompt you to remove) dependent files outside of a registered Occache folder.

Support for Multiple Occache Folders

Internet Explorer 4.0 and later supports multiple Occache folders. The list of Occache folders is located in the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings\ActiveX Cache
By default, Internet Explorer 4.0 and later uses the Windows\Downloaded Program Files or Winnt\Downloaded Program Files folder. If you upgraded from Internet Explorer 3.x, both an Occache and Downloaded Program Files folder may exist. In this case, all new ActiveX controls are installed in the Downloaded Program Files folder, but previously installed ActiveX controls still work in the Occache folder. When you open the Occache or Downloaded Program Files folder in Windows Explorer, Windows NT Explorer, or My Computer, all ActiveX controls are displayed regardless of the folder in which the ActiveX control's files are located. In this case, the following string values appear in the registry key:
"0"="C:\\WINDOWS\\OCCACHE"
"1"="C:\\WINDOWS\\Downloaded Program Files"
For additional information about ActiveX controls, please see the following article in the Microsoft Knowledge Base:
154544 (http://support.microsoft.com/kb/154544/EN-US/ ) Description of ActiveX Technologies
For information about how Internet Explorer downloads ActiveX controls if a conflict occurs (for example, if the file already exists), please see the following article in the Microsoft Knowledge Base:
196150 (http://support.microsoft.com/kb/196150/EN-US/ ) INFO: Why CONFLICT Directories Are Created During Code Download

To Install a ActiveX Component

use registry service tool

RegSvr32.exe C:\TestControl.ocx