Log in to check your private messages

Visual Basic Forum for Visual Basic Programmers VB - Interactive Visual Basic Forum .NET Programming & Help


	Visual Basic Forum for Visual Basic Programmers VB Forum Index » Database & Reporting

Frequently Asked Database Questions

View previous topic :: View next topic

Author

Message

Avis
Junior Poster

Joined: 07 Oct 2003
Posts: 510
Location: India

Posted: Oct 8th, 2003 05:29 AM Post subject: Frequently Asked Database Questions

MSDN - ActiveX Data Objects 2.7 Start Page: http://msdn.microsoft.com/library/d....asp?frame=true Microsoft Universal Data Access: http://www.microsoft.com/data/ Microsoft Universal Data Access ADO: http://www.microsoft.com/data/ado/default.htm Microsoft Universal Data Access OLEDB: http://www.microsoft.com/data/oledb/default.htm Latest versions of MDAC and JET engine: http://www.microsoft.com/data/download.htm ADO Data Control Example http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adodc98/html/vbctladodatacontrolx.asp

Send private message

Send e-mail

Visit poster's website

Yahoo Messenger

MSN Messenger

ICQ Number

Avis
Junior Poster

Joined: 07 Oct 2003
Posts: 510
Location: India

Post

Posted: Feb 17th, 2004 08:08 AM Post subject:

Reply with quote

Simple SQL Command Format:

For Selecting:

Code:

SELECT columnName, columnName

     FROM tableName

     WHERE columnName = 'value'

For Inserting:

Code:

INSERT INTO tableName

     (columnName, IntegerColumnName)

     VALUES ('value', numericValue)

For Updating:

Code:

UPDATE tableName

     SET columnName = 'value'

     WHERE columnName = 'value'

For Deleting:

Code:

DELETE columnName

     FROM tableName

     WHERE columnName = 'value'

_________________
Code Snippets, Tutorials, Utilities, Controls

Low cost Web Hosting
Hosting starts at as low as $4 per year!

Always follow posting guidelines
Put your VB code in [vb ] your code [ /vb] tags!

Send private message

Send e-mail

Visit poster's website

Yahoo Messenger

MSN Messenger

ICQ Number

Avis
Junior Poster

Joined: 07 Oct 2003
Posts: 510
Location: India

Posted: Aug 12th, 2004 06:37 AM Post subject:

Hi! Also check this VERY Simple ADO Example! [link] Thanks! _________________ Code Snippets, Tutorials, Utilities, Controls Low cost Web Hosting Hosting starts at as low as $4 per year! Always follow posting guidelines Put your VB code in [vb ] your code [ /vb] tags!

Send private message

Send e-mail

Visit poster's website

Yahoo Messenger

MSN Messenger

ICQ Number

dougthomas
Moderator

Joined: 27 Jul 2005
Posts: 271
Location: Essex, UK

Posted: Aug 12th, 2005 04:54 AM Post subject:

Also, Everything you ever wanted to know about SQL Fundamental: [link] Intermediate: [link]

Send private message

Display posts from previous:

	Visual Basic Forum for Visual Basic Programmers VB Forum Index » Database & Reporting	All times are GMT - 5 Hours
Page 1 of 1

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Visual Basic Forum runs phpBB | Forum Template © iOptional
VB Resources | SSL | Visual Basic