SQL Project

Hi Guys,

I've been teaching myself, very slowly, the whole webdesign thing using VWD as
my prefered tool. You'll be happy to here I can now design, build, and deploy
sites, and I think VWD is a fantastic tool for doing so. My next challenge is to
integrate dbs onto sites, the kind of thing where people enter data onto the db
via the site, and others can access the data in a similar fashion - you know,
FaceBook, Bebo, YouTube, dating sites etc. The problem is that SQL and dbs in
general are my bette noir - I'm terrified of them. I've got the VWD manuals
(Idiots etc), and I've done the VWD/SQL video training, but what I really need
is a good, ground up, comprehensive - but idiot proof (for I am that person)
project/s that will take me through designing and integrating SQL dbs into web
projects. I'm pretty sure that doing so, just like designing websites, is pretty
simple once you know it, but my fear of such coupled with my inability to find
the perfect resource for doing so have brought me to a standstill. If anyone can
point me in the direction of a project or simple guide that will lead me to my
goal I'd be very gratefull.

Michael.

I see you doing quite a bit of code behind. I'm guessing you are at the point
where I was not too long ago--being able to put controls on the front page, and
maybe using some built-in functionality such as insert, delete, etc.

Now you've reached the point where want to use programming operations.  That's
where the code behind comes into play.

You mention being terrified of SQL.  No problem--I have a plan.  You also state
that you feel after using it a while, it will become second-nature.  Yes.

How to do it?

An SQL box.  Someone like myself can give you five lines of SQL, you paste it
into the box, press the button, and presto--you have a new table; you've added
data to your table; you've deleted all records where column B has a value less
than 5, etc.

I'm going to take a gamble that you work with VB, and I'll post some stuff here.
 If you wake up tomorrow (right now), find this, and tell me "No, I work
with C#", no problem.  I'm actually a C# person but I've done some recent
work with VB (just in case I need it later, you never know...)

CREATE TABLE Cities
(id int IDENTITY(1,1) PRIMARY KEY,
City nchar(20) NOT NULL,
Country nchar(20) NOT NULL,
Latitude intNOT NULL,
Population int)

INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Oslo','Norway','59','560000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Stockholm','Sweden','59','800000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Moscow','Russia','55','8300000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Berlin','Germany','52','3400000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Amsterdam','Netherlands','52','730000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('London','United Kingdom','51','7000000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES ('Praque','Czech
Republic','50','1200000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Paris','France','48','2200000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Vienna','Austria','48','1500000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Munich','Germany','48','740000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Budapest','Hungary','47','1800000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Zurich','Switzerland','47','380000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Montreal','Canada','45','1600000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Florence','Italy','43','370000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Toronto','Canada','43','2500000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Marseille','France','43','1300000')	
INSERT INTO Cities (City, Country, Latitude, Population) VALUES
('Boston','USA','42','4300000')	
INSERT INTO Cities (City, Country, Latitude) VALUES  ('Rome','Italy','41')	
INSERT INTO Cities (City, Country, Latitude) VALUES
('Instanbul','Turkey','41')	
INSERT INTO Cities (City, Country, Latitude) VALUES ('Denver','USA','39')	
INSERT INTO Cities (City, Country, Latitude) VALUES ('Athens','Greece','38')	
INSERT INTO Cities (City, Country, Latitude) VALUES ('Seoul','South
Korea','37')	
INSERT INTO Cities (City, Country, Latitude) VALUES ('Algiers','Algeria','36')	
INSERT INTO Cities (City, Country, Latitude) VALUES ('Tokyo','Japan','35')	
INSERT INTO Cities (City, Country, Latitude) VALUES ('Baghdad','Iraq','33')

This space is reserved to be an Index.  I see this thread growing to 20-30 posts
(maybe even a few more).  I look forward working with Michael, and expect a few
others may come here too, and for them, I'd like an index here to provide an
overview on what they can find that will help them.

-Larry