简单：如何在.net的IDE环境下编写操纵sqlserver数据库的代码?

Question

SqlConnection myConnection = new SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes");
SqlCommand myCommand = new SqlCommand(
                   "UPDATE Authors SET phone='[phone]' WHERE au_id = '123-45-6789'",
                    myConnection);myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
Dim myConnection As New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
Dim myCommand As New SqlCommand( _
                   "UPDATE Authors SET phone='[phone]' WHERE au_id = '123-45-6789'",  _
                    myConnection)myCommand.Connection.Open()
myCommand.ExecuteNonQuery()
myCommand.Connection.Close()
var myConnection:SqlConnection = new SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes");
var myCommand:SqlCommand = new SqlCommand(
                   "UPDATE Authors SET phone='[phone]' WHERE au_id = '123-45-6789'",
                    myConnection);myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();

Answer 1

我已经会了。多谢关注，快过年了，把分给了吧！