|Week||Information||Information: Assignments due in one week unless otherwise stated. I am going to try to stay with the text to some degree but I am going to cover file handling sooner. If you have a different textbook, that is fine - just be sure to read about the topic we are covering and remember this is VB.NET 2003, not 2005. Check the schedule several times a week, I may add some things during the week.|
Week of December 10th
|The final and required status sheet have been sent. They must be returned on Monday the 17th.|
Week of December 3rd
|Catch up week.|
Week of November 26th
|We will continue with ADO this week. Please look at this example:
ADO look up add
In the Catch for the update try, you should add this line to remove the record that did not really get added: donationDT.Rows.Remove(newRecord)
Last assignment: Please write a program that involves some of the more complex things we have done with ADO. If you choose to do a simple version, you cannot get an A in this assignment. The program must use multiple ADO tables with a viable one to many relationship between two tables, it must update one or more tables (add and/or change and/or delete). It should include some kind of selection process to show records that match up with another record. you must define and document the problem that you are solving.
Week of November 19th
We are continuing with ADO this week. We looked at writing a program involving two tables
and the writing a version of the ADOadddelete program that did not involve drag and drop
of the connection, adapter etc.
Here are two databases to use: stu2000.mdb
In class we wrote these programs. For students not in class, please write and submit the programs, keeping in mind the code that you are using.
Week of November 12th
|We will continue looking at ADO and mutliple tables this week.
This week I want you to write two assignments based off my examples, both programs should deal with two tables that have a one to many relationship: 1) the first table should show information from one table in a text box and information from the second table (the many table) in a grid, 2) information from both tables should be in grids. When you click on an id from the first table (the one table), you should see all the records for that id in the second table (the many table). The examples you can look at are: Donortwotables and twogrids. You can make your own database with records in a one to many relationship or you can use this one: studentrel00.mdb
Week of November 5th
|Please be sure you have read chapter #9 and #10.
This week we are going to start looking at ADO. In class, we will experiment so be sure you have an Access database available that you can experiment with.
Presentations and examples are at the site.
Write a program that includes the code to connect inside the program that allows you to query a table and retrieve records. Include a next, previous, first and last button.
Write a program that uses a grid (include code inside the program to connect). Please do not use the server explorer for either of these assignments.
Week of October 29th
|I think we finished arrays!
Please read chapter #9 and next week please read chapter #10.
This week we will talk about printing a report and then we will spend some time reviewing Access. Next week, we will start looking at connections to Access through Visual Basic.
I am going over the basics of Access this week. If you have not had a course that has included Access, I suggest that you look at the introductory material under CIS17.
Array Assignment using structures and redim (see clarification of print report in the assignment)
Week of October 22nd
|This week we will continue looking at arrays. Check back to see how we are doing!
We are going to look at the logic for a Bubble Sort and a Top Down Sort. To help you understand the structure of these sort alogrithms. I will use the following presentations:
Separate speaker notes to accompany topdown sort
Separate speaker notes to accompany bubble sort
Modify my Bubble Sort program so that it does a Top Down sort.
Week of October 15th
|Please read chapters #7 and move on to #8. We will look at multiple forms this week and
continue with arrays. Look at the examples and the
PowerPoints dealing with multiple forms and menus and be sure to look at the more complex
examples in the text. It is a good text in my opinion so I highly recommend doing the reading!|
In class exercise (not to be passed in but can be done during the first hour on Thursday): Menu/Forms
VB Function assignment
Second assignment: I also want you to experiment with forms and passing data from one form to another. You can include that in the VB Function assignment (my first choice) or you can do a separate assignment.
Week of October 8th
|I will not be available this Tuesday for the 2-4 help session - have a meeting - Marissa will be running the
We will focus on chapter #6 this week. If you want to read ahead, chapter #7 is obviously next!
Finish looking at the PowerPoints and examples for loops, combo boxes, validation etc. and start looking at the Presentation and examples for procedures and functions as well as multiple forms and menus.
I made a mistake - the editing/validating for ABC etc. should be done in the first program not the second. You should be editing before you write the file.
Week of October 1st
|Read chapter #6 in the text.
We will actually look at things from chapter #5 this week and probably will not get to chapter #6 until next week.
Last week we got through the examples called Guess number and Loops continued Which included running totals. THis week we will finish the other examples including loops and combo and breaks and validation code.
Be sure you are using the resources at the site in addition to the text book.
Note that these are two separate programs - I have had some confusion before.
Week of September 24th
|We will deal with files this week so you can add that element to the assignment from last week.
Read chapter #5 in the text. We started looking at loops last week . Be sure you have looked at the PowerPoint presentations and examples.
We are going to continue looking at both conditons and loops. Check back and see where we are after Tuesday.
I want you to modify the quess the number program so that the user only gets a certain number of chances (let's say 5). When they have used all of their chances an appropriate message should display and the Play button should become visible.
Rock, Paper, Scissors Assignment
Week of September 17th
|Read chapter #4 in the text. We will continue looking at conditions and we will also look at
creating and reading sequential files (note that this is not covered in the assigned reading but
you can find it in the text).
Look at the examples and presentations on conditions and files. We may start looking at loops.
Algorithms and program design
We will look at some of these in class.
Please code either #4 or #5 in VB (extra credit if you do #5).
Check back - I think we will make it to this assignment - if not, next week.
We got to everything but the files, the files we will add next week. So, the assignmentis official!
Insurance form and file
Week of September 10th
Read chapter #3 in the text or about IF statements in VB.NET.
This week we are starting to look at conditions.
Please look at the three Powerpoints having to do with IF and the samples
of if statements. Remember there are sample programs available to illustrate
Week of September 3rd
|This course will use Visual Basic.NET 2003 (VB.NET). We are not using Visual Basic 2005. If you want
to experiment with this later version you are welcome to do so, but I suggest you
start out with the version being covered in the text and used in class.
Read chapter #1 and chapter #2 in the text. Next time this is offered, we will be using
the more recent version, so if you want to you can make the switch on some or all of the programs.
My availablity this summer
The schedule can also be accessed through my home page. I will keep updating.
You should be looking at the beginning examples and programs and the beginning PowerPoints. The software for this course is available through the text and it is also available through the Microsoft alliance. For information about using the alliance to acquire software for this course: MSDN Alliance Software
Save your project: I should have mentioned how to save when I started the project. Here is the explanation: Saving your project
When you send me the assignment, please zip the contents of the folder and send me the zipped file.