Rotate text in textboxes in rdlc reports

Set WritingMode to Vertical

WritingMode indicates whether the text is displayed horizontally or vertically.

it will make your text like this http://picskip.net/u/22094829.png

Report Parameters Missing in VS2010?

A. Open your report.
B. Click on the 'View' menu
C. Select 'Report Data'

Shortcut for this Ctrl+Alt+D

In VS2008 it was in Report's Property page as "ReportParameter"

Download TechEd North America 2010 Session Videos

http://www.msteched.com/2010/

SQL Server Compact 3.5 Toolbox

SQL Server Compact 3.5 Toolbox add-in for Visual Studio 2010. This add-in adds several features to help your SQL Server Compact development efforts: Scripting of tables and data, import from SQL Server and CSV files, and others to come.

Reset table identity column

DBCC CHECKIDENT(Product,RESEED,0)
Where Product is my table name

Difference between TRUNCATE & DELETE

About TRUNCATE
--------------
Much faster than Delete.
Can't be rollback.
Can't use where clause with it.
Can't use on a linked table. (When use on a table which is linked to another table you will see this message "Cannot truncate table 'TableName' because it is being referenced by a FOREIGN KEY constraint."

After using TRUNCATE all of the memory space is released back to the server.


About Delete
--------------
Slower than TRUNCATE.
Can be rollback (as its a DML operation).
Can use where clause with it.

After using Delete Command The memory will be occupied till the user does not give ROLLBACK or COMMIT.

Get Countries List for your application

http://www.geonames.org/