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

Kath Pelletti kp at sdsonline.net
Sun Apr 23 18:20:53 CDT 2006


Wow - I am still absorbing all that Marty - I normally wouldn't hit tab so I guess I haven't hit on that feature. It looks great. 

Kath
  ----- Original Message ----- 
  From: MartyConnelly 
  To: Access Developers discussion and problem solving 
  Sent: Saturday, April 22, 2006 5:26 AM
  Subject: Re: [AccessD] VB.net reference books - experiences + SQL Server List


  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



  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com



More information about the AccessD mailing list