Post
Ask Question
Ramco Ramco

Ramco Ramco

  • 428
  • 3.5k
  • 573.1k

Query result in HTML format

Feb 7 2025 5:39 AM

Hi

  I have below code and i want to send it in HTML format through Email body

            string _StrSQL = "SELECT T0.\"TransId\", T0.\"DocNum\", T0.\"DocDate\" " +
            "FROM \"ATULAYA_NEW_LIVE\".OINV T0 " +
            "INNER JOIN CRD1 T3 ON T0.\"CardCode\" = T3.\"CardCode\"  " +
            "INNER JOIN INV12 T5 ON T5.\"DocEntry\" = T0.\"DocEntry\" + " +
            "where T0.\"CardCode\" = T3.\"CardCode\"  and T3.\"GSTRegnNo\" <> '' " +
            "and T5.\"LocGSTN\" <> T5.\"BpGSTN\" ";

Thanks


Answers (8)