Csharp: Syntax in one file

Question:

Is there a comprehensive overview of all syntax possibilities in c# ?

Asp.Net: Create Simple Template Control

Question:

How to build a very simple Template Control in asp.net?
Do you have a sample for simplest Template Control.
Create your own Template Controls!

CSharp: Dates in universal sortable format

Question:

How to format dates as sortable universal standard format strings in C#?

CSharp: Pad Numbers with Leading Zeros

Question:

How to pad a number with leading Zeros?
How to get a 8 digits number block, where empty places are filled with zeros?
Formating a number with leading zeros.

CSharp: Implement Indexer

Question:

How to implement an indexed property in c# ??
Do you have an example implementation of an Indexer in c#?

Restore SQL Server 2005 DB on 2005 Express

Question:

We have a SQL server 2005 database in a shared production environment.
We do a backup of this database and want to restore it in a development environment having only a SQL-2005 Express Edition.
You cannot restore the prod database using the Management Studio Express.
What to do??

Insert records into SQL Server without constraints

Question:

How do I insert records into a sql database without constrains?

I want to insert a record into the database and

1. I want to set the primary key
   
2. Want to disable any contraints
3. I want no triggers to fire