Create An Database using SQL Connection

Posted Date: 07 Jul 2009	Resource Type: Code Snippets	Category: Visual Studio
Author: R.Vijayaragavan	Member Level: Gold
Rating:	Points: 7

Abstract:

Create an new Database using SQL Connection.

Description:

To Create an new Database using SQL Connection in VB.net.

Code:

Imports System
Imports System.Data
Imports System.Data.SqlClient

Public Class CreateDatabase
Shared Sub Main()
Dim thisConnection As New SqlConnection("server=(local)\SQLEXPRESS;" & _
"integrated security=sspi;database=DataBaseName;UID=sa;Pwd=")

'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 DataBaseName"
Console.WriteLine("Executing {0}",nonqueryCommand.CommandText)
Console.WriteLine("Number of rows affected : {0}",nonqueryCommand.ExecuteNonQuery())
' Execute NonQuery To Drop Database
nonqueryCommand.CommandText = "Drop DATABASE DataBaseName"
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

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Create An Database using SQL Connection .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: To Create Table and report how many rows affected executing NonQuery Method
	Previous Resource: LPAD and RPAD SQL Functions in Dot Net
	Return to Discussion Resource Index
	Post New Resource
	Category: Visual Studio

Post resources and earn money!

More Resources