Code Snippet for detaching SQL database programmatically in vb.net

Code Snippet for detaching SQL database programmatically in vb.net

Dim conn As SqlClient.SqlConnection

Dim cmd As New SqlClient.SqlCommand()

Dim ConnectionString As String = "Data Source=" & Server name & ";Initial Catalog=master;Integrated Security=True" ' Connection string

conn = New SqlClient.SqlConnection

conn.ConnectionString = ConnectionString

conn.Open() 'Open connection

Dim sqlDetech As String = "sp_detach_db '"& database name &"', 'true'" ' Sql query for detaching database

cmd.CommandText = sqlDetech

cmd.Connection = conn

cmd.ExecuteNonQuery() 'execute query