当前位置:网站首页>VB.net程序关闭后后台还在与SQL连接
VB.net程序关闭后后台还在与SQL连接
2022-08-09 05:58:00 【CSDN问答】
这段是批量将Excel数据写入数据库的,但是关闭程序后程序怎么还会在后台运行的?是连接没关闭吗?
For ii = 0 To ListBox1.Items.Count - 1 fileName = ListBox1.Items.Item(ii) Dim ExcelConnection As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source='" & fileName & "'; Extended Properties=""Excel 12.0 Xml; HDR=Yes""") ExcelConnection.Open() Dim expr As String = "SELECT [PASS_ID] FROM [拆分明细$]" Dim objCmdSelect As OleDbCommand = New OleDbCommand(expr, ExcelConnection) Dim objDR As OleDbDataReader Dim SQLconn As New SqlConnection() Dim ConnString As String = "server=localhost;database=STdata;user id=sa;password=Nngs8888!" SQLconn.ConnectionString = ConnString SQLconn.Open() Using bulkCopy As New SqlBulkCopy(SQLconn) bulkCopy.DestinationTableName = "chaifen" Try objDR = objCmdSelect.ExecuteReader bulkCopy.WriteToServer(objDR) SQLconn.Close() Catch ex As Exception MsgBox(ex.ToString) End Try End Using ExcelConnection.Close() ProgressBar1.Value = ii Next边栏推荐
- The difference between LDO and DC-DC
- RNN-T
- Used to import the data type
- Xilinx Zynq ZynqMP DNA
- mysql查看表的创建时间
- 契约测试(上):什么是契约测试
- 牛客每日刷题之链表
- 想要精准营销,从学习搭建一套对的标签体系开始丨DTVision分析洞察篇
- P8462 「REOI-1」奶油蛋糕
- Magnetic Core-Shell Fe3O4 Particles Supported Gold Nanostars | Magnetic Fe3O4-POSS-COOH | Superparamagnetic Fe3O4-Polydopamine Core-Shell Nanoparticles
猜你喜欢

harbor企业级镜像仓库搭建

JDBC_PreparedStatement预编译对象

qt发送邮件程序
[email protected]@cadmium sulfide nanocore-shell structure material|Fe3O4 magnetic nanop"/>Superparamagnetic iron [email protected]@cadmium sulfide nanocore-shell structure material|Fe3O4 magnetic nanop

shell函数

Shell:数组和函数用法

phpstudy 安装 flarum论坛

RT201 Domestic PA RF Power Amplifier Compatible with RFX2401C

牛客每日刷题之链表

Three Musketeers Advanced
随机推荐
获取开发版安全码SHA1时遇到的报错
2022/08/08 学习笔记 (day25)File类
牛客每日刷题之链表
S7-200SMART PLC Modbus TCP communication
Build a "firewall" for safety and carry out firefighting training in Fengzhuang Township, Tongxu County, Henan Province
How to pass a two-dimensional array to a function in C language?
进程和计划任务管理
untiy 倒计时
harbor企业级镜像仓库搭建
VScode安装了ESlint以后不管用、不生效的解决办法
5年测试开发工程师感悟——写给还在迷茫中的朋友
22年下高项论文题目预测
磁性核壳四氧化三铁颗粒负载金纳米星|磁性Fe3O4-POSS-COOH|超顺磁四氧化三铁聚多巴胺核壳结构纳米粒子
C语言如何给函数传二维数组?
LDO和DC-DC的区别
绕过反调试fuck-debugger
分布式定时任务框架 xxl-job 源码解析
SiO2/KH550修饰四氧化三铁纳米磁性颗粒|PDA包裹四氧化三铁磁性纳米颗粒(科研级)
X86汇编语言从实模式到保护模式练习题
shell正则表达式