各位高手帮忙给看看!!!在线等待!!
hlddg 2002-09-12 03:44:39 Private Sub Backup_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Backup.Click
Dim filename As String
Dim execsql As SqlClient.SqlCommand
Dim adoMa As SqlClient.SqlConnection
Try
adoMa = New SqlClient.SqlConnection("data source=(local)\netsdk;database=kangdg;user id=sa;password=1234;")
filename = "backup"
adoMa.Open()
execsql = New SqlClient.SqlCommand("back DATABASE kangda to disk='" & Trim(filename) & "'", adoMa)
execsql.ExecuteNonQuery()
adoMa.Close()
MsgBox("备份成功!")
adoMa.Close()
Catch
MessageBox.Show("没有备份成功", "备份失败", MessageBoxButtons.OK, MessageBoxIcon.Error)
adoMa.Close()
End Try
这段程序是我从Sonet(Net追求者) 的帖中粘过来的,我改了一下,我的数据库名为kangdg,备份到d:\backup文件,为什为总是备份失败呀?拜托各位给改一下!谢谢!