Select query

Question

User-1578974752 posted

SELECT * FROM xxtec_tss_exp_receipt_lines_if WHERE NUMBER ='10' AND ITEMSs=NVL(:ITEM, ITEMSs)

it is working in toad

HOW CAN I do thi in vb.net. Thanks

Answer 1

User197322208 posted

From NVL I assume you are using an Oracle Database.

Learn about ADO.NET and Oracle Connection

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/oracle-and-adonet

Answer 2

User61956409 posted

Hi shsu,

shsu

SELECT * FROM xxtec_tss_exp_receipt_lines_if WHERE NUMBER ='10' AND ITEMSs=NVL(:ITEM, ITEMSs)

it is working in toad

HOW CAN I do thi in vb.net.

As ignatandrei mentioned, ADO.NET technology can help create data access applications. If you are using Oracle Database, please make sure you import the System.Data.OracleClient.

Imports System.Data.OracleClient

With Regards,

Fei Han