读书人

请问:备份数据库时出现有关问题

发布时间: 2012-04-06 12:22:24 作者: rapoo

请教:备份数据库时出现问题
我在用vb.net备份数据库时,出现 "未定义类型SqlConnection "
请教各位高手,这是怎么回事?

用的下面的代码:
Dim strcon As String
Dim strsql As String
Dim con As SqlConnection
Dim com As SqlCommand
Dim databasepath As String
Dim pos As Integer

databasepath = Application.ExecutablePath
pos = InStrRev(databasepath, "\ ")
databasepath = Mid(databasepath, 1, pos) & "backup\databaseback.bak "

strcon = "server=localhost;database=humanadministration;uid=cxl;pwd=cxl; "
con = New SqlConnection(strcon)
strsql = "backup database yourdatabase to disk= ' " & databasepath & " ' "
com = New SqlCommand(strsql, con)



Try
con.Open()
com.ExecuteNonQuery()
MessageBox.Show( "数据库备份成功! ", "信息提示: ", MessageBoxButtons.OK, MessageBoxIcon.Information)

Catch ex As Exception
MessageBox.Show(ex.Message, "错误提示: ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
Finally
con.Close()
End Try

[解决办法]
命名空间

imports System.Data.SqlClient;

*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码)

最新版本:20070212

http://www.cnblogs.com/feiyun0112/archive/2006/09/20/509783.html

读书人网 >VB Dotnet

热点推荐