.net 数据库连接方法

web.config

  <appSettings>
    <add key="SiteSqlServer" value="http://www.blog007.com/server=192.171.2.40;uid=sa;pwd=sa;database=test" /> 
    ......

    ......

    ......

  </appSettings>

dim strConnectionString As String = ConfigurationSettings.AppSettings("SiteSqlServer")

   'Open connection to database
   Dim MyConnection As New SqlConnection(strConnectionString)            
   Dim MyCommand As New SqlCommand()

   Dim strSql As String= "INSERT INTO ptm_recommendfriend (sender, senderEmail, recipients, recipientsEmail) VALUES ('" & MailFrom & "','" & MailFromUser & "','" & MailToUserArr(i) & "','" & MailToArr(i) & "')"
    MyConnection.Open()
    MyCommand = new SqlCommand(strSql, MyConnection)
    MyCommand.ExecuteNonQuery
    MyConnection.Close()