The constructor of the SqlConnection object expects one parameter: the connection string. The connection string identifies the SQL server name, the SQL database name, and satisfies the authorization requirement by providing a user name and a password, or by specifying Trusted_Connection=true. You can specify the connection string in line within the constructor line, or you can specify it in Web.config. In IBuySpy, it is defined in Web.config as follows:

  <add key="ConnectionString"
    value="server=HAW2L1800\NetSDK;Trusted_Connection=true;database=StoreDOCJS" />

  var myConnection : SqlConnection  = 
    new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);

  myConnection.Open();
  var result : SqlDataReader  = 
    myCommand.ExecuteReader(CommandBehavior.CloseConnection);

  myConnection.Open();
  myCommand.ExecuteNonQuery();
  myConnection.Close();

People who read this tip also read these tips:

• Understanding Abstract Classes
• Extended Tag Extraction
• Implementing the OnMouseUp Event Handler
• JavaScript's Object Types
• Positioning Demo