Drop a Database through SqlConnection : SqlCommand Drop « Database ADO.net « VB.Net






Drop a Database through SqlConnection

Drop a Database through SqlConnection
Imports System
Imports System.Data
Imports System.Data.SqlClient

public class MainClass
   Shared Sub Main()
      Dim thisConnection As New SqlConnection("server=(local)\SQLEXPRESS;" & _
          "integrated security=sspi;database=MyDatabase")

      'Create Command object
      Dim nonqueryCommand As SqlCommand = thisConnection.CreateCommand()

      Try
         ' Open Connection
         thisConnection.Open()
         Console.WriteLine("Connection Opened")

         ' Execute NonQuery To Create Database
         nonqueryCommand.CommandText = "CREATE DATABASE MyDb"
         Console.WriteLine("Executing {0}",nonqueryCommand.CommandText)
         Console.WriteLine("Number of rows affected : {0}",nonqueryCommand.ExecuteNonQuery())


         ' Execute NonQuery To Drop Database
         nonqueryCommand.CommandText = "Drop DATABASE MyDb"
         Console.WriteLine("Executing {0}",nonqueryCommand.CommandText)
         Console.WriteLine("Number of rows affected : {0}",nonqueryCommand.ExecuteNonQuery())


      Catch ex As SqlException
         ' Display error
         Console.WriteLine("Error: " & ex.ToString())
      Finally
         ' Close Connection
         thisConnection.Close()
         Console.WriteLine("Connection Closed")

      End Try
   End Sub
End Class

           
       








Related examples in the same category

1.Execute NonQuery To Drop a Table and report how many rows affectedExecute NonQuery To Drop a Table and report how many rows affected