Visual Basic Newsletter #2
| |
Visual Basic Newsletter #2 - 04-SEP-2001
INDEX
1. A FEW WORDS FROM THE EDITOR
2. READING AND WRITING IN THE REGISTRY WITH VBSCRIPT
3. SQL TUTORIALS
4. LINKS
########################################################################
1. A FEW WORDS FROM THE EDITOR
In this second issue you can find a list of some SQL tutorials you can
find in the net, and I'm glad to introduce the article "Reading and
Writing in the Registry with VBScript" by Mauricio Lorenzón.
I'm happy to announce that this newsletter has reached 650 subscribers
in total. The newsletter can grow in contents and subscribers ONLY
thanks to your collaboration. If you are the author of any material you
consider it's worth publishing, please submit it to us. Links to
interesting material in the web are also most welcome. Please forward
this newsletter to colleagues and friends who might be interested in
this publication, or send them the link:
http://www.latiumsoftware.com/en/visual-basic/
I'd like to invite you to join our Visual Basic forum at Yahoo! Groups
where you can exchange experience with other VB programmers:
VISUAL BASIC PROGRAMMING (FORUM / MAILING LIST)
http://groups.yahoo.com/group/vbasic-en
vbasic-en-subscribe@yahoogroups.com
You can change your subscription options to the forum, for example to
prevent messages from being converted to HTML or to avoid receiving the
messages in your email (you'd still be able to see the messages at the
web site).
Yours,
Ernesto De Spirito
eds2004 @ latiumsoftware.com
########################################################################
2. READING AND WRITING IN THE REGISTRY WITH VBSCRIPT
By Mauricio Lorenzón
The following is an example of VBScript code that allows you to read and
write data in the registry. In this case it accesses the key where the
proxy used by the browser is set, but the example is usefull for any
key.
File ProxySet.wsf:
<package>
<job id="SetProxy">
<script language="VBScript">
Set WshShell = WScript.CreateObject("WScript.Shell")
nEnabled = WshShell.RegRead("HKCU\Software\Microsoft\Windows\" & _
"CurrentVersion\Internet Settings\ProxyEnable")
if nEnabled = 1 then
sProxy = WshShell.RegRead("HKCU\Software\Microsoft\Windows\" & _
"CurrentVersion\Internet Settings\ProxyServer")
sEnabled = "enabled." & chr(13) & chr(13) & "Proxy: " & sProxy
WshShell.RegWrite "HKCU\Software\Microsoft\Windows\" & _
"CurrentVersion\Internet Settings\ProxyEnable", 0,"REG_DWORD"
else
sEnabled = "disabled."
WshShell.RegWrite "HKCU\Software\Microsoft\Windows\" & _
"CurrentVersion\Internet Settings\ProxyEnable", 1,"REG_DWORD"
end if
MsgBox "The use of the proxy is " & sEnabled
</script>
</job>
</package>
Note: Runs only for WSH 5.0+ and it's meant for Windows 2000 (can't run
with NT4's WSH), but might work on Windows 98/Me.
WARNING: This script changes your proxy setting. Make sure to run it an
even number of times to restore the original setting!
------------------
Copyright (c) 2001 Mauricio Lorenzón
Systems Engineer from the UTN Córdoba - Argentina
mauriciolorenzonNOSPAM@hotmail.com
########################################################################
3. SQL TUTORIALS
Nowadays it's indispensable for any programmer to know SQL. If you know
little or nothing of SQL, here are some tutorials to get you started:
* SQL Course
Interactive/On-line SQL Tutorial with SQL Interpreter & live practice
database
http://www.sqlcourse.com/
http://sqlcourse2.com/
* Introduction to Structured Query Language
An introduction to ANSI SQL
http://w3.one.net/~jhoffman/sqltut.htm
* Oracle/SQL Tutorial
Detailed introduction to the SQL query language and the Oracle
Relational Database Management System
http://www.db.cs.ucdavis.edu/teaching/sqltutorial/
* SQL tutorial by examples
Examples if Oracle SQL taken from practical real life situations
http://www.dragonlee.co.uk/frame.html
* SQL School
ANSI SQL tutorial
http://www.w3schools.com/sql/
* SQL Tutorial and Tips
http://www.really-fine.com/SQL_select.html
* Informix Guide to SQL: Tutorial
Instructions for using basic and advanced Structured Query Language
(SQL) as well as for designing and managing your database.
www.dbcenter.cise.ufl.edu/triggerman/InfoShelf/sqlt/intro.fm1.html
* SQL FAQ
http://epoch.cs.berkeley.edu:8000/sequoia/dba/montage/FAQ/SQL_TOC.html
* SQL for Web Nerds
http://www.arsdigita.com/books/sql/
* SQL - Structured Query Language
A complete self paced tutorial which takes you through all the
important elements of SQL up to and including sub-queries and
correlation.
www.cs.unibo.it/~ciaccia/COURSES/RESOURCES/SQLTutorial/sqlcont.htm
* SQL Tutorial
This SQL tutorial aims to teach beginners the building blocks of SQL.
http://www.1keydata.com/sql/sql.html
########################################################################
4. LINKS
* VB Information Center
Gary Beene's Visual Basic Information Center
http://www.vbinformation.com/
* 15 Seconds
Free resource for developers working with Microsoft Internet
Solutions.
http://www.15seconds.com/
* DotNetJunkies.com - Putting the dot in .NET
Microsoft will be releasing ASP.NET soon. Take advantage of the time
you have a learn about the Next Generation of Active Server Pages now.
http://www.aspnextgen.com/
########################################################################
This newsletter is provided "AS IS" without warranty of any kind. Its
use implies the acceptance of our licensing terms and disclaimer of
warranty you can read at http://www.latiumsoftware.com/en/legal.php
where you will also find a note about legal trademarks. Articles are
copyright of their respective authors and they are reproduced here with
their permission. You can redistribute this newsletter as long as you do
it in full (including copyright notices), without changes and gratis.
------------------------------------------------------------------------
Latium Software http://www.latiumsoftware.com/en/index.php
------------------------------------------------------------------------
Copyright (c) 2001 Ernesto De Spirito. All rights reserved.
------------------------------------------------------------------------
|
Errors? Omissions? Comments? Please contact us!
