Finishing off

All done, completed, finsihed, finalised..lol, thanks Rachel, nooo more Visual studio

Publishing??

Now I've completed the media, the instructions and applied them to the help menu, I can't understand how to publish it from the blog

Stage one of Party Toonz

I am currently working on the GUI. The database has been completed. The splash page was easy to complete using the example in our text book.
My problems working on the GUI is putting the correct buttons and panels in. I am yet to figure out the media player.
I worked on a design through photoshp for my template.

Array and File Handling Assignments

Using the step by step instructions for these assignments, these were pretty straight forward. Completed and handed in today.. yay! only Party toonz to go!

Databases Cont'

You can use relational operators which are
>
<
<=
>=
<>
=

anything with talking marks is case sensitive.
using % at the beginning of R will show what ends in R
% signs are called a wild card character
you can also put % at beginning and end and it will look at the beginning and end.
'This R% brings up locations starting with R
'%R anything that ends with R
'%R% starting and ending with R
'Use [] where a space has been inserted in name

logical operators
AND
OR
we can also use these in the expressions that we are making

And will only find from one section
Or will find from all sections

Concepts

Connection String - The supermarket
Connection Object - The car
Data Adapter - Mum doing the shopping
Command Object - The shopping list
DataSet Object - Pantry

* in sequel means ALL

SQL means Structured Query Language
Select
Delete
Update
Insert

WHERE filters where(it's a clause)

Database cont'

There are 4 different operations
delete
update
insert
select

2 different types of databases
flat file (excel spreadsheets)
relational (access)

manipulating a database
ID is King, it's all about ID

auto number
go to the data type in access
Access does not renumber id, there all all unique, even if they have been deleted
All of our tables will have an ID column that belongs to the table

Primary key
Suitablility - access is for single users or small business users.
limitation - not suitable for the internet.

SQL - structured query language, when we want to do our insert, update, delete etc

No spaces eva between anything in programming - capital or underscore

Generate reports and quiries with access

Database

What is a database?
A database collects data in a structured format. This happens so that the information can be easily found, stored and managed.
Used by businesses and even the internet for this program.

What are the different types of databases?
Customer list
Product informaation
mailing list
reservation system
phonebook
gps

2 different types of data bases:
flat file(excel spreadsheet)
relational databases (access, this can contain many different areas of information)
Table: within a table there are
Every column in a table is known as a field
Every row in a table is known as a record.
ID: If we know the id, is all we need to find info (ID is King)

different ways to set up but the general principal:
Primary key - only one, therefore makes info easier to find.

File Handling - System.IO

File Handling

Systems IO file class
-Creating Files
-Deleting Files
-Moving
-Copying
-Opening

.StreamReader can read text - IO.StreamReader
StreamWriter can write text - IO.StreamWriter

Constructor is an ON SWITCH

Chapter 9 - Arrays

Today we completed the chapter 8 test.
An Array

If you have
Dim My Array(5) As DataType
this means that there is 6 elements.from 0 - 5

Dim strNames(2) As String... has 3 elements.
we assign a value to each value in the index - egs..
strNames(0) = "Rach"
strNames(1) = "Pam"
strNames(2) = "David"

Declare and populate an array
This way you can have as many or as little as you like this way.
Dim chMenuOptions() As Char = {"a", "A", "b"}

loops

Dim strNames(2) As String
Loop to populate
Another array
Dim intDinnerBookings(2) As integer

(in memory) there will be the 3 strings (strnames)
and the 3 integers (intDinnerBookings)

you can match things up via the index

Dim ItemArray (3) As String = {"x", "y", "3"}
Dim intCount As Integer - - we have declared a count integer
For intCount= 0 To ItemArray.Length - 1
lstBoxItems.Add(ItemArray(intCount))ine of code is always going to return.

Next

intCount = 0 -- x
intCount = 1 -- y
inCount = 2 -- z

length returns the number of elements, not the upperbound

sorting an array
the data in an array often is sorted for an organised display.
So could be alphebetical etc
egs. Array.Sort(strNames)

Searching an array

Sequential - is searching for each element in an array
BinarySearch - method searches a sorted array for a value using a binary search algorithm. The binary search algorithm searcehd an array by repeating dividing the search interval in half.

Chapter 8 - exception handling

exception handling - handling errors

Try

intNumber = txtTextBox.Text
Catch ex As Exception


End Try

Try
intNumber = txtTextBox.Text
Catch ThisException As Exception<---> exception is a class
End Try

pg 592 - different exception types

Now to attempt the chapter.

3/8/09 - test and Chapter 8

First part of the morning we completed our test and I handed in my radar and mystic assignments.
Now we are going through chapter 8
Procedures
Public Sub MyProcedure()<--- its a method that we require furthur information for further tasks -->
'Do something
End Sub

Function

Public Function DoesItEqualTen (intNumberOne As Integer,intNumberTwo As Integer? As Boolean <-- depends on info you want to return -->
Dim blnTrueOrFalse As Boolean = False
If intNumberOne + intNumberTwo = 10
blnTrueOrFalse = True
Else
blnTrueOrFalse = False

End Function
If IsNumeric(txtTextBox.text) Then
---
End If
ublic FUnction IsNumeric(stringToLookAt) As Boolean
End FUnction

By Val - object is duplicated and passed to the function
By Ref - WHen you type in an argument, you will get a byref, pass the reference to the function

Chapter 7 Assignment

Today we are working on the chapter 7 assignment.
We will be using string functions
egs. intCharacters = txtText.Length
.ToLower
.ToUpper
validation functions.

RequiredFieldValidator
IftxtFirstName.Text<>""Then
continue
End If

Now we are doing an example. this example changed the lower and upper case of the text when hitting each button and put the correct text in the label.

Now we are doing chapter 7 - Mystic Reservations.
Test on MOnday.

Creating web applications

Today we are looking at creating web applications.
It is much like using css, with Html codes.
Added a button.
Wrote Ronsponse.Write().. this is a method. Where ever we see a parenthsies, after a method, needs properties (further info) put info into parenthsies (brackets)
Debugging is not enabled when hitting play - hit default and then enter.
You need to leaver the server before you can continue working on the file.

We then opened a new account called twitter, my name is deannem75
Using visual studio, we were able to update our twitter page with our comments.. how exciting!

Imports Twitterizer.Framework

Partial Class _Default
Inherits System.Web.UI.Page

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnClickMe.Click
Response.Write("Here is my message to print to screen")
End Sub

Protected Sub btnButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnButton.Click
Dim TwitterUserName As String = ("Deannem75")
Dim TwitterPassword As String = ("yuiop1")
Dim MyTwitter As Twitter = New Twitter(TwitterUserName, TwitterPassword)
MyTwitter.Status.Update("learning how to create a web page via visual studio")

End Sub
End Class

These are the methods, arguaments and properties we used.

Chapter 6

Chapter 6 is now completed and published - yay!!!!!

week 1 - 21/07 - chapt 6 project

Do until and Do while loops
Loops can be controlled at the top or bottom
eg.
Do until 1 To 10
or
Loop Until x=10
Chapter 6 project, due next week!

Final

Finally completed all assignments and the test.
Signing out
De :)

Alarm Clock

Over the last 2 days, I have battled with the alarm clock assignment. Yesterday I concentrated on getting the alarm sound playing at an appointment time, getting the alarm to repeat every 10 seconds and getting the snooze button to reset every 5 minutes.
Today I am designing instructions for the alarm clock. I added an extra button and am yet to sort out how to get this instruction page to work!

5/05/09

Yesterday we had a work session where I completed my Cats 'n' dogs assignment and also the class assingment. Today is another work session so I will work on my Alarm clock assignment.

28/04/2009

Today we will be going through our C4 Assignment 2: Alarm clock.
and using loops to perform repetative tasks

Assignment

Today i completed the dog part of my assignment, just have the cats one to do now

Arrays

20/04/2009 - Today we went through what arrays. egs
Dim string (3) As String which has 4 elements
strstring(0) = "first string"
strstring(1) = "2nd string"
strstring(2) = "3rd string"
strstring(3)= "4th string"

UML Class Diagram & VB.NET OpenFileDialog

A class diagram in the Unified Modeling Language (UML), is a type of static structure dagram that describes the structure of a system by showing the system's classes, their attributes, and the relationships between the classes.

OpenFileDialog: This class lets you do the following tasks:
Enable users to select one or more files on the local computer or on a networked computer.
Filter the file types shown in the dialog box.
Specify which filter is used when the dialog box is first displayed.

24/03/09

Objects: Objects have properties and methods. Everything is an object.
Button: The button property is the things the buttojn has, the button method is the things the button does.
If we double click on button 1 - highlight button1 - right click, go to definition, then highlight button1 at the end, all the object methods and properties come up.

Classes and Objects

Concept of Class. A class is simply an abstract model used to define new data types. A class may contain any combination of encapsulated data (fields or member variables), operations that can be performed on the data (methods) and accessors to data (properties). For example, there is a class String in the System namespace of .Net Framework Class Library (FCL). This class contains an array of characters (data) and provide different operations (methods) that can be applied to its data like ToLowerCase(), Trim(), Substring(), etc. It also has some properties like Length (used to find the length of the string).A class in VB.Net is declared using the keyword Class and its members are enclosed with the End Class markerClass TestClass
' fields, operations and properties go here
End Class
Where TestClass is the name of the class or new data type that we are defining here.ObjectsAs mentioned above, a class is an abstract model. An object is the concrete realization or instance build on a model specified by the class. An object is created in memory using the 'New' keyword and is referenced by an identifier called a "reference".

23/03/09

Today we are learning about Case test expressions.
Select case: is a good structure to use instead of else, if you are using 3 or more options.
Case else: is another eventuality.
Using Ranges: Is another way to specify values in a select case.

This week, we were taught about If, else and end if statements. We also completed our test.

10/3/09 UNICODE

Unicode
From Wikipedia, the free encyclopedia
Jump to: navigation, search
This article contains special characters. Without proper rendering support, you may see question marks, boxes, or other symbols.

The Unicode Standard, Version 5.0
Unicode
Character encodings
Comparison
UTF-7, UTF-1
UTF-8, CESU-8
UTF-16/UCS-2
UTF-32/UCS-4
UTF-EBCDIC
SCSU, BOCU-1
Punycode (IDN)
GB 18030
UCS
Mapping
Bi-directional text
BOM
Han unification
Unicode and HTML
Unicode and E-mail
Unicode typefaces
Unicode is a computing industry standard allowing computers to consistently represent and manipulate text expressed in most of the world's writing systems. Developed in tandem with the Universal Character Set standard and published in book form as The Unicode Standard, Unicode consists of a repertoire of more than 100,000 characters, a set of code charts for visual reference, an encoding methodology and set of standard character encodings, an enumeration of character properties such as upper and lower case, a set of reference data computer files, and a number of related items, such as character properties, rules for normalization, decomposition, collation, rendering and bidirectional display order (for the correct display of text containing both right-to-left scripts, such as Arabic or Hebrew, and left-to-right scripts).[1]
The Unicode Consortium, the non-profit organization that coordinates Unicode's development, has the ambitious goal of eventually replacing existing character encoding schemes with Unicode and its standard Unicode Transformation Format (UTF) schemes, as many of the existing schemes are limited in size and scope and are incompatible with multilingual environments.
Unicode's success at unifying character sets has led to its widespread and predominant use in the internationalization and localization of computer software. The standard has been implemented in many recent technologies, including XML, the Java programming language, the Microsoft .NET Framework and modern operating systems.
Unicode can be implemented by different character encodings. The most commonly used encodings are UTF-8 (which uses 1 byte for all ASCII characters, which have the same code values as in the standard ASCII encoding, and up to 4 bytes for other characters), the now-obsolete UCS-2 (which uses 2 bytes for all characters, but does not include every character in the Unicode standard), and UTF-16 (which extends UCS-2, using 4 bytes to encode characters missing from UCS-2).

10/3/09 ASCII

American Standard Code for Information Interchange (ASCII), pronounced /ˈæski/[1] is a coding standard that can be used for interchanging information, if the information is expressed mainly by the written form of English words. It is implemented as a character-encoding scheme based on the ordering of the English alphabet. ASCII codes represent text in computers, communications equipment, and other devices that work with text. Most modern character-encoding schemes—which support many more characters than did the original—have a historical basis in ASCII.
Historically, ASCII developed from telegraphic codes. Its first commercial use was as a seven-bit teleprinter code promoted by Bell data services. Work on ASCII formally began October 6, 1960, with the first meeting of the American Standards Association's (ASA) X3.2 subcommittee. The first edition of the standard was published in 1963,[2][3] a major revision in 1967,[4] and the most recent update in 1986.[5] Compared to earlier telegraph codes, the proposed Bell code and ASCII were both ordered for more convenient sorting (i.e., alphabetization) of lists, and added features for devices other than teleprinters.
ASCII includes definitions for 128 characters: 33 are non-printing, mostly-obsolete control characters that affect how text is processed;[6] 94 are printable characters, and the space is considered an invisible graphic.[7] The ASCII character-encoding scheme is the most-commonly-used character set on the Internet.[8]

10/3/09

Today we learnt about If Statements. If Statements evaluates to see if it is True Or False.
>= (greater than and equal to) is known as a relational operator - See page 315 of text book for other examples.

Visual Basic Sites

Sites that will hopefully give me some sort of grasp of this course and what visual basic is!

What is Visual Basic?

http://en.wikipedia.org/wiki/Visual_Basic

http://msdn.microsoft.com/en-us/library/2x7h1hfk.aspx

Examples of visual basic

http://pages.cpsc.ucalgary.ca/~saul/vb_examples/index.html

http://visualbasic.about.com/od/standalonevb6/l/bllearnvba.htm