是否可以在vb.net上执行sql查询?
问题描述:
ALTER DATABASE test SET ENABLE_BROKER
这是SQL查询我希望当程序执行到执行.. ,因为我不想每次我换电脑也需要打开SQL管理工具来执行这个查询拉特是否可以在vb.net上执行sql查询?
答
您可以触发alter database
像一个普通的SQL语句:
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()
阅读ADO.NET命令。设置命令文本后,执行.ExecuteNonQuery() – MatthewMartin 2012-01-30 16:30:29