Visual Basic

Front 1

.Net framework is

Back 1

.Net class library

ADO.NET 4.0 - ActiveX Data Object

ASP.NET 4.0

MISL and CLR

Front 2

Insert tab in a string sequence

Back 2

vbTab

is a constant in VB that equivalents tab key

Front 3

string replacement code

Back 3

{0}

Dim myString - StringFromant("{0}!","Hello")

Front 4

format string as currency

Back 4

String.Format("{0:C}" , 23.35)

Front 5

Format a number as decimal value (0.00 and comas)

Format a phone number (123) 123-45678

Back 5

{0:N}

{0:(###) ###-####}

Front 6

Array in VB

Back 6

Dim numbers(0 to 4) As Integer

or

Dim numbers(4) As Integer

Front 7

Array of strings

Back 7

Dim names() As String {"AAA","BBB"}

Front 8

For Each

Back 8

Dim names() As String {"AAA","BBB"}

For Each name As String In names

Console.WriteLine(name)

Next

Front 9

function in VB

Back 9

Function name() as String

End Function

Front 10

procedure example

Back 10

Sub name()

End Sub

Front 11

IsNothing()

Back 11

checks for Null

Front 12

Dim dat As Date = #1/17/2012 9:30AM#

Dim city As String = "Chicago"

Dim temp As Integer = -16 Dim output As String =

String.Format("At {0} in {1}, the temperature was {2} degrees.", dat, city, temp) Console.WriteLine(output)

What is the output?

Back 12

At 1/17/2012 9:30:00 AM in Chicago, the temperature was -16 degrees.

Front 13

For Each item In temperatureInfo output = String.Format("Temperature at {0,8:t} on {0,9:d}: {1,5:N1}°F", _ item.Key, item.Value) Console.WriteLine(output)

Back 13

' Temperature at 2:00 PM on 6/1/2010: 87.5°F

' Temperature at 10:00 AM on 12/1/2010: 36.8°F

Front 14

write a code to open an .aspx (in shape of a pop up window) after clicking a LinkButton on another .ASPX web page(using VB)

Back 14

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs)

Dim queryString As String = "test.aspx"

Dim newWin As String = "window.open('" & queryString & "');"

ClientScript.RegisterStartupScript(Me.GetType(), "pop", newWin, True)

End Sub

Front 15

Get week number

Back 15

Format(Datepart(DateInterval.WeekOfYear, Now))

Front 16

Passing by value

Back 16

Sub NoChanges(ByVal N As Integer, ByVal S As Single)

' Receives arguments by value

N = N * 2 'Double both

S = S * 2 ' arguments

' When the calling routine regains control

' its two local variables will not be

' changed from their original values.

End Sub

Front 17

Passing by reference

Back 17

Sub Changes(N As Integer, S As Single)

' Receives arguments by reference

N = N * 2 ' Double both

S = S * 2 ' arguments

' When the calling routine regains control,

' its two local variables will now be twice

' as much as they were before calling this.

End Sub

Front 18

namespace

Back 18

Namespace Stefan

End Namespace

Front 19

The ____ exception type is used to catch all generic exceptions within a Try-Catch structure.

Answer

1. NullReferenceException
2. ArgumentNullException
3. OverflowException
4. SystemException

Back 19

4 SystemException

Front 20

To return multiple variables from a Function procedure, arguments passed ____ must be used.

Answer

1. ByVal
2. BySub
3. ByRef
4. ByArg

Back 20

3

Front 21

The ____ exception type occurs when a value exceeds its assigned data type.

Answer

NullReferenceException

ArgumentNullException

OverflowException

SystemException

Back 21

OverflowException

Front 22

The keyword ____ is used in a Function procedure to return a single value.

Answer

SendVal

Return

ReturnVal

ReturnValue

Back 22

Return

Front 23

The ____ property allows you to change the generic graphic on the splash screen.

Answer

BackGround

BackImage

BackgroundImage

BackGroundPicture

Back 23

BackgroundImage

Front 24

The ____ Information dialog box contains values that include the program title, description, company, product, and copyright date.

Answer

Assembly

ActiveX

Activity

Argument

Back 24

Assembly

Front 25

A For...Next loop with a beginning value of 1, an ending value of 25, and a Step value of 3 will execute ____ times.

Answer

3

8

9

25

Back 25

9

Front 26

If ____ appears as the last line of a loop, the loop is a bottom-controlled Do loop that will execute as long as a condition remains true.

Answer

Loop While

Do While

Loop Until

Do Until

Back 26

Loop While

Front 27

The ____ follows the keyword For in a For...Next loop.

Answer

keyword Next

keyword Step

keyword To

control variable

Back 27

control variable

Front 28

What will be the value of the variable intTotalCount when the following code is executed?

For intOuterCount = 1 to 5

For intInnerCount = 1 to 4

intTotalCount +=1

Next

Next

Answer

4

5

9

20

Back 28

20

Front 29

The ____ property of a ListBox object identifies which item in the ListBox was selected.

Answer

Item

ItemSelected

Selected

SelectedItem

Back 29

SelectedItem

Front 30

Which line of code will add the value “East” to a ListBox object named lstDirections?

Answer

1. lstDirections.Add(“East”)
2. lstDirections.Items.Add(“East”)
3. lstDirections.AddValue(“East”)
4. lstDirections.Items.AddValue(“East”)

Back 30

2

Front 31

A ____ operator allows you to perform arithmetic operations with a variable and store the results back to that variable.

Answer

logical

rational

compressed

compound

Back 31

Compound

Front 32

To remove all objects from a ListBox object, the ____ method is used.

Answer

Clear

Items.Clear

Empty

Items.Empty

Back 32

Clear

Front 33

The ____ property of a ComboBox returns an integer value corresponding to the position of the selected item in the list.

Answer

Index

CurrentIndex

SelectedIndex

SelectedInteger

Back 33

SelectedIndex

Front 34

The ____ object acts as a container for Visual Basic objects in a Document Actions task pane.

Answer

Pane

ActionsPane

Actions

PaneControl

Back 34

ActionsPane

Front 35

The ____ object allows users either to select an existing value or enter a new value.

Answer

ComboBox

DropDownBox

DropDownComboBox

ListBox

Back 35

ComboBox

Front 36

The ____ property of a Button object contains the name of the button.

Answer

ID

ButtonTitle

Name

ButtonCaption

Back 36

ID

Front 37

The ____ object verifies that the object on a Web form contains data.

Answer

EmptyObject

ObjectNull

RequiredFieldValidator

ObjectRequired

Back 37

RequiredFieldValidato

Front 38

The ____ procedure converts a string value to uppercase letters.

Answer

ToUpper

ToUpperCase

ConvertToUpper

UpperCaseConvertf

Back 38

ToUpper

Front 39

The ____ procedure of the String class is used to remove spaces from the string.

Answer

TrimSpaces

TrimEnds

Trim

TrimEndSpaces

Back 39

Trim

Front 40

Writing to a Text File

Back 40

Dim file As System.IO.StreamWriterfile = My.Computer.FileSystem.OpenTextFileWriter("c:\test.txt", True)file.WriteLine("Here is the first string.")file.Close()

Front 41

Reading a file

Back 41

DIM objReader As IO.StreamReader

if IO.File.Exist("e:\inventory.txt") = True Then

objReader = IO.File.OpenText("e:\inventory.txt")

Else

MsgBox0"The file is not available. Restart the program when the file is available",,"Error")

Me.Close()

End If

Front 42

Creating a two-dimensional array

Back 42

Dim intVal(2,3) As Integer

Front 43

Declare and init an array

Back 43

Dim intCalories() As Integer = { 35, 45, 75, 119}

Front 44

General format for BinarySerach procedure

Back 44

intValue = Array.BinarySearch(arrayname, value)

Front 45

General Format for Sort procedure

Back 45

Dim intAges() as Integer = {16,64,41,8,19}

Array.Sort(intAges)

Front 46

Passing an array

An array cna be passed as an argument to a Sub procedure or a Function procedure

Back 46

...

ComputerDisplayTtl(decCommissionAmounts)

...

Private Sub ComputeDisplayTtl(ByVal decValueOfCommission() As Decimal)

Dim decAmount as Decimal

Dim decTotal as Decimal = 0

For Each decAmount in decValueOfCommission

decTotal += decAmount

Next

lblTotalCommission.Text = "The Total Commission is " _ & decTotal.ToString("C")

End Sub

Front 47

For each General format

Back 47

For Each Control Variable Name in ArrayName

' CODE

Next

Front 48

Reinitializing an Array

Back 48

Every array in VB is considered dynamic. When you change the number of elements in an existing array, you re-dimension it.

Dim strEmployee(50) As String

' Later in code

ReDim strEmployees(65)

When you ReDim statement all the data contained in the array is lost when the array is re-dimensioned. if you want to preserve the existing data, you can used the keyword Preserver.

Dim strEmployee(50) As String

' Later in the code

RedDim Preserver strEmployee(65)

Front 49

Upper-Bound Index Constant

Back 49

An array can use a constant value representing the upper-bound inded of the array.

Const intUpperBound As Integer = 40

Dim strFirstNames(intUppeerBound) As String

Front 50

Init an Array with Default Values

Back 50

When you initialize an array, if you do not assign values immediately, each element is assigned a default value

All numeric data type = 0

String data type = Null

Boolean data type = False

Front 51

Multiple catch blocks def

Back 51

Multiple Catch blocks can be defined for a single Try block where each Catch block will catch a particular class of exception

Front 52

Exception thrown when a variable that has value is passed to a procedure

Back 52

ArgumentNullException

Dim strTemr as String

lstDisplay.Items.Add(strTerm)

Front 53

Exception thrown when a value is divided by zero

Back 53

DividedByZeroException

intResult = intNum / 0

Front 54

Exception thrown when a variable is converted to another type that is not possible

Back 54

FormatException

strTerm = "Code"

intValue = Convert.ToInt32(strTerm)

Front 55

Exception thrown when a procedure is called when the result is not possible

Back 55

NullReferenceException

Dim strTerm as String

intValue = strTerm.Lenght

Front 56

Exception thrown a value exceeds its assigned data type

Back 56

OVerflowException

Dim intCost as Interger

intCost = 58 ^ 400000000000

Front 57

The generic SystemExceptions

Back 57

Generic

Catches all other exceptions

Front 58

General format for Try-Catch block

Back 58

Try

' Try block

Catch (filter for possible exceptions)

' Catch block

End Try

Front 59

By default, a class-level variable delared using the Dim statement has ______________ access

Back 59

private

Front 60

Function procedure call

Back 60

Private Function FunctionProcedureName() as DataType

' Line(s) of code

REturn VariableName

End Function

Front 61

Passing arguments by reference (ByRef)

Back 61

This is the second way in which to pass an argument from a calling procedure to a called sub procedure by reference

Front 62

Procedure call

Back 62

Private Sub ProcedureName()

' Lines of code

End Sub

Front 63

Event handler is executed when the user select the island location of the hour

Back 63

SelectedIndexChanged

Front 64

Bottom-Controlled Do Until Loop

Back 64

This Do Until loop checks the condition after the body of the loop is executed.

The loop continues until the condition becomes try

Do

' Loop Body

Loop Until condition

Front 65

Priming a loop

Back 65

Starting a loop with a preset value in the variable tested in the condition is called priming the loop

Front 66

Do Until Loops

Back 66

A Do Until loop can be both top-controlled and bottom-controlled. The top controlled loop is

Do Until condition

' Loop Body

Loop

Front 67

Bottom-Controlled Do While Loop

Back 67

Do

' Loop Body

Loop While condition

Do While loop where the condition is tested at the bottom of the loop.

Front 68

Top-controlled loop vs bottom-controlled loop

Back 68

Top-controlled loop - tests the condition before the loop is entered. The body of this type of loop might not be executed at all.

Bottom-controlled loop - tests the condition at the bottom of the loop, so the body of a bottom-controlled loop is executed at least once.

Front 69

For...Next loop

Back 69

For Control Variable = Beginning Number Value to Ending Numeric Value

' Body of the loop

Next

Front 70

General Format to Assign the Selected Item in a ListBox Object

Back 70

strVariableName = lstListBoxName.SelectedItem

Front 71

To clear the items in a ListBox object used

Back 71

lstListBoxName.Items.Clear()

Front 72

General format for adding an item to a ListBox obj

Back 72

Me.Controls.Add(listBox1)

Front 73

Site.master file

Back 73

it is a file master page that provides an overall layout for the site with headers, buttons, and footers.

Master page is designed to create a consistent layout for the pages in your application

Front 74

Example of getting the string from an input box

Back 74

Dim strAge As String

strAge = InputBox("Please enter your age", "Driver's License Agency")

Front 75

A procedure cannot detect at run time whether a given argument has been omitted or the calling code has explicitly supplied the default value. If you need to make this distinction, you can set an unlikely value as the default. The following procedure defines the optional parameter office, and tests for its default value, QJZ, to see if it has been omitted in the call:

Back 75

Sub notify(ByVal company As String, Optional ByVal office As String = "QJZ") If office = "QJZ" Then Debug.WriteLine("office not supplied -- using Headquarters") office = "Headquarters" End If ' Insert code to notify headquarters or specified office. End Sub

Front 76

Enum EggSizeEnum Jumbo ExtraLarge Large Medium SmallEnd Enum

Back 76

Enum EggSizeEnum Jumbo ExtraLarge Large Medium SmallEnd Enum Public Sub Iterate() Dim names = [Enum].GetNames(GetType(EggSizeEnum)) For Each name In names Console.Write(name & " ") Next Console.WriteLine() ' Output: Jumbo ExtraLarge Large Medium Small Dim values = [Enum].GetValues(GetType(EggSizeEnum)) For Each value In values Console.Write(value & " ") Next Console.WriteLine() ' Output: 0 1 2 3 4 End Sub

Front 77

List of Strings using a collection initializer

Back 77

Dim currencies = New List(Of String) From

{

New String("AFA-Afghanistan Afghani"),

New String("ALL-Albanian Lek"),

New String("DZD-Algerian Dinar"),

New String("ARS-Argentine Peso"),

New String("AWG-Aruba Florin")

}

Front 78

List(Of Customer) collection by using a collection initializer

Back 78

Dim customers = New List(Of Customer) From { New Customer("City Power & Light", "http://www.cpandl.com/"), New Customer("Wide World Importers", "http://www.wideworldimporters.com/"), New Customer("Lucerne Publishing", "http://www.lucernepublishing.com/") }

Front 79

Equivalent code to generate the following List of advertiser

Dim customers = New List(Of Customer) From { New Customer("City Power & Light", "http://www.cpandl.com/"), New Customer("Wide World Importers", "http://www.wideworldimporters.com/"), New Customer("Lucerne Publishing", "http://www.lucernepublishing.com/") }

Back 79

Dim customers = New List(Of Customer) customers.Add(New Customer("City Power & Light", "http://www.cpandl.com/"))customers.Add(New Customer("Wide World Importers", "http://www.wideworldimporters.com/"))customers.Add(New Customer("Lucerne Publishing", "http://www.lucernepublishing.com/"))

Front 80

friend assembly example

Back 80

Imports System.Runtime.CompilerServicesImports System<Assembly: InternalsVisibleTo("AssemblyB")> ' Friend class. Friend Class FriendClass Public Sub Test() Console.WriteLine("Sample Class") End Sub End Class ' Public class with a Friend method. Public Class ClassWithFriendMethod Friend Sub Test() Console.WriteLine("Sample Method") End Sub End Class