Folder Tree in Windows 7

01 - Press Alt in Windows Explorer to view menu bar (by default is not appearing)
02 - Inside Tools->Folder Options ...->General

        Navigation Pane        Check : Show All folders        Check : Automatically expand to current folder

Saving changes is not permitted - SQL Server

In MS SQL Server Management Studio


Tools
Options
Designers
Table and Database Designers
Uncheck -> Prevent saving changes ...

Difference between Debug & Release

The major difference between debug & release build is, Debug builds disable JIT optimization which can have a significant impact on performance,
In a debug build the complete symbolic debug information is emitted to help while debugging applications and also the code optimization is not taken into account. 


While in release build the symbolic debug info is not emitted and the code execution is optimized.
Also, because the symbolic info is not emitted in a release build, the size of the final executable is lesser than a debug executable.


In terms of execution speed, a release executable will execute faster for sure, but not always will this different be significant.


Most people ship release builds since they're faster.

Numeric Textbox allows only single .

Numeric Textbox

Allows digits only, only single ., limited decimal places

Private Sub txtnProQty_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtnProQty.KeyPress, txtnumProAmount.KeyPress, txtnumProCurRate.KeyPress, txtnSerQty.KeyPress, txtnumSerAmount.KeyPress, txtnumSerCurRate.KeyPress

Dim nKey As Integer = Asc(e.KeyChar)

Dim tBox As TextBox = CType(sender, TextBox)

Dim nMaxDecPlaces As Integer = 3

If nKey = 8 Then 'Backspace

e.Handled = False

ElseIf (nKey >= 48 And nKey <= 57) Or nKey = 46 Then

If nKey = 46 AndAlso tBox.Text.Contains(".") Then

e.Handled = True

Else

If (tBox.Text.IndexOf(".") > -1) And ((tBox.Text.Length - 1) - tBox.Text.IndexOf(".")) = nMaxDecPlaces Then

e.Handled = True

Else

e.Handled = False

End If

End If

Else

e.Handled = True

End If

End Sub




Private Sub txtnProQty_KeyUp(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles txtnProQty.KeyUp, txtnumProAmount.KeyUp, txtnumProCurRate.KeyUp, txtnSerQty.KeyUp, txtnumSerAmount.KeyUp, txtnumSerCurRate.KeyUp

Dim tBox As TextBox = CType(sender, TextBox)

If tBox.Text = "" Then

tBox.Text = "0"

tBox.SelectAll()

End If

End Sub

VS2010 version differences

SQL Server Data Types and Their .NET Framework Equivalents

SQL Server data type	CLR data type (SQL Server)	CLR data type (.NET Framework)
varbinary	SqlBytes, SqlBinary	Byte[]
binary	SqlBytes, SqlBinary	Byte[]
varbinary(1), binary(1)	SqlBytes, SqlBinary	byte, Byte[]
image	None	None
varchar	None	None
char	None	None
nvarchar(1), nchar(1)	SqlChars, SqlString	Char, String, Char[]
nvarchar	SqlChars, SqlStringSQLChars is a better match for data transfer and access, and SQLString is a better match for performing String operations.	String, Char[]
nchar	SqlChars, SqlString	String, Char[]
text	None	None
ntext	None	None
uniqueidentifier	SqlGuid	Guid
rowversion	None	Byte[]
bit	SqlBoolean	Boolean
tinyint	SqlByte	Byte
smallint	SqlInt16	Int16
int	SqlInt32	Int32
bigint	SqlInt64	Int64
smallmoney	SqlMoney	Decimal
money	SqlMoney	Decimal
numeric	SqlDecimal	Decimal
decimal	SqlDecimal	Decimal
real	SqlSingle	Single
float	SqlDouble	Double
smalldatetime	SqlDateTime	DateTime
datetime	SqlDateTime	DateTime
sql_variant	None	Object
User-defined type(UDT)	None	Same class that is bound to the user-defined type in the same assembly or a dependent assembly.
table	None	None
cursor	None	None
timestamp	None	None
xml	SqlXml	None

WPF Right-align GridViewColumn (For Arabic)

<listview.resources>

<datatemplate key="RightTemplate">

<textblock horizontalalignment="Right" textalignment="Right" text="{Binding Path=MyColumn}" />

</datatemplate>

</listview.resources>

<gridviewcolumn width="Auto" header="Grid Column Header" celltemplate="{StaticResource RightTemplate}" />