Software Technology Tips

Background:

Visual Studio 2008 makes life very easy for a developer. We can have complete code blocks created automatically. This is at a very advanced level for VB.NET and is still evolving for C#.

More Details:

Right Click and select "Insert Snippet" from the context menu [Or] use Ctrl + K + X and you will see a menu which lists all available options which are neatly grouped.

Just for a sample, I used the insert Snippet to create a code block to "Call the ExecuteReader Method of a SQLCommand" - the following lines were produced automatically:

         Dim reader As SqlDataReader

        Dim previousConnectionState As ConnectionState = conn.State

        Try

            If conn.State = ConnectionState.Closed Then

                conn.Open()

            End If

            reader = cmd.ExecuteReader()

            Using reader

                While reader.Read

                    ' Process SprocResults datareader here.

                    Console.WriteLine(reader.GetValue(0))

                End While

            End Using

        Finally

            If previousConnectionState = ConnectionState.Closed Then

                conn.Close()

            End If

        End Try

Some available snippets are listed below:

For C# Code Behind Files

C#:

if, Region, Checked, Class, Else, Enum, for, foreach, if, indexer, try, while, Etc.

Workflow:

DependencyProperty Event handler & property.

For VB.NET Code Behind Files

This is a programmer's delight. The list is very exhaustive. Some samples below:

Code patterns like if, if else, try Catch, property.

Data - ADO.NET - Create a parameterized SELECT Command, Execturereader, Etc.

Data - LINQ - From..Select, From..Order By...Select, Etc.

Collections and Arrays, FileSystems, Math

Office Development

Connectivity, Crystal Reports, Security, Workflow

Smart Devices

Windows Forms – Drawing, Etc

Logging

WPF

The list is almost endless. See it to believe it...

Statutory Warning!

The use of this feature may lead to code that is NOT in synch with the coding standard on naming conventions of your project/team. So take care of this point.

Happy programming!