C# Sql Connection String

connetionString="Data Source=ServerName;
  Initial Catalog=DatabaseName;User ID=UserName;Password=Password"

  cnn = new SqlConnection(connetionString);

Example

string connetionString = null;

            SqlConnection cnn ;

   connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password" 

            cnn = new SqlConnection(connetionString);

            try

            {

                cnn.Open();

                MessageBox.Show ("Connection Open ! ");

                cnn.Close();

            }

            catch (Exception ex)

            {

                MessageBox.Show("Can not open connection ! ");

            }

Delete single row from duplicate rows in SQL Server 2005

DECLARE @ID int

DECLARE @NAME NVARCHAR(50)
DECLARE  @COUNT int

DECLARE CUR_DELETE CURSOR FOR
SELECT [ID],[NAME],COUNT([ID]) FROM [Example] GROUP BY [ID],[NAME] HAVINGCOUNT([ID]) > 1

OPEN CUR_DELETE

FETCH NEXT FROM CUR_DELETE INTO @ID,@NAME,@COUNT
/* Loop through cursor for remaining ID */
WHILE @@FETCH_STATUS = 0
BEGIN

DELETE TOP(@COUNT -1) FROM [Example] WHERE ID = @ID

FETCH NEXT FROM CUR_DELETE INTO @ID,@NAME,@COUNT
END

CLOSE CUR_DELETE
DEALLOCATE CUR_DELETE

Blog Started

Today 29'th Feb 2012 started my blog..........