Loading

Detach mdf file on form closing

Andre Proulx

Hi, Using Visual Studio (2008) in Vb net along with SQLExpress (2008) in Windows Forms, how to detach the database every time I close the Appby programmation. Can it be done on form closing, if so please show us. Thank in advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Hirendra Sisodiya15y ago
try this code:

write code on form closing event

Dim conn As new SqlClient.SqlConnection
Dim cmd As New SqlClient.SqlCommand()

Dim ConnectionString As String = "Data Source=" & SERVER NAME & ";Initial Catalog=master;Integrated Security=True"

conn = conn.ConnectionString = ConnectionString
conn.Open()

Dim sqlDetech As String = "sp_detach_db '" & database name & "', 'true'"
cmd.CommandText = sqlDetech
cmd.Connection = conn
cmd.ExecuteNonQuery()

please mark as answer if it helps
0