锐客网

  1. 首页 > 睿知 > it技术 > >

vb.net数据库应用 vb数据库操作实例( 六 )

IT技术数据库


Dim tmpConnectionString As String = Data Source=JJK;Initial Catalog=master;Integrated Security=True cn ConnectionString = tmpConnectionString cn ConnectionString = tmpConnectionString cn Open() cn Open() Dim cm As SqlCommand = New SqlCommand( select spid from master sysprocesses where dbid=db_id( JXbase ) cn) mydr = cm ExecuteReader()
Dim cm As SqlCommand = New SqlCommand() cm Connection = cn
While (mydr Read()) 杀死进程
str = killmydr( spid ) ToString() cm CommandText = str cm CommandType = CommandType Text Application DoEvents() cm ExecuteNonQuery() 杀进程 End While mydr Close() cm = New SqlCommand( RESTORE DATABASE JXbase FROM DISK= C:\Backup cn) 恢复备份 cm ExecuteNonQuery() MsgBox( 恢复成功成功 ) cn Close() cn Close()
lishixinzhi/Article/program/net/201311/12901
【vb.net数据库应用 vb数据库操作实例】vb.net数据库应用的介绍就聊到这里吧 ， 感谢你花时间阅读本站内容，更多关于vb数据库操作实例、vb.net数据库应用的信息别忘了在本站进行查找喔 。

推荐阅读


上一篇：u盘系统坏了怎么装系统，u盘装系统教程图解

下一篇：python爬虫局部变量，python获取局部变量