StringBuilder Object where you can point specific character but not in System.String

From sample code, you will see nice thing that can be useful in programming
--------------------------------------------------------------------------
System.Text.StringBuilder sb = new System.Text.StringBuilder("Rat: the ideal pet");
sb.Append(" is caught");
sb[0] = 'C';
System.Console.WriteLine(sb.ToString());
System.Console.ReadLine();
-----------------------------------
Output : Cat: the ideal pet is caught

Padding character before a string in sql query

select right(replicate(@padchar, @len) + @str, @len)
e.g. select right(replicate('0', 10) + 'hell boy', 10)

Expression evaluation in C#

Try with this code block which is faster than using codeDom
----------------------------------------
static double Evaluate(string expression)
{
var loDataTable = new DataTable();
var loDataColumn = new DataColumn("Eval", typeof(double), expression);
loDataTable.Columns.Add(loDataColumn);
loDataTable.Rows.Add(0);
return (double)(loDataTable.Rows[0]["Eval"]);
}

Database Restore, Error 3154

Error detalils:

Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'dbName' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

----------------------------------------------------------------
Solution:
RESTORE DATABASE dbName--AdventureWorks
FROM DISK = targeted location -- e.g. N'K:\june_24.bak'
WITH REPLACE

Register dll into gac

Register dll into gac

Copy dll from Gac

Copy dll from Gac

Google search Tips

Google 10 search Tips

Click here also for quick tips
Here 12 quick tips