Ans: A database that contains one or more rectangular tables.
Ans: Structured Query Language.
Ans: It extracts a subset of the data (some of the rows and some of the columns) of a table.
Ans: Select all of the columns.
SELECT Age FROM PersonData
    WHERE Name = 'Bob' OR Name = 'Robert'
SELECT Name FROM PersonData
    WHERE 13 <= Age AND Age <= 19
SELECT * FROM PersonData
    ORDER BY Age
Name | Gender | Age |
---|---|---|
Mary | F | 23 |
Robert | M | 31 |
Sally | F | 35 |
Jane | F | 28 |
Tony | M | 30 |
Alice | F | 41 |
Scott | M | 27 |
Larry | M | 49 |
Ans: See the PhoneBookDB Example.
Ans:
A provider is the software that obtains data from a database of a specified format, and translates the data into a form that VB.NET can use.
Ans:
OleDB, ODBC, Oracle, SQLServer. Other providers are also possible but do not automatically come shipped with VB.NET.
Ans:
Ans: Provider and dataset name.
Ans: It extracts a table of data from the connection in a form that can be copied into a dataset.
sc.CommandText = sqlString
Dim da As New OleDbDataAdapter
da.SelectCommand = sc
Ans: XML data in memory representing a table from a database extracted with a select statement.
Ans: A data binding is an object that associates a property of a control with a column of a table. When the current row in the table is changed, the corresponding property changes automatically.
Dim n as Integer = da.Fill(ds, tableName)
Me.BindingContext(ds, tableName).Position = n - 1
Ans: Method 1 uses wizards to set up the database objects and uses data bindings. Method 2 uses code to set up the database objects and uses data bindings. Method 3 uses code to set up the database objects and does not use data bindings.
Here is the table PersonData.
Name | Gender | Age |
---|---|---|
Mary | F | 23 |
Robert | M | 31 |
Sally | F | 35 |
Jane | F | 28 |
Tony | M | 30 |
Alice | F | 41 |
Scott | M | 27 |
Larry | M | 49 |
Ans: See the PersonsMethod2 example.
Ans: See the DieRolls (W) example.
Ans: See the SnakeEyes (W) example.
End Sub
b = New Button
b.Location = New Point(50, 50)
b.Size = New Size(60, 100)
b.Text = "Push Me"
Me.Controls.Add(b)
b.Show()