C-Ilab: Week 1: The Database Programming Environment

SAI430—iLab Week 1: The Database Programming Environment

TCOs Satisfied
1
Given a set of guidelines and tools, explore how project work and development can be enhanced and improved with proper structure and formality.
5
Given a business system application that needs to retrieve from and write to a relational database using an external sequential or CSV data file format, the student will design, code, and document the business application using a high-level language.

Introduction and Rationale
During Week 1, the primary learning activity is to set up the programming and database environments that you will use in completing the course labs. We will investigate TCO 5 by learning how to use Visual Studio to connect to a MySQL database. This
Name your file LastName_FirstName_W1_iLab.docx. If your instructor requests additional files, you can ZIP this into a file entitled: LastName_FirstName_W1_iLab.zip.
2. In the document, include your full name, course number, professor’s name, date, assignment number, and email address as a header.
3. Include a screen capture of the console output. You can capture the console window by holding down the ALT key and pressing Print Screen. This will place the console window on the clipboard. You can then paste it into Word.
4. Copy and paste the program code into Word after the screen capture. Your instructor may ask you to include your entire project as a ZIP file. If so, she or he will give you specific instructions.
Make sure you close and save your Word document before uploading it to the Dropbox. This will ensure that the latest version of the file is
The second line prints 65 dashes. The third line would print the item size result RIGHT justified in a field of 10. Note that these three lines are examples and DO NOT go next to each other in your final solution. They are just hints. Review the C# Write and WriteLine methods as needed for data formatting.
HINT 4: When you extract the current price from the MySQL database, it comes from the DataAdapter as an object. In the line below, the object is then “cast” into a decimal which matches the type in the database. This freshly-cast object is then converted to a string with the addition of the “C” (or currency) format specifier. While your earlier classes probably addressed casting (often called typecasting), you should refresh your knowledge of this term and familiarize yourself with why it is used.
Console.WriteLine("{0, 10}", ((decimal)dataRow["curr_price"]).ToString("C"));

TIP: What do all these ODBC things do?
While there are several ways of doing this program, the method selected uses the ODBCConnection. Briefly discussed are the various classes used for this