is that possible to execute sql query on vb.net?

Question

ALTER DATABASE test SET ENABLE_BROKER

this is the sql query i wish to execute while program is executing.. because i do not want to everytime i change computer also need open sql management tool to execute this query rath

Read up on ADO.NET commands. After you set the command text, execute .ExecuteNonQuery() — MatthewMartin, Jan 30 '12 at 16:30

score 9 · Accepted Answer · edited Dec 08 '14 at 01:58

9

You can fire alter database like a regular SQL statement:

Dim connection As SqlConnection
connection = New SqlConnection("Data Source=myServerAddress;" & _
    "Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;")
Dim command As SqlCommand
command = connection.CreateCommand()
command.CommandText = "ALTER DATABASE test SET ENABLE_BROKER"
command.ExecuteNonQuery()

edited Dec 08 '14 at 01:58

Andrew Briggs

1,329
12
26

answered Jan 30 '12 at 16:33

Andomar

232,371
49
380
404

score 2 · Answer 2 · answered May 18 '20 at 11:58

Better late than never. Missing opening and closing of the connection. In case anyone needs it:

Dim connection As SqlConnection
connection = New SqlConnection("Data Source=myServerAddress;" & _
    "Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;")
connection.Open()
Dim command As SqlCommand
command = connection.CreateCommand()
command.CommandText = "ALTER DATABASE test SET ENABLE_BROKER"
command.ExecuteNonQuery()
connection.Close()

is that possible to execute sql query on vb.net?

2 Answers2