9
Answers

Query result in HTML format

Ramco Ramco

Ramco Ramco
6d
173
1

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 (9)
Next Recommended Forum