Hello all,
I am facing an odd issue where the query in C# using the OracleDataAdapter is not filling the data completely, there are two columns where only part of the data is being populated. When I run this same query in the database, there is no missing data on any row.
Here is the pertinent C# code where we establish the database connection and fill the DataTable using the OracleDataAdapter:
I am attaching two screenshots. The first is showing the issue we are seeing with the OracleDataAdapter, where you can see only two rows are populating the two Ship1 & Ship2 columns data successfully. The second is showing the exact same query ran in the database where you can see Ship1 & Ship2 have data on every row.
I haven't dealt with this issue before and am at a loss as to what might be causing this to happen. Any help/suggestions would be appreciated.