• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/223

Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

223 Cards in this Set

  • Front
  • Back
  • 3rd side (hint)
What is GAC?
The Global Assembly Cache is a well know directory that the CLR can locate and load strongly named assemblies: It's just a directory. In Windows XP you'll find it under C: Windows \\ Assembly
What is a strong name?
It is a name that has four attributes: File Name minus extension: Version: Culture: Public Key Token
Supplemental Reading

What is one way to write solid code?
You determine to understand the fundamentals and follow "best practices" which are conclusions that other programmers have come to after years of experience
Supplemental Reading

What is compiling code?
The process of converting the lines of code written in a computer language into the native language of a computer program.
Supplemental Reading

What is a compiler?
A complier is a special piece of software that converts the source code you create into code that the computer can understand, and checks for logic and syntax errors.
Supplemental Reading

What is an interpreted language?
An interpreted language is a language that is compiled into an intermediate language that is then interpreted by each type of computer they reside on.
Supplemental Reading

What is a Virtual Machine?
A virtual machine is a program that takes the compiled intermediate code and executes it on a particular computer. In .NET it is called the .NET Runtime.
Supplemental Reading

What is the intermediate language in .NET called?

In what kind of file does the compiled code reside?

What file extension(s) will the compiled code have?

what ahappens immediately when executing the compiled code?
The intermediate language in .NET is called the MSIL, or Microsoft Intermediate language and the compiled code will reside in a file called an Assembly which have an .exe or.dll file extension. When executing the assembly it immediately attempts to load the .NET Runtime and the .Net Runtime then becomes responsible for executing the MSIL code.
Supplemental Reading

What is a Software Layer?
A software layer is existing code created by other software developers that provides functionality that I, when I sit down to write applications, can use. In .NET this code is know as a library of code called the .NET Framework Class Library, or just the .NET Framework for short and contains thousands of methods for easily performing thousands of tasks.
Supplemental Reading

On a piece of paper, draw a diagram of the software layers in a Windows program
Your code -> .NET Framework Class Library -> Windows API's -> Many layers that comprise Windows internally -> Binary Instructions (the on and offs)
Supplemental Reading

What are 4 benefits of VB.NET as a programming language?
1. VB.NET is very English-like language. 2. It is a .Net language. 3. There are many VB programmers and many community resources on the web. 4. Lots of opportunities for VB programmers
Supplemental Reading

What is the downside to VB.NET as a programming language?
VB.NET is less of a C-style Syntax than C# which means that learning additional languages like Java, C++ and others might be more difficult.
Supplemental Reading

What are the benefits of C# as a programming language?
C# uses C-style syntax. Very few programmers know just one language
Supplemental Reading

Why could C# be considered a better programming language than VB.NET?
C# could be considered a better programming language because it doesn't have to support "legacy" code, meaning C# is more streamlined than VB. VB was forced to support many of the older features due to the outcry of some programmers who did not want to re-write large amounts of code in order to take advantage of the .NET Framework. Plus review job listings on Dice.com and Hotjobs.com. You will find that C# developers are in high demand
Supplemental Reading

What are four development goals I should adopt?
Four development goals I should commit to are:

1. Create software that fulfills requirements and is accurate. 2. Write software that has virtually no bugs. 3. Create software that is usable. 4. Create software that performs well.
Supplemental Reading

What is the flawed concept of "Good Enough Software"?
"Good Enough Software" is flawed because it is a practice in which you build software the best you can knowing full well that it has problems, but it is the best you can do in the time allotted.
Supplemental Reading

The MASTER commitment in learning programming is what?
The MASTER commitment in programming is:

I commit to coding correctly and according to a studied and through knowledge of the fundamentals and best practices from day one.
How does Object oriented Programming seek to reduce the complexity of creating large applications?
Object oriented Programming seeks to reduce the complexity of creating large applications by breaking the application down into smaller, manageable classes of code. Each class represents an idea, whether tangible and concrete (such as a Product or Employee) or conceptual (such as Inventory or Order)
Supplemental Reading
What is the basic idea behind Object Oriented Programming?
The basic idea behind Object Oriented Programming is that if we can write code that mimics real world objects, like pencils, cars, customers, payments, etc. then it will make programming a lot easier.
Supplemental Reading
How might a car illustrate the concept of Encapsulation?
Using a car engine to illustrate Encapsulation... the powerful engine and navigation components are encapsulated behind two or three controls that you (the user) work with.
Supplemental Reading
Class: Simple definition
A simple definition of a class is that it is simply a blueprint. Its job is to define what data it should store (the variables, or rather Fields) and what actions the object should take (the procedures, or rather the Properties and Methods). Since a class is just a blueprint, it is not the actual object. It is just a definition of the object's appearance, behaviors, etc.
Supplemental Reading
What does a class define?
A class defines the fields, properties, methods and events that an object will have.
Supplemental Reading
When we talk about "types" we are talking about ________.
"Classes"
Supplemental Reading
What is the most basic building block of OO Programming?
The most basic building block of OO Programming is the Class.
Supplemental Reading
A Class defines f_____, p_____, m_____, and e_____ that an object will have.
A Class defines fields, properties, methods, and events that an object will have.
Supplemental Reading
What is a complex type?
A complex type is a type or class that we create ourselves.
Supplemental Reading
How is the NEW keyword used?
The NEW keyword is used to create an instance of a class which is an object based on that class.
Supplemental Reading
With respect to the creation of objects, what does the term "Reference" mean?
The term "Reference" refers to the address in memory where all the information about a newly created object is stored.
Supplemental Reading
What are "Fields"?

What is a BEST PRACTICE concerning fields?

What is a BEST PRACTICE concerning the naming convention for private fields?

What is a BEST PRACTICE concerning the naming convention for public fields?
"Fields" are simply variables defined within a class. They can be private or public.

BEST PRACTICE: Instead of Public Fields, use Public Properties. In general, keep as many fields and methods private, and make them public only if there is a reason to do so.

BEST PRACTICE
Use an m_ to denote a private field. If the field or method is private, use camel case.

BEST PRACTICE
Public fields, properties or methods should be in Pascal Case.

Camel Case == engineSize or elapsedMileage
Pascal Case == EngineSize or ElapsedMileage
Supplemental Reading
What is a "Method"?
A "Method" is an object oriented way to refer to procedures (or functions).

The terms "Methods", "Procedures", and "Functions" are synonymous. "Methods" is the preferred term.
Supplemental Reading
Methods can be either P_____ or P_____ scope.
Methods can be either Private or Public scope.
Supplemental Reading
Give a description of "Encapsulation".
Encapsulation is because classes are like mysterious "black boxes" to the code that call them. You know nothing about how the object works except for the Public properties and methods.
Supplemental Reading
Why would you overload a method?
When you create classes, you don't always know how they might be used up front in your application. Sometimes you don't have all the data readily available to you that you would need to call a method, so you need options on how to call the method.
Supplemental Reading
In the context of overloading a method, what is the key characteristic of the "Method Signature"?
In the context of overloading a method, method signature is a technical term that means each method definition must have a different set of parameters.
Supplemental Reading
What is a "Constructor"?
A Constructor is a special method that allows me to initialize my fields, or whatever else I may want to do when my object is first created.

In VB.NET I create a Constructor using the New statement
Supplemental Reading
What is a "Constructor"?
A Constructor is a special method that allows me to initialize my fields, or whatever else I may want to do when my object is first created.

In VB.NET I create a Constructor using the New statement
Supplemental Reading
Why is it a good idea to use Constructors?
It is a good idea to use Constructors in order to initialize the private property (private member) values of the new object
Supplemental Reading
What would be a BEST PRACTICE concerning Constructors?
Use Constructors to initialize values for a newly created object. the Constructor is the perfect place to execute code that MUST RUN in order for your object to perform correctly.
Supplemental Reading
Write out an example of an overloaded Constructor.
This code is executed as soon as I create an instance of the class.
Supplemental Reading
The .NET Runtime protects your program's memory. What is the value of this?
This prevents memory leaks or other bugs from shutting down the program immediately. This protects the application so that other programs can't corrupt its memory space.
Supplemental Reading
What is the .NET Garbage Collector?
The Garbage Collector is a process within the .NET Runtime that searches for object references in the code that is no longer needed. When it finds an unused object it disposes of it, or rather, it removes the object from memory.
Use the word "references" in the answer
Supplemental Reading
What is the relationship between the Garbage Collector and "flags"?
As the code is executing, the .NET Runtime will flag those objects that it knows it won't need again, and after a while the Garbage Collector comes through and disposes of all the objects that are flagged for destruction.
Supplemental Reading
What would be a BEST PRACTICE concerning Garbage Collection?
Don't attempt to help out the process of Garbage Collection by setting objects you are finished with equal to nothing.
What is a Destructor?
A Destructor is code that is written to clean up your application, which might include closing any open references to files or databases. A Destructor runs just before an object is destroyed.
Supplemental Reading

How do you create a Destructor?
Use the Finalize method in the class.
Supplemental Reading

Why would you use a Destructor if the class is responsible for opening files?
If the class is to be destroyed, then I need to close the files it currently has opened. Not doing so may corrupt the file, or prevent other parts of your application from accessing the file at a later time.
Supplemental Reading

Why would you use a Destructor if the class keeps a connection to a database open as long as an instance of the class is being used?
It is not a good idea to close the connection of a database this way but it is done and a Destructor could be used to do it.
Supplemental Reading

Why might you choose to use a Destructor when your class is responsible for working directly with the Windows Application programming Interface (API)?
You may need to carefully "disconnect" from Windows so that the application or Windows (or both) do not become disabled.
Supplemental Reading

Write out the code that will create a Region of code.
C#
#region
//Code goes here
#endregion

VB
#Region "this is a region"
'Code goes here
#End Region
Supplemental Reading Tips

How do you turn on Numbering in the IDE?
Tools > Options > Text Editor Basic > Editor > Line Numbering
01
What is a project?
How do you create a new project?
A project is a collection of files that all get compiled together in order to create an executable file whether that's a .exe or .dll file.

There is a special folder called the "bin" folder. If I look in the Debug sub directory of bin I will see the .exe files.
01
How do you save your work and close the project?
I can click the save all button and then I can select "Close Solution" from the File menu. this will unload the project from Visual C#.
01
How do you reload an existing project?
Go to Start, Visual C# 2005 Express and select an existing project, or go to File Open Project and then navigate to the appropriate directory and then open the project. You select the .sln file or select the .vbprj file if VB or the .csprj files if C#.
01
What is the purpose for a Project?
What is the purpose for a Solution?
The purpose of a project is to keep track of all the files and all the code that belongs to a single application.

A solution is another organizational construct that allows us to group multiple projects together. Each project would create it's own executable file but those projects might have interdependencies.
01
What are some important features about the Solution Explorer?
I can open any file in the project by selecting it and then selecting either the code view or designer view.... or I can double click it and the default or designer view will open. I can add or remove files from the project from the Solutions Explorer. To remove I right click and select delete.
01
How do you open/view files, add new or existing files, rename and remove files?
`
01
What is the purpose of debugging?
Debugging allows me to pause execution and watch each line of code execute so you can pin point problems in your code. this is useful when programs be larger. I set a breakpoint and then step through the code one like at a time.
02

What is the Tool Strip Container?
The Tool Strip Container is a great tool that hosts other controls like the menu strip, the Tool Strip and the Status Strip.
01
How do I step through each line of code as it executes?
After the code encounters a break point and pauses I can then use one of the three debugging icons, Step into (F11), step over (F10), or step out (SHIFT+F11).
02

What does IDE stand for?
What is the purpose of the IDE?
IDE means Interactive Development Environment.

The IDE writes code for me when I work with the visual designer surface, and the Properties window. There are many tools in the IDE. They are windows that are available to perform various tasks.
02

What is a status strip?
A status strip allows us to send messages to the user.
02

What do you get by going to View | Document Outline?
You get a window in the IDE that shows all your controls in outline form.
02
What are the BEST PRACTICES for quick accurate layout of controls on a Windows Form?
BEST PRACTICE is to think in terms of columns and rows. Try to make them conform to a logic pattern. Keep the labels on the left and the data controls on the right. Keep the control buttons in the lower right hand corner of the form.

BEST PRACTICE: Stay with the standard fonts and colors.

BEST PRACTICE: Use standard or descriptive names for your controls. Be simple and succinct in your descriptions.
03
What are events?
What is an event handler?
Events are actions a user takes or even actions that happen inside the program itself. Events are triggere in your application. Your application can respond (or ignore) those events.
[I need a better answer to this question]

An event handler defines a section of code that will be triggered and executed whenever that event even is fired. the code you write must reside inside of a code block defined by curly braces. Methods are the basic building blocks of writing code. An Event Handler is a more specific type of an method.
02

What happens when you go to View|Tab Order?
Doing this displays a series of labels on the form that show the tab order for each of the controls. this display allows you to select the control that you want to be in Tab Order 1 and it will change the number to 0. Then you select the next and the next and so on to establish the Tab order you want. when finished select View|Tab Order again to turn the display off.
03
How do I create comments in C#?
How do I create comments in VB?
C#
Use 2 backslashes and then type comment.
// This is my comment
You can create a multi line comment like this:
/* This is a
* multi line
* comment
*/

VB
Use ' to start a comment
' This is a comment in VB
02

What is a BEST PRACTICE for Tab Order?
You generally wan to start in the upper left corner and progress in a logical way down to the lower right corner.
03
In C# what Function do the curly braces play { }?
Curly braces in C# define a block of code or the code block used to organize code... and a code block is anything between two sets of braces.
03
How do I comment-out / un-comment-out a line of code using the toolbar buttons?
I can type in a number of lines and then select the lines and press the "Comment out the selected lines icon to create a comment block. to uncomment them just press the next icon.
03
How do you find a complete list of potential events for any given control?
Select the control and then go to the properties window... at the top select the icon with the lightening bolt and you will see a complete listing of events categorized.
03
How do you insert a 'hot' hyper link in my code, to reference an article, help or other resource?
`Just type a hyperlink inside a comment. Then hold down the control button and click the link and the IDE will open up that website.
04
How do I create or declare and initialize the value of a variable?
You specify the datatype first and the a space and then the name you want to give the variable:

string myStringVariable;

To create, name and initialize a variable in one step do this:

string myInitializedStringVariable = "";
What is the importance of defining a data type for a particular variable?
In order for the computer to reserve the correct amount of space in memory for the variable we need to tell the computer what kind of variable it is.
04
What is the difference between a string literal and a variable name?
A string literal is any fixed set of letters and numbers that is intended to be used as the value of a variable.

The variable is the bucket and the string literal is what can go into the bucket.
04
What is the distinction between implicit and explicit data type conversions?
Implicit is when you are relying upon the compiler to make a conversion for you. Implicit conversion can be dangerous.

Explicit data type conversion require the programmer to write code to perform the conversion.
04
When do implicit data type conversion happen?
`
04
Why does an implicit data type conversion happen?
Implicit data type conversion happens when a source data type does not match the destination datatype but the source datatype can be understood and interpreted by the compiler into the destination datatype
04
When do I have to explicitly convert a data type?
It is actually a good idea to always do an explicit data type conversion rather than rely on implicit conversion. But it is necessary to do explicit conversion when the compiler cannot understand how to make the conversion implicitly. An example might be converting the string "five" into an integer 5. the C# compiler could not implicitly make this conversion.
04
What happens when a data conversion happens and the target data type allows less information to be stored?
`
04
Should I rely on implicit conversion?
`
04
What is the distinction between expressions and statements?
`
04
What are valid statements?
`
05
What is a Branching statement?
`
05
What kinds of expressions can be evaluated in a branching statement?
`
When should I select one type of branching statement over the other?
`
05
What is an array?
An array is a collection of related data.
05
How do I declare and initialize an array?
C#
string[] myArray
This is the way to declare a string array

To initialize the array above:
string[] myArray = ???
05
How do I reference an array's individual elements?
C#
If the array is declared as string[] and has 10 elements and I want to refeence element 8 I would use string[7]
05
What are indexes?
`
05
What is the difference between initialized versus sized arrays?
`
05
What is a recursion (aka "iteration") statement and how does it work?
`
05
Write out the code for each of the following and then describe how they are different:

For Each statement
For...Next
Do While Loop
`
05
When would I select one type of recursion statement over an other one?
`
06
What is the difference between a class and an object?
A class is the blueprint or recipie whereas an object based on the class is a specific instance of the class and has specific values for the properties of the class that make it distinct.
06
What is the difference between a field and a property?
A field holds on to a value behind the scenes wheeas a property is the public accessor and mutator for that behind the scenes value.
06
What is a method?
A method is a named block of code that can be called from another part of code. A method can accept parameters which are values that are going to be used in the body of the methods code block to modify how it works. A method can return a value or it can be structured so it does not return a value.
06
What is the purpose of a method's parameters?
A method's parameters are values that are passed into the method to be used in the code to modify how it works.
06
How would I define a void method?
A void method is a method that does not return a value.
06
What is variable scope?
Scope means that the variable can only be used within the context of the code block in which it was defined, or any sub-code blocks that are also defined within the same code block.
06
What is a code block?
A code block is a collection of lines of code that are enclosed in a set of curly braces.
06
What are some ways I can determine the scope of a variable within a code block?
you can determine if a variable is out of scope if intellisense does not become active as you are working with the variable.
06
Why is it important to be able to determine the scope of a variable within a code block?
`
06
How do I pass parameters into a constructor?
The constructor is defined to accept either no arguements or some arguements that are seperated by a comma. These arguements can be static values or they can be variables in which values are passed to the constructor at the time it is called.
06
How is an overloaded method represented in Intellisense?
Intellisense will show the number of overloads and beside each number is a dropdown arrow. When you select the arrow, it will display that particular overload and it's arguements.
06
What is the distinction between shared (Static) vs. instance methods?
`
06
What syntax do I use to create a shared method?
`
06
What are visibility modifiers?
`
06
What is the purpose of a visibility modifier?
`
06
What do the words "Public" and "Private" do to my methods, properties and fields?
`
06
How does the concept of Encapsulation affect how I create public properties and private fields?
`
06
When should I use private methods?
`
06
Why would I modify the Set portion of the property definition?
`
06
What is inheritance?
`
06
What is the difference between the base and derived class, or rather the parent and child class?
`
06
What is the concept of specialization?
`
06
What is the syntax to create a class that can be inherited from?
`
06
What is the syntax I use to create a class that inherits from another class?
`
06
Why not just copy and paste code instead of going through the pain of using inheritance?
`
06
How can I override methods of the base class?
`
06
When do I use the protected visibility modifier?
`
06
How is the behavior of a derived class' constructor affected by the base class' constructor?
`
06
What are the benefits of object oriented programming?
The benefits begin when designing your application. OO Programming starts with analysis and design. It provides a logical way of breaking down a big problem into small easy to digest bite-size pieces. It's easy to think of the major classes of your application and then start adding proberties and methods to each class charting the interaction between the classes.
1. Provides a process for simplifying the design of an application.
2. keeping functionality confined to a class makes it easy to change the way the objects of that class function.
3. By encapsulating functionality in your class the code that creates and uses an instance of your class might not have to be changed even though you update how your class operates internally.
4. Re-usability
07
In nutshell, what is the .NET Framework?
1. Framework Class Library (FCL)
2. .NET Runtime host
3. Utilities (Compilers, Code generators, etc.)
07
There are three major parts of the .NET Framework. What do these parts do?
.NET Framework Class Library (FCL): A series of classes with methods that encapsulate common system or application related functionality.
Think of the FCL as a bunch of classes that are available to your application that I didn't have to write but I get for free just be virtue of fact that I am writing a C# application.

.NET Runtime Host:
Manages permissions granted to applications
Is the 'sandbox' or 'protective bubble' where your applications run
Provides a common system of dat types across all .NET languages (VB.NET, C#, J#, etc.)
Manages memory for applications

.NET utilities: various and sundry compilers and debugging tools. Tools that automatically produce certain types of code or XML, there are so many different utilities.
C:\\WINDOWS\\Microsoft.NET\\Framework\\v2.0.50202 to see all utility applications
07
What are the major features of each of the three parts of the.NET Framework?
.NET Framework Class Library (FCL): A series of classes with methods that encapsulate common system or application related functionality.
Think of the FCL as a bunch of classes that are available to your application that I didn't have to write but I get for free just be virtue of fact that I am writing a C# application.

.NET Runtime Host:
Manages permissions granted to applications
Is the 'sandbox' or 'protective bubble' where your applications run
Provides a common system of dat types across all .NET languages (VB.NET, C#, J#, etc.)
Manages memory for applications

.NET utilities: various and sundry compilers and debugging tools. Tools that automatically produce certain types of code or XML, there are so many different utilities.
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50202 to see all utility applications
07
Explain how a .NET application works.
How does a .NET application work?
When you create an application and create an executable how does the .NET Runtime support your abblication. When you compile your application you create an assembly with either a .exe or .dll file extension. The code contained within this file is called intermediate Language (IL). It is temp language that will be compiled a second time when on the host machine the first time it is run.
When the application is running the .NET Runtime will host the assembly
07
What is a .NET Assembly?
`
07
What is the purpose of Intermediate Language (IL)?
It is temp language that will be compiled a second time when on the host machine the first time it is run.
07
What consumes IL and what does it produce?
The compiler consumes the IL and translates it into code that the host machine can understand.
07
What is Just-In-Time compilation?
`
07
What services does the .NET Runtime Host perform?
`
07
What happens if the user of the application does not have the .NET Runtime already installed on their computer? Will my application work? What can I do?
`
07
What is a Namespace?
A namespace defines a code block in which your classes must live. It helps you write code such to avoid naming conflicts. A namespace is a fully qualified name. Think of namespaces as full names.
07
What purpose does a namespace fulfill?
It helps you write code in a way that avoids naming conflicts.
07
What is the syntax to create a namespace, etc?
`
07
What, by default, is used as the Root Namespace?
`
07
What is a fully qualified namespace?
`
07 What shortcut can I use to reference a namespace in order to access its classes?
`
07
What is the primary namespace in the Framework Class Library?
`
07
Where would I look to find the default namespaces added to a Windows Form application?
`
07
What are 5 of the most important namespaces in the FCL?
`
07
What is the purpose of the System.Web namespace?
`
07
What is the purpose of the System.Net namespace?
`
07
What is the purpose of the System.Windows.Forms namespace?
`
08
What is a database?
A database is a structured repository for data. You sve information in the database. You read the information from the database. You update the information in the database. And sometimes you need to delete the information. The information is organized so it can be retrieved easily. the information can be sorted, can be grouped, can be related to other data and thereby can be used to analyze data in a countless number of ways.
08
What is the purpose of a database?
`
07
How is a database different from a Notepad text file, an Excel spreadsheet, etc?
`
07
What is the benefit of splitting data up into multiple tables?
`
08
What is the concept of Normalization?
Normalization: The process of determining what information belongs in which tables to minimize redundancy and increase integrity. Inmost cases you can normalize a database with a little common sense. Once you see it done a few times it will make a whole lot more sense.
08
How are database columns defined?
`
08
In database, what are the major data types?
`
08
What does it mean for a column to be nullable?
`
08
define data integrity in simple terms.
`
08
What are keys?
`
08
In database, what is a relationship?
`
08
What is the difference between a primary key and a foreign key?
`
08
What is an identity column?
`
08
What is the purpose of a foreign key constraint?
`
08
Outline the steps required to create a SQL Server 2005 Express Edition database from both the C# and VB 2005 Express Edition IDE's and the steps required to add and manage it within the project.
`
08
What is the purpose of the Database Explorer?
`
08
In database, how do I created new tables?
`
08
In database, how do I create a relationship between tables?
`
08
In a database, how do I open the table to add data?
`
08
In a database, what happens when I try to add data into a table that conflicts with a foreign key constraint?
`
07
What happens when I try to delete a row that has related data in other tables?
`
09
What is the concept of databinding?
Databinding is the behavior of user interface controls to retrieve an display data from a data source without requiring the programmer to worry about all the programmatic details of this process.

It is a feature of you ruser interface controls that allow them to retrieve information from a data source like a database and display that information to an end user. Each control might work a little differently. Some controls will display only one value or rather one field of data from a database. Other controls like the data grid view can display multiple fields or entire rows within its grid.
09
In the context of databinding, what are the "players' (data aware form controls, ADO.NET, etc.).
`
09
What sorts of things does ADO.NET manage for me?
`
09
What is the value of and the reasons for creating applications that interface with a database?
`
09
Describe the Data Source Configuration Wizard and it's pages and options.
`
09
What is a dataset?
`
09
What is the purpose of the .xsd file?
`
09
What is the purpose of the Data Sources window?
`
09
What is the purpose of a TableAdapter?
`
09
What is the purpose of the Binding Navigator?
`
09
What is the meaning of the word "data source"?
`
09
What is the purpose of the BindingSource on a form?
`
09
How do I manually databind using the properties window and quick tasks window (as opposed to solely using the Data Sources window)?
`
09
How do I fill a dataset with data from the database?
`
09
How do I save the changes to the data in the dataset BACK into the database?
`
09
What does the Me keyword in C# represent?
`
10
How is XML used in the .NET framework?
`
10
What is the strength of XML used in the .NET Framework?
`
10
What are the weakness of XML in the .NET Framework?
`
10
When should I use XML?
`
10
How does XML relate to ADO.NET datasets?
`
10
In the context of XML define these terms:
1. element
2. node
3. root
4. parent
5. child
6. sibling
7. attributes
`
10
What is the purpose of the .xsd document?
`
10
What does it mean for an XML document to be "valid"?
`
10
What does it mean for an XML document to be well formed?
`
10
Can you identify any of the .NET classes used to open an XML file from disk?
`
10
How do I read the XML out of the file, navigate and parse through it to grab the values etc?
`
10
What is the XPath Expression? (I may want to research this further on my own.)
`
11
How would I describe an "exception"?
`
11
What is responsible for raising exceptions?
`
11
What is an Exception object?
`
11
What kinds of information does each Exception object contain?
`
11
What is the significance of the System.exception base class?
`
11
What types of classes derive from System.Exception?
`
11
Why use specialized versions fo the System.Exception base classes?
`
11
How do I catch specialized versions of the Exception class?
`
11
What is the syntax of the try... catch statement?
`
11
What are some variations on the try...catch statement?
`
11
What are some BEST PRACTICES to keep in mind when handling exceptions?
`
11
Why do you want to handle exceptions instead of leaving them unhandled?
`
11
When does it make sense to leave some lines of code outside of your structured exception handling?
`
11
Why would you throw and exception?
`
11
How do I throw an exception?
`
11
Where do I throw an exception?
`
What is scope creep?
`
04
What is Declaring a variable?
Declaring a variable is the act of allocating space in the computer's memory for values of a specific data type, and giving the variable a name.
04
In VB
How do I do an explicit conversion from an string to integer?

How do I do an explicit conversion from integer to string?
Dim firstTextBox as Integer = 0
Dim secondTextBox as Integer = 0
Dim result As Integer = 0

firstTextBox = Integer.Parse(TextBox1.Text)
secondTextBox = Integer.Parse(TextBox2.Text)

result = firstTextBox + secondTextBox
Label1.Text = result.ToString()
04
In C#

04
In VB
How do I do an explicit conversion from an string to integer?

How do I do an explicit conversion from integer to string?
Int firstTextBox;
Int secondTextBox;
Int result;

firstTextBox = Integer.Parse(TextBox1.Text)
secondTextBox = Integer.Parse(TextBox2.Text)

result = firstTextBox + secondTextBox
Label1.Text = result.ToString()
04

How do you convert string values into either integer, double or boolean?
Integer.Parse(myString)
Double.Parse(myString)
Boolean.Parse(myString)
04

How do you convert a numeric value into a string?
Dim result As Integer

result.ToString()
04

What makes for a well formed line of code from the compiler's perspective?
VB
Dim x as integer
x+3

C#
int x
x+3

This is not a statement it is just an expression
04

What is a valid statement?
A valid statement consist of ...

Declaration --> Dim x as Integer
(or for C#) int x
Assignment --> myInteger = 3
Call --> MessageBox.kShow("Hello World")
New Object--> (Lesson 6)
04

What is a rule of thumb description of Statements and Expressions?
Expressions can be evaluated, Statements can be executed.
What are the two parts of a Property description? And what is the function of each?
The two parts are the 'get' and 'set'. The get allows us to return the field back when requested. The set allows us to assign to the underlying field value to whatever you want to assign it to.
08
What does RDBMS stand for?
Relational Database Management System
08
What is the theory of an RDBMS?
Rlational Database theory: Organizing data into tables that can be related together, thus reducing reduncancy and increasing the integrity of the data.
Tables
A table is the most fundamental database object. It consist of columns and rows (actually records). A single column and a single row is often called a "field" of data.
09
How does data binding work?
There are a series of class in FCL that support this operation. There are a set of classes in the System.data namespace that are referred to as ADO.NET. ADO = Active Data Objects.

ADO.NET begins by managing the connection to the database. A connection includes the process of locating the database either using a file system or a network protocol and it begins the handshaking to speak with the database. As long as a connection is open your application can speak to the database.