㈠ VB瀹炴椂閿欒3705 瀵硅薄鎵撳紑鏃訛紝涓嶅厑璁告搷浣
鎼傛嵁搴撴墦寮澶勭悊瀹屾垚涔嬪悗瑕佸叧闂錛屼笉鐒跺啀嬈℃墦寮灝變細鎶ラ敊鐨
綾諱技榪欐牱
rs.open
榪欓噷鏄浣犵殑鍏跺畠浠ｇ爜
絳変笂闈㈢殑浠ｇ爜鎵ц屽畬瀵規暟鎹搴撶殑鎿嶄綔涔嬪悗瑕佸嵆瀹炵殑鍏抽棴
鍋囧叆榪欓噷浣犲張鏉ュ彞rs錛巓pen灝變細鍑洪敊銆
rs.close
浣嗗湪榪欏彞涓嬮潰鍐嶇敤
rs錛巓pen銆灝變笉浼氶敊銆
㈡ vb 瀵硅薄鎵撳紑鏃朵笉鍏佽告搷浣
鐪嬫ゼ涓昏寸殑搴旇ユ槸閫夋嫨鏁版嵁搴撴枃浠跺悗鎵撳紑錛岄偅涔堜綘鐨勫叧闂璂ataRec.close瀹為檯涓婃病鏈夊叧闂鏁版嵁搴撹繛鎺ワ紒瀹為檯涓婅佸叧闂鐨勬槸DataConn錛屼篃灝辨槸鍦ㄦ墦寮鏂囦歡鍓嶈佸姞涓奃ATAconn.close鍜孲et DATAconn=nothing銆
鍚庨潰鍏充簬DataRec.close鍚庣偣鍑籆OMMAND鎺т歡娌″弽搴旂殑鎯呭喌錛屾病鐪嬪埌瀹屾暣浠ｇ爜錛屾墍浠ヤ笉娓呮氬師鍥犱簡錛