[AccessD] VB.net reference books - experiences + SQL Server List

MartyConnelly martyconnelly at shaw.ca
Fri Apr 21 14:26:50 CDT 2006


Since you are looking for code snippets here are some hints to insert 
and  find them
using the Tab key and Code Snippet Picker in Vb.Net

Here is a short excerpt of an article taken from a freebie newsletter I 
got today from
http://www.sqlmag.com
The actual url for this article won't be up for two weeks.
You might want to look at his past articles.

1. ==== Developer .NET Perspectives ====
   by Bill Sheldon, bills at interknowlogy.com

Write Code Without Having to Type It
   A lot of the code that developers write follows common patterns. For
example, when you create a new property, you follow four steps:
   1. Declare a private variable.
   2. Declare the public property with a public name of the same type.
   3. Declare the Set logic, which sets the private variable to the 
parameter
value.
   4. Declare the Get logic, which returns the private variable's value.

   These four steps are common to every property you want to place in a
class. Manually typing all that information is not only repetitive but also
time consuming and error prone (mainly typing errors).
   Visual Studio 2005 lets you avoid all that hassle. Its new code snippet
feature lets you include code without typing it. For example, to include 
code
that creates a property, you simply type "prop" if you're using Visual 
C# or
"property" if you're using Visual Basic (VB) 2005, then press the Tab 
key. In
your source code, you'll find a template that includes all the generic code
you would normally type. The sections that you need to edit in your new
property declaration (e.g., variable name, property name, type) are all
highlighted. After you edit the contents of a highlighted section, you 
press
the Tab key to go to the next section. The changes are reflected across the
entire declaration for consistency. This constitutes an important 
difference
between using this feature and uploading stock code. With this feature,
you're literally pulling in a code template with active tags that 
specify the
initial customizable properties in that template.
   Most all the keywords in VB 2005 or Visual C# have been associated 
with a
code snippet. Can't remember the exact syntax of the For loop? No worries.
Type "For", press the Tab key, and--poof--the necessary code appears. Can't
remember the keyword you need to use? No problem. Right-click somewhere in
your edit window and select Insert Snippet. Visual Studio 2005 first 
inserts
a placeholder in the location where you want to include a snippet, then
provides a list of snippet categories in the Code Snippet Picker.
   Visual Studio 2005's code snippet feature goes well beyond just 
providing
templates for common language elements. Templates are also provided for
common tasks, such as pinging a remote computer or connecting to a 
database.
In addition, a template contains more than just source code. The template
also includes additional information, such as the snippet's author, the
namespaces that need to be imported (if applicable), a display title,
keywords the user needs to edit, and which keyword should be edited first.
For general information about code snippets, you can check out the 
Visual C#
help files at http://lists.sqlmag.com/t?ctl=27C2F:7E311 .
   The good news is that Visual Studio 2005 shipped with hundreds of code
snippets. The bad news is that the snippets are, as you might expect,
language specific and therefore not interchangeable. For example, some 
of the
VB 2005 snippets leverage the "My" namespace, which doesn't exist in Visual
C#.
   The code snippets have their own schema, which is documented at
http://lists.sqlmag.com/t?ctl=27C34:7E311 . As a result,
you can create your own custom snippets. Step by step instructions for 
doing
so are available at http://lists.sqlmag.com/t?ctl=27C35:7E311 .
   Snippet files are XML files. So, to create snippets, you must edit an 
XML
file, which isn't much fun. Fortunately, if you use VB 2005, there's a GUI
called the Visual Basic Snippet Editor that you can use. This free 
editor is
currently in the release candidate (RC) stage. For more information, visit
the Microsoft Developer Network (MSDN) Web page at
http://lists.sqlmag.com/t?ctl=27C28:7E311 . Or for the
most recent version, bypass MSDN and look in the GotDotNet Workspace at
http://lists.sqlmag.com/t?ctl=27C20:7E311 .

Kath Pelletti wrote:

>I thought it'd be a lot more than $5......sounds like a bargain to me. I've ordered the CD on developing apps with vb.net and I'll report back! I am very slowly getting the hang of vb.net but it is such a huge learning curve.
>
>Today I was ecstatic to finally have some reliable code to bind data to a datagridview, and bind data to a combo box. I then wasted about 4 hours on trying to get my single column combo to have multiple columns (and I'm not there yet!) - such simple things which are now so difficult until I learn it all again. Sigh....
>
>Thanks Gustav
>Kath
>  ----- Original Message ----- 
>  From: Gustav Brock 
>  To: accessd at databaseadvisors.com 
>  Sent: Thursday, April 20, 2006 7:34 PM
>  Subject: Re: [AccessD] VB.net reference books - experiences + SQL Server List
>
>
>  Hi Kath
>
>  Follow the link to International Customers:
>
>  http://www.appdev.com/demofamily.asp?catalog%5Fname=AppDevCatalog&category%5Fname=ALLDemo
>
>  It looks like they'll charge you USD 5.00 for posting outside the US.
>
>  /gustav
>
>  >>> kp at sdsonline.net 20-04-2006 01:01 >>>
>  Thanks Gustav - I followed the link but the gotcha seems to be US addresses only,
>  Kath
>
>    ----- Original Message ----- 
>    From: Gustav Brock 
>    To: accessd at databaseadvisors.com 
>    Sent: Thursday, April 20, 2006 1:51 AM
>    Subject: Re: [AccessD] VB.net reference books - experiences + SQL Server List
>
>
>    Hi Kath
>
>    Just noticed this, though not a book:
>
>      http://www.appdev.com/promo/freecd.asp?PC=RN00349 
>
>    I have no idea of the quality of that stuff.
>
>    /gustav
>
>    >>> kp at sdsonline.net 13-04-2006 01:39:49 >>>
>    (Cross posted to SQl Server and AccessD normal list)
>
>    I have been learning SQL Server 2005 and vb.net this year......I have found Mike Gunderloy's book "Mastering SQL Server 2005" an absolute god send. I would highly recommend this one to anyone going through this learning curve....
>
>    But the book I bought for learning vb.net is not so good - "Visual Basic 2005 - Programmer's reference' by Rod Stephens. It's not too bad - very much like reading the MS help screens - but I am looking for a book which will step me through it - a la Mike's style. Any recommendations?
>
>    (I know O'Reilly's are good but I am told by my colleague here that that it is more of a reference book.)
>
>    (While I am posting - it's very quiet on our SQL list for now - is there another list anyone has been using which they would recommend?
>
>    ______________________________________
>    Kath Pelletti
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list