计算机二级—vf操作题代码编写

《计算机二级—vf操作题代码编写》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、第1题3020001-6(P41)答案：编写下拉列表框的Init事件代码：this.rowsource="selectdistinct种类frombook1intocursortt"编写下拉列表框的Init事件代码：dimex(1)selectsum(数量)frombook1where种类=this.valueintoarrayxthisform.text1.value=x(1)thisform.refresh第2题3020110X（P49）答案：thisform.grid1.recordsource="sele学号,课程名称,成绩fro

2、mfgradewhere课程名称=allt(this.value)intocursoraa"dimeb(3)selemax(成绩),min(成绩),avg(成绩)fromfgradewhere课程名称=allt(this.value)groupby课程名称intoarraybthisform.text1.value=b(1)thisform.text2.value=b(2)thisform.text3.value=b(3)第3题3020005n(P40)答案：在组合框的Interactivechange事件中编写代码如下：thisform

3、.grid1.recordsource="select学号,课程号,成绩fromgrade;where课程号=this.valueintocursortt"selectcount(*)fromttwhere成绩between85and100intoarrayxselectcount(*)fromttwhere成绩between60and84intoarrayyselectcount(*)fromttwhere成绩<60intoarrayzthisform.text1.value=x(1)thisform.text2.value=y(1)t

4、hisform.text3.value=z(1)thisform.refresh第4题3020211(P46)答案：（1）在属性窗口设置文本框TEXT1的value=date()（2）在“查询”按钮的CLICK事件中编写如下代码：thisform.grid1.recordsource="select订单号,签订日期,金额fromOrders;where签订日期<=thisform.text1.valueintocursortmp"