ASP.NET

Configure a Host Header for a Web Site[^]

To host more than one Web site on a Web server, you can assign a unique IP address to each Web site, designate a non-standard TCP port number for a Web site, or use host headers. Of the three methods, it is more common to use host headers than to assign unique IP addresses to Web sites or to use non-standard TCP port numbers.

using (SqlConnection con = new SqlConnection(GetConnectionString()))
using (SqlCommand cmd = new SqlCommand(storedProc, con))
{
    cmd.CommandTimeout = Convert.ToInt32(GetCommandTimeout());
    cmd.Parameters.Add(new SqlParameter("@AssociateId", SqlDbType.Int)).Value = AssociateId;
    // Or: cmd.Parameters.AddWithValue("@AssociateId", AssociateId);
    
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    DataSet dataset = new DataSet();
    da.Fill(dataset);
    
    return dataset;
}