public void OutPutHtml(string str)
  {
   const string FILE_NAME = @"C:\Test.html";
   if (File.Exists(FILE_NAME))
   {
    try
    {
     File.Delete(FILE_NAME);
    }
    catch (System.IO.IOException e)
    {
     return;
    }
   }
   FileStream fs = new FileStream(FILE_NAME, FileMode.CreateNew);
   BinaryWriter w = new BinaryWriter(fs, Encoding.Default);
   w.Write(str);
   w.Close();
   fs.Close();
  }


  public string GetHtmlString(DataSet ds)
  {
   StringBuilder strHtml = new StringBuilder();
   strHtml.Append("<html><head><title></title></head><body><table>");
   for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
   {
    strHtml.Append("<tr>");
    for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
    {
     strHtml.Append("<td>");
     strHtml.Append(ds.Tables[0].Rows[i][j].ToString());
     strHtml.Append("</td>");
    }
    strHtml.Append("</tr>");
   }
   strHtml.Append("</table></body></html>");
   return strHtml.ToString();
  }

  public DataSet GetDataSet()
  {
   using (SqlConnection sqlConnection = new SqlConnection())
   {
    sqlConnection.ConnectionString =
     "Data Source=192.9.200.25;Initial Catalog=MASDB_PRD;user=wr_user;pwd=wr654321";
    sqlConnection.Open();
    SqlCommand sqlCommand = new SqlCommand();
    sqlCommand.CommandText = "select product_type_id,product_type_name from dim_product_type";
    sqlCommand.Connection = sqlConnection;
    SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
    sqlDataAdapter.SelectCommand = sqlCommand;
    DataSet ds = new DataSet();
    sqlDataAdapter.Fill(ds);
    return ds;
   }
  }