Introduction
SQL statements are used by Access, ADO, Oracle, Informix, and not suprisingly,
MS SQL server. In short, if you use databases, be it in VB, ASP, FoxPro, Access
or anything else, at some stage you will need to know SQL. SQL, or Structured
Query Language gives you complete control over databases, creating, deleting,
modifying, adding, reading, sorting, querying and much more beside.
In this tutorial, we will cover the basic statements letting you request, add,
modify and delete records, which are the commands you are most likely to use.
*** If you are using VB, ASP or Access, you can use the Execute method of a
Connection object to run a SQL command ***
-
Posted by zible on 24 Jan 2007
This seems simple, yet I can't find how you do this. I need to run a query in VB on a very simple database. There is the possibility that the query would be unsuccessfull, and if so I need to do ot...
-
Posted by darshan on 25 Apr 2005
you need to fire sql statement like this
select idno, name, email, return from [table_name] where [your_condition]
this will return record set lets say "rs" is object of recordset
then you will n...
-
Posted by Abzmoh2007 on 11 Mar 2004
Basically am trying to search a database by getting an input from the users selection on a list.
the list contains names of countries and when i click that search button, how can i get the result of...
-
Posted by NightChillz on 23 Dec 2003
hey, i see how i can fill a datagrid with data from an sql table, but i am having trouble figuring out how to do the exact opposite, take data from a datagrid and fill an sql table with it/overriding ...
-
Posted by tomoko on 26 Nov 2003
hi,
pls help as i'm new in asp. i'm developing the administrative part of a website for my project. i'm having trouble with the "updating data" part. for example, i have done the 'add staff' and "de...