Classes
CSC 3xx
Database for use with csv reader program get it here Download it and put it in your c:\ folder. then get this code:
string strConn, strSQL;
strConn = "Provider=Microsoft.JET.OLEDB.4.0;" +
"data source=" + "C:\\special.mdb";
strSQL = "SELECT * from customers";
OleDbDataAdapter da = new OleDbDataAdapter(strSQL, strConn);
DataSet ds = new DataSet();
da.Fill(ds, "Customers");
dataGrid1.DataMember = "Customers";
dataGrid1.DataSource=ds;
//using System.Data;
//using System.Data.OleDb
<hr>;
text of the main class files so far
MIDTERM: view it here hints on getting stock price:
http://finance.yahoo.com/q?s=lmt
looking at the source code =
yfs_l10_lmt">112.25
so search for "yfs_l10_"+stock_quote and go from there.
CLass 7 project - open and save a text file, variable conversions
How to save a file in C# view here
EXTRA CREDIT!-- Take the class 6 program and also display the humidity and use the rich text box to display what the forecast will be.
Class 6 program -- For this class we grab a web page and parse it for the temperature and display the temperature.
Class 5 program -- This class we looked at string manipulation and how to open files
How to use open file dialog in C# From MS
The great huck finn by Mark Twain.
HP Printer program. Change ready message to fun quotes Download
CSC 397 Florida Southern
first class:
Here is the file we made in class: class1.mdb
We will be having class on monday. Sorry about that I should have checked first.
Second class:
data file- manufacturing from census bureau To save, right click and select "save as" save this to your hard drive
Third class
Workflow between access excel and powerpoint
Powerpoint tips for effective presentations
Tutorials
How to create your first program in Access Hello world This is the file that got created in this tutorial: first program
How to import data into access from excel The data file we started with: mfg and the resulting access database: importer
Your first sql statement ... File that was created from this exercise
Class the fourth. We created this select importer database
Fifth Class: we downloaded northwind and started with this: database following Class5 assignment Email to professor if not done
Sixth class: we used the northwind database and followed class 6 assignment Note the extra credit points. popular question.. how do you get the total of a sale after the discount? answer... (Price * quantity)*(1-discount)=discounted total Note in access you will have to use [] around the field name. [unitprice] as an example.
Midterm
The midterm is available for download here It is a self extracting executeable with the instructions and the database. Remember where you unpacked it so you can do the midterm. This has been updated with help for question 2c to show you how to do the questions in 2. This wednesday the 26th is the new midterm due date.
Class: Download 7-zip if you can't open a zip file.
For next class read chapter 4, 5 and 7
Start of final project Browser database