cant fill dataset

Daniel Rabinovits

I run the string in Oracle SQL developer and i get data howerver when I try to fill the dataset I get 0 rows and 0 columns.

code is as follows:

string from_date = "01/28/2020";

string to_date = "01/29/2020";

string queryString = "SELECT d.materialcode AS MATCODE, m.itemdesc AS ITEMS, sum(d.quantity) AS QUANTITY FROM tbldispensed d " +

"right outer join tblmasterinventory m on m.materialcode = d.materialcode " +

"WHERE TO_DATE(d.datedispensed, 'yy/mm/dd') BETWEEN TO_DATE('"+ from_date + "', 'mm/dd/yyyy') " +

"AND TO_DATE('" + to_date + "', 'mm/dd/yyyy') " +

"GROUP BY d.materialcode, m.itemdesc";

conn.Open();

OdbcDataAdapter da = new OdbcDataAdapter(queryString, conn);

DataSet ds = new DataSet();

da.Fill(ds);

MessageBox.Show(ds.Tables[0].Rows.Count.ToString());

I get 0 rows....can you help please

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Daniel Rabinovits6y ago
Doesnt work in c#...tried all sorts of formating. HELP!!!
Amit Gupta6y ago
Well, if the same query runs on oracle then it should also work in code behind also, can you recheck the date format you are parsing 'yy/mm/dd' and on the some are in yyyy format, you can try clean and rebuild your project. Sometimes this works too.
Daniel Rabinovits6y ago
Works fine in Oracle
Amit Gupta6y ago
Did you tried running your query in oracle dbms? Did you got any rows there, as your syntax seems good.