
Use and Share Code Snippets #15
Chapter 2, Master the Editor
|
71
HACK
You can then select the “Create a DataTable with columns and a primary
key” snippet, and the following code will be inserted into the class:
Private Sub CreateTable( )
Dim IDColumn As New DataColumn("ID")
IDColumn.DataType = GetType(Integer)
IDColumn.AutoIncrement = True
Dim FNameColumn As New DataColumn("FirstName")
FNameColumn.DataType = GetType(String)
Dim LNameColumn As New DataColumn("LastName")
LNameColumn.DataType = GetType(String)
Dim EmployeeTable As New DataTable("Employees")
EmployeeTable.Columns.Add(IDColumn)
EmployeeTable.Columns.Add(FNameColumn)
EmployeeTable.Columns.Add(LNameColumn)
EmployeeTable.Constraints.Add("Key1", IDColumn, True)
End Sub
Of course, this code probably does not do exactly what you want it to do,
but it gives you a great start to work from. Code Snippets are a great way to
incorporate examples into your everyday coding, but wouldn’t it be great if
you could build your own library of code snippets?
Add Your Own Code Snippets
A large number of code snippets are already loaded into Visual Studio, but
you can also add your own. This could be very useful if you want to create
snippets for common pieces of code you use or code that is specific to your
project or architecture. You will also be able to download and add code
snippets from community sites as well; I have a feeling that it will become ...