Place for sharing…
String comparison in Microsoft SQL server is case insensitive by default. So if you want to perform string comparison in SQL server with case sensitive, you have two choices. Consider the following scenario. You have Credentials table with UserName and Password columns.
Read moreIn windows application configuration file, connection strings for your database can be stored as key/value pairs in the connectionStrings section of the configuration element. To access your connection string from the configuration file you need to use the following code.
Read moreIf you want a class that has only one instance for the entire application then you can create singleton class using following way. Create a class with a puplic static member which returns the same class instance. You need to use that member to access other members in that class. The following example code code…
Read moreIn windows 7 environment you may receive “Unable to get window handle, Windowless ActiveX controls are not supported..” exception when you display a child form that contains ActiveX user controls. The user control may be a third party control. To avoid this exception you may disable DEP (Data Execution Prevention) for your activex control. DEP…
Read moreIn some scenario, you may need to get table from comma separated values in SQL Server. For example if you want to get list of employee details from comma separated employee ids, you need to include “IN” clause in select statement. If you want to include this scenario in stored procedure and pass the comma…
Read moreIn the latest version of Skype application, there is no option provided to turn off Skype at windows startup as like previous version. Do the following steps to turn off Skype at startup windsows. Click the start menu and do search “msconfig” using “Search programs and files”, You will get “msconfig.exe” file. ( Or you…
Read moreThe letters A,B,C and D do not appear in the spelling of 1 to 99 (That is ONE, TWO, .. NINETY NINE). And D appears first time in HUNDRED. The A appears first time in THOUSAND. The B appears first time in BILLION. The C appears first time in CRORE. Very interesting isn’t it?
Read more