String comparison in sql server with case sensitive

Posted on February 3, 2013 by Gobikannan — 2 Comments ↓

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.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Credentials](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [varchar](255) NOT NULL,
	[Password] [varchar](255) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Read more ›

Tagged with: ,
Posted in MS SQL

Connection string from app.config in windows application

Posted on September 17, 2012 by Gobikannan — 1 Comment ↓

In windows application configuration file, connection strings for your database can be stored as key/value pairs in the connectionStrings section of the configuration element.

<configuration>
    <connectionStrings>
        <add name="MyDBConnection" connectionString="Server=xxxx; UID=xxxx; PWD=xxxx; Database=xxxx;"/>
    </connectionStrings>
</configuration>

To access your connection string from the configuration file you need to use the following code.
Read more ›

Tagged with: ,
Posted in MS .Net

Turn Off Skype at Startup Windows

Posted on March 9, 2012 by Gobikannan — 4 Comments ↓

In 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 can use Run command window to open the msconfig.exe)

Read more ›

Tagged with: ,
Posted in General

Singleton class in C sharp

Posted on February 5, 2012 by Gobikannan — No Comments ↓

If 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 will describe the singleton class process.
Read more ›

Tagged with: ,
Posted in MS .Net

Windowless ActiveX controls are not supported

Posted on January 29, 2012 by Gobikannan — No Comments ↓

In 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 (Data Execution Prevention) is a security feature from windows 7 operating system to prevent damage your system from viruses and other security threats. If your user control access memory in an incorrect way, the DEP will close the program.
If you trust the user control which you integrated in the application, you may disable the DEP for that program in following way.

Read more ›

Tagged with:
Posted in MS .Net

About Me

Hi, I am Gobikannan Ponmalai. I am here to share my experience with you through this website.   More..

Polls

What is your most favorite browser?

View Results

Loading ... Loading ...