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/

Hard Reset, Full Format, Factory Default your N86

1. *#7780# - Restore factory settings - resets all the settings to the default ( you will not lose any data)

Make sure you back up your data as you will lose all of it when you perform option 2 or 3 on this list. The default code for ALL operations listed here is 12345

2. *#7370# - Reformat your phone (out of the box, tho keep in mind that most newer nokia phones at least n series, e series and s60 based phones have udp - user data preservation so not ALL data may be lost. still it is a good idea to always do a back up of your stuff.)

3. This you perform as a last resort. Nothing else is working.If the phone is not showing any activity, proceed with hard formatting , turn off your phone, hold the following buttons while pressing the power button. (the default code is 12345)

hard reset - hold the following buttons *, 3 (number button) and talk/green key. turn on the phone and do not release those buttons until you see the Nokia boot up screen. once you feel the phone power up you can let go off the power button while still holding all three buttons.

If these codes are not working the only thing for you to do is contact your Nokia Care Center/Service for assistance.

Access 2003 - Missing Menu Bar

RESTORE MISSING MENU BAR:-
* right click the Tool Bar and select 'Customize'
* select the Toolbars tab and then click on 'Properties'
* goto the 'Selected Toolbar' dropdown and look for 'Menu Bar'
* click 'Restore Defaults' and, Hey-Presto, just like magic the Menu Bar appears.

Me.Controls in WPF

Use the parent control children property.
below Main is my grid name which contains saveral controls (some of them are textboxes)

For Each Control As Control In Main.Children
If Control.GetType.ToString() = "System.Windows.Controls.TextBox" Then
Control.BorderBrush = Brushes.Gray
End If
Next