SQL Tutorial

visit this website to learn sql query http://www.w3schools.com/sql/default.asp
and for java website pls visit http://www.jaypeeworldprogrammer.blogspot.com/
i hope you learn and be a problem solver

Select Statement in SQL

Select Statement - used to select data from a database.

syntax:
       to select all record in database.
           Select * from tableName 
     
      to select column in the database.
          Select Column1, Column2, Column3......
          from tableName

SQL - structured query language

What is SQL?

• SQL stands for Structured Query Language
• SQL lets you access and manipulate databases
• SQL is an ANSI (American National Standards Institute) standard

---

What Can SQL do?

• SQL can execute queries against a database
• SQL can retrieve data from a database
• SQL can insert records in a database
• SQL can update records in a database
• SQL can delete records from a database
• SQL can create new databases
• SQL can create new tables in a database
• SQL can create stored procedures in a database
• SQL can create views in a database
• SQL can set permissions on tables, procedures, and views

Compute Two Numbers and get the sum

This program is to compute two numbers and get the sum. see the solution below.

This is a interface of Simple Computation

This is a code for the button Compute

This is a code for button Close

Next day i will give another example in visual basic programming. learn and enjoy..

Controls in Visual Basic

Controls - used to create objects in visual basic form and also it used to create user interface.

this images is a toolbox in visual basic to create a user interface.

Objects - the name of a user interface element you create on visual basic form by using toolbox.

Property - a value or characteristics used by visual basic objects. it used to put a name, forecolor, font, etc.

Program that show a message in vb programming

This program will show a message using msgbox.
if the button "Show Message" click the program that will show a message "Welcome to vb programming .net".

if you click the button Show Message the code will appear. see the image below.

.This is a code in button Show Message. This message is using msgbox keyword of function.

This is a output of this program. if you click the button the program will appear another form that have a message "Welcome to vb programming"

VB Environment

The Integrated Development Environment when you launch VB2008 Express is shown in the diagram below.

The IDE consist of the following controls or panes:
1. Toolbox
2.Solution Explorer
3. Properties
4. Form
5. toolbars