VS.NET 2002/VB
I would like to begin learning about DB programming, and I'm not quite sure where to start.
Before I add MSSQL 2000 to my hosting plan, the question that comes to mind is, how do I develop a
DB app on my local machine? Do I have to buy MSSQL 2000 and install it on my PC? That is way too
much money for me (and, I would think, most people), so I hope there is an alternative -- maybe
using Access in the dev environment, and then transferring the info to the MSSQL DB on the server?
If so, does that same code used with Access work with MSSQL?
I guess what I'm looking for is an overview of how to get started with all this when I will be using
MSSQL 2000 at my site. Also, I would like any recommendations as to reading material, i.e. books,
Web sites, etc. that might help get me going.
Thanks,
George
3  1347 
If you are developing Web Form application or Web Services (as opposed to
Winforms, console apps, or services) then I highly recommend WebMatrix from
ASP.NET.
This app was initially developed for inhouse use at MS and then a whole
community was born (hence the word Matrix) out of this effort.
Get this, in 1.3MB, that's right the size of a Floppy disk, they include an
IDE (scaled down Visual Studio.Net), a DB engine (SQL Server Data Engine)
and a Web Server (scaled down IIS).
And it's FREE.
otherwise you can the SQL Server Data Engine for dev only http://www.microsoft.com/sql/msde/do...s/download.asp
"George" <------@----.---> wrote in message
news:9H******** ***********@bgt nsc05-news.ops.worldn et.att.net... VS.NET 2002/VB
I would like to begin learning about DB programming, and I'm not quite
sure where to start.
Before I add MSSQL 2000 to my hosting plan, the question that comes to
mind is, how do I develop a DB app on my local machine? Do I have to buy MSSQL 2000 and install it on
my PC? That is way too much money for me (and, I would think, most people), so I hope there is an
alternative -- maybe using Access in the dev environment, and then transferring the info to the
MSSQL DB on the server? If so, does that same code used with Access work with MSSQL?
I guess what I'm looking for is an overview of how to get started with all
this when I will be using MSSQL 2000 at my site. Also, I would like any recommendations as to
reading material, i.e. books, Web sites, etc. that might help get me going.
Thanks,
George
You can either use Access or MSDE, both of which do not require any
licensing to use, and both of which can be upgraded to SQL Server. I would
recommend using MSDE, so that you can use real Stored Procedures.
The best reading material I can recommend is also free from Microsoft, and
it is the .Net SDK. You can download it from: http://www.microsoft.com/downloads/d...displaylang=en
--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"George" <------@----.---> wrote in message
news:9H******** ***********@bgt nsc05-news.ops.worldn et.att.net... VS.NET 2002/VB
I would like to begin learning about DB programming, and I'm not quite
sure where to start.
Before I add MSSQL 2000 to my hosting plan, the question that comes to
mind is, how do I develop a DB app on my local machine? Do I have to buy MSSQL 2000 and install it on
my PC? That is way too much money for me (and, I would think, most people), so I hope there is an
alternative -- maybe using Access in the dev environment, and then transferring the info to the
MSSQL DB on the server? If so, does that same code used with Access work with MSSQL?
I guess what I'm looking for is an overview of how to get started with all
this when I will be using MSSQL 2000 at my site. Also, I would like any recommendations as to
reading material, i.e. books, Web sites, etc. that might help get me going.
Thanks,
George
Terry and Kevin,
Thanks for the info, that is exactly what I was looking for!
George
"George" <------@----.---> wrote in message
news:9H******** ***********@bgt nsc05-news.ops.worldn et.att.net... VS.NET 2002/VB
I would like to begin learning about DB programming, and I'm not quite sure where to start.
Before I add MSSQL 2000 to my hosting plan, the question that comes to mind is, how do I develop a
DB app on my local machine? Do I have to buy MSSQL 2000 and install it on my PC? That is way too
much money for me (and, I would think, most people), so I hope there is an alternative -- maybe
using Access in the dev environment, and then transferring the info to the MSSQL DB on the server?
If so, does that same code used with Access work with MSSQL?
I guess what I'm looking for is an overview of how to get started with all this when I will be
using MSSQL 2000 at my site. Also, I would like any recommendations as to reading material, i.e. books,
Web sites, etc. that might help get me going.
Thanks,
George
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: PHPkemon |
last post by:
Hi there,
A few weeks ago I made a post and got an answer which seemed very logical.
Here's part of the post:
PHPkemon wrote:
> I think I've figured out how to do the main things like storing products
in
|
by: Bibby |
last post by:
Hi, I'm interested in getting started in the programming world. I've dabbled
in C, C++ and VB6. Which would be the best language to focus my attention to
regarding the following considerations:
Hireability
Portability
Flexibility
The likely candidates seem to be Java, VB.Net, C, C++, C#.
|
by: goldbond_8 |
last post by:
I am looking to learn VB.net. I have been programming in VB6 for about
3 years but have not done much Object Oriented Programming. I know
VB.Net is much different from VB6, so my question is, what would be the
best way to get started? Would it be better to learn some of the
principles of OOP before diving into VB.Net? Could anyone recommend
any good books or web sites to help me get started.
Thanks
|
by: Jack Duijf |
last post by:
Hello,
I am looking for a person in The Netherlands that is willing to help me
getting started with Vb.net. Please send a message to jack@aicn.nl if you can
help me getting started with the Microsoft Developement Enviroment.
Thanks,
|
by: Sheldon Rabin |
last post by:
Thanks in advance to all of you,
Your recommendations:
What kind of instruction and software are needed to learn and do useful
programming using C+, C++ ?
I would like to access and use the windows graphics environment.
SRabin,
| | |
by: nmeyer |
last post by:
Hi, I'm trying to scope a MS Access project and was looking for some
advise. Will VB programming/ experience be required to build out
something like the Northwinds sample database?
We'd like a DB system to manage member records, their administrators
and to query for random mailings/results. Does Access 07 have easy
ways to generate individual or group mailings? Will RAND and SELECT
WHERE SQL statements be enough for random sampling or...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
