Connessione database sql2008 asp.net

protected SqlConnection getConnecion()
{
  string connectionString = null;

  SqlConnection conn = new SqlConnection();
  ConnectionStringSettings settings = WebConfigurationManager.ConnectionStrings["Northwind"];
  if (settings != null)
  {
    connectionString = settings.ConnectionString;
  }
  conn.ConnectionString = connectionString;
             return conn;
}

public DataTable getDataTable(string sSQL, params IDataParameter[] parms)
{
  DataTable ds = null;
  SqlDataAdapter adapter = null;
  SqlCommand cmd = null;
  try
  {
                          SqlConnection conn = getConnection();
    conn.Open();
    cmd = new SqlCommand(sSQL, conn);
    cmd.CommandType = CommandType.Text;
    if (parms != null)
      foreach (SqlParameter par in parms)
      {
        cmd.Parameters.Add(par);
      }
    //cmd.Parameters.AddWithValue("@city", city);
    //cmd.Parameters.AddWithValue("@country", country);
    adapter = new SqlDataAdapter(cmd);
    ds = new DataTable();
    adapter.Fill(ds);
    adapter.Dispose();
  }
  catch (Exception ex)
  {
    throw new Exception(ex.Message);
  }
  finally
  {
    conn.Close();
  }
  return ds;
}