ADO数据控件及ODBC数据源高端应用

使用ODBC与数据库连接并对数据库进行数据操作，同时应用DataList、DataCombo、MsChart控件完成要求的数据操作。



（1）　　通过建立一个ODBC的系统数据源连接数据库，设计了一个窗体计算数据库内学生成绩表中每个学生的平均成绩，产生姓名、平均成绩和最低成绩三项数据，按平均成绩降序排列数据，并用该数据作图。

（2）　　设计一个窗体，通过DataList控件和文本框控件与ADO控件的绑定，当单击选择DataList控件中显示的学号时，文本框中显示相应的字段。

（3）　　通过DataCombo控件和文本框控件与ADO控件的绑定，当选择DataCombo控件中的学号时，文本框中显示相应的字段。

（4）　　使用外接程序的数据窗体向导创建主细表结构。-Use ODBC to connect with the database and the database data manipulation, while application of DataList, DataCombo, MsChart control the completion of required data manipulation.



(1) through the establishment of an ODBC system data source connect to the database, design a database form calculation of student achievement in the table of the average scores for each student to produce the name, grade point average and minimum performance 3 data, disaggregated by grade point average in descending array data, and use the data mapping.

(2) design a form, through the DataList control and text box controls and ADO controls binding, when you click select DataList control to display the student number, the text box displays the corresponding fields.

(3) by DataCombo control and text box controls and ADO controls binding, when you select the Student ID DataCombo control, the text box displays the corresponding fields.

(4) Use the Data Form Wizard add-ins to create master-detail table str