This add-in project converts c# and vb.net codes in visual studio. Sometimes we need to convert code between c# and vb.net but convertion progress is very boring. Open the web browser, google it(c# to vb.net) and using some online code convertion service and oh, code is converted. Thats really boring and difficult way.

What does CodeCopy do?

CodeCopy is simple way to code convertion between c# and vb.net languages. You can copy any c# or vb.net code and paste visual studio whit Paste with CodeCopy. Thats detect your project language and converts code to target language(c# or vb.net). It's simple!

Works on Visual Studio 2005, 2008 and 2010.

Feature plan

• Partial code converting: Converter runs on code blocks and covert code and comment code block when it is non convertable block. Notice convertable code blocks will be recover.
• Smart error fixer: We work on generic errors because some error messages fixed programmaticaly. Eg: if error is "',' expected." then we fix this problem when inserted ',' character on required line and column.
•  More effective code convertion

More...

Some times we need to search any data and we don't know this question answer "What is the table and column contains this value?" We must search string in all table and columns(char,nchar,varchar,nvarchar,text and ntext data types). In this senario we search string for each table and column. In this case lets use the cursors. More informations for cursors click here. 

Lets coding... We need to declare following variables:

DECLARE @TmpSearchString NVARCHAR(MAX) -- Search keyword
DECLARE @TmpTableName NVARCHAR(MAX) -- Temporary table name holder
DECLARE @ObjectID BIGINT -- Temporary object id
DECLARE @ObjectName nvarchar(255) -- Temporary object name
DECLARE @tblResult TABLE( -- Result table
TableName nvarchar(255),
ColumnName NVARCHAR(255),
ColumnValue nvarchar(MAX)
)

My idea is this process runs in stored procedure, so i declared procedure is bellow:

CREATE PROC FindString(@SearchString NVARCHAR(255))
AS
BEGIN

END
GO

I have written description of the required line by line.

CREATE PROC FindString(@SearchString NVARCHAR(255))
AS
BEGIN
SET NOCOUNT ON;

DECLARE @TmpSearchString NVARCHAR(MAX) -- Search keyword
DECLARE @TmpTableName NVARCHAR(MAX) -- Temporary table name holder
DECLARE @ObjectID BIGINT -- Temporary object id
DECLARE @ObjectName nvarchar(255) -- Temporary object name
DECLARE @tblResult TABLE( -- Result table
	TableName nvarchar(255),
	ColumnName NVARCHAR(255),
	ColumnValue nvarchar(MAX)
)

DECLARE myCursor CURSOR FOR
SELECT object_id, name FROM sys.columns -- Select all columns used in user defined tables
WHERE object_id IN (
	SELECT object_id FROM sys.tables WHERE type='U' -- Only user defined tables
) AND system_type_id IN (35,99,167,175,231,239)


OPEN myCursor -- Opening cursor

FETCH NEXT FROM myCursor -- Select next @ObjectID and @ObjectName from next record in myCursor
INTO @ObjectID, @ObjectName

WHILE @@FETCH_STATUS = 0 -- If next record exists
BEGIN
	-- Set table name to @TmpTableName variable
	SELECT @TmpTableName = Name FROM sys.tables WHERE object_id = @ObjectID

	/*
	* Creating search string with @TmpTableName,@ObjectName and @SearchString
	* For example: Select 'Tutorial','Name',Name From Tutorial WHERE CAST(Name as nvarchar(max)) LIKE '%lue%'
	*/
	SET @TmpSearchString =	' Select ' + '''' + @TmpTableName + ''',''' + @ObjectName + ''',' + @ObjectName + ' ' + 
	' From ' + @TmpTableName +
	' WHERE CAST(' + @ObjectName + ' AS NVARCHAR(MAX)) LIKE ''' + @SearchString + ''''
	
	-- Execute dynamic select query and insert result to @tblResult table
	INSERT INTO @tblResult
	EXEC sp_executesql @TmpSearchString
	
	-- Fetch next record
	FETCH NEXT FROM myCursor
	INTO @ObjectID, @ObjectName
	
END -- WHILE @@FETCH_STATUS = 0
	
CLOSE myCursor; -- Closing cursor
DEALLOCATE myCursor; -- Deallocating cursor
	
SELECT * FROM @tblResult -- Selecting all search results from @tblResut

END

And lets run this procedure to see results

EXEC FindString '%lue%'

Result:

In this article we learn using sp_help system procedure. This procedure using for getting summary information of object listed in sys.objects table. We use this command when there is no visual interface(management studio or others) or we don't want to use mouse :) 

In this article we learn how to query hierarchical data to database. In this article senario is classic category table listing with hierarcy. We category table design is bellow:

ParentTagId column referenced by foreing key to TagId column.  All datas is listed bellow:

More...

In this article I used the cloud effect birdunyadusun.com site will explain the technique.
Some sites have similar made with Mootools. I did research in jQuery forum. No information about the coding of similar applications. This article has nothing to parallax technique. Let's start coding.
The following code will load the clouds just below is a description of the body.

And using this javascript codes for generating clouds:

You can use this image file(Transparent PNG, thanks gündüzhan):

Output current screen:
More...