Faqts : Business : Programming : Shopping For You : Visual basic : Visual basic .NET

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

6 of 19 people (32%) answered Yes
Recently 2 of 10 people (20%) answered Yes

Entry

Visual Basic.NET: Database: SQL: Query: Create: How to create an SQL query?

Dec 31st, 2003 15:01
Knud van Eeden,


----------------------------------------------------------------------
--- Knud van Eeden --- 23 December 2003 - 00:12 am -------------------

Visual Basic.NET: Database: SQL: Query: Create: How to create an SQL 
query?

---

Method: using the 'Command text' property

---

Steps: Overview:

 1. -Create a form

     1. Start Visual Studio

     2. Start a new project

 1. -Open the 'Toolbox' window

     1. -select from menu option 'View'

     2. -select from list 'Toolbox'

 2. -click button 'Data'

 3. -double click on 'SqlCommand' in the
     list

 4. -This will place this control on the
     form.

 5. -You can then e.g. fill in your SQL
     query in the property 'Command text'
     (e.g. in the 'Property window')

----------------------------------------------------------------------