1 / 9

ESL Database Client

ESL Database Client. Paul McEnaney Spring 2010 c ompsci.snc.edu/cs460/ mcenpa. Project Description. Manage ESL Student Information Mini-registrar Requirements: Upgrade database to Access 2007 Remove redundancy Simplify data input ( students , grades ) Generate Reports

eilis
Download Presentation

ESL Database Client

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ESL Database Client Paul McEnaney Spring 2010 compsci.snc.edu/cs460/mcenpa

  2. Project Description • Manage ESL Student Information • Mini-registrar • Requirements: • Upgrade database to Access 2007 • Remove redundancy • Simplify data input (students, grades) • Generate Reports • Train the Client

  3. Basic Design • Simplify the Current UI • Fewer Tabs than the previous version • Focus on easy to edit data presentation • DataGridView • Focus on data that changes frequently • Students, grades, rosters

  4. The Data • Students • Personal Information • Frequent new additions • Classes • Grades • Intersection of Students and Classes • Very important both to instructors and students • Frequent additions/changes

  5. Presentation of Data • DataAdapter • Connect to the database • DataTable • In-memory representation of a database table • DataGridView (vsListView) • Bind to DataTables • Changes reflected automatically • VERY easy to use, or save back to the database

  6. Completed Work • DataGridView Prototyping • View/Edit all Student Information • View/Edit Class Rosters

  7. Currently In-Progress • Add new Classes (easy) • Reports (medium) • Have access to previous code • Display a student’s current classes (easy?) • Add student w/o scrolling to the bottom of the DataGridView (easy) • Filter Students by ID, Family/Given/English Name (medium) • Optimize for screen size (easy/medium) • Convert the Database

  8. Immediate Priorities

  9. Help Wanted: • Screen Resolution – flexibility • Easy way to dynamically size controls? • Name vs. ID in a DataGridView • Cannot save a DataTable that contains references to multiple tables in the DB • Good way to display a field from another table w/o effecting the save?

More Related