SqlDataAdapter select command not returning correct results

[dfn77]

Hi,

I'm having some trouble with the following piece of code:

string getAllNew = "SELECT * FROM dbo.HeaderAndDetail WHERE ProcessedToCsv = 0";
            conn.Open();
 
            try
            {
                SqlCommand cmd = new SqlCommand(getAllNew, conn);
                SqlDataAdapter dAdapter = new SqlDataAdapter();
 
                dAdapter.SelectCommand = cmd;
                DataTable dTable = new DataTable();
                dAdapter.Fill(dTable);
 
                cmd.Dispose();
                cmd = null;
 
                WriteToCSV(dTable, filename);
 
                dAdapter.Dispose();
                dAdapter = null;
                dTable.Dispose();
                dTable = null;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.ToString(), ex);
            }
            finally
            {
                conn.Close();
            }

The problem is that after the data table is filled, the rows in it include results that have ProcessedToCsv = 1 (not 0).

When I run the query (SELECT * FROM dbo.HeaderAndDe tail WHERE ProcessedToCsv = 0) in SQL server, it returns accurate results.
When that same query is the data adapter's select command, it returns everything.

What am I doing wrong? I've tried altering the query in code to the following:
SELECT * FROM dbo.HeaderAndDe tail WHERE ProcessedToCsv = @PTC (then adding a parameter and giving it a value before setting the select command of the data adapter)

SELECT * FROM dbo.HeaderAndDe tail WHERE ProcessedToCsv = 'False'

The above did not work.


FYI, "dbo.HeaderAndD etail" is a VIEW in my database. "ProcessedToCsv " is a BIT type column in my Detail TABLE. Playing around with those elements in SQL server is fine. Any query I execute returns accurate results.
I see no errors when I run the above code, or execute various queries in SQL server.

Would appreciate any help with this

[GaryTexmo]

I'm wondering if your code is off... your data adapter doesn't get instantiated with the connection, you instead attach a command to it. I'm not sure if this is right... maybe it is, maybe it isn't (I don't have an SQL database to test with). Perhaps try this...

...
SqlDataAdapter dAdapter = new SqlDataAdapter(getAllNew, conn);
dAdapter.Fill(dTable);
...

The only other thing I can think of is maybe try using the fully qualified field name. That's kinda a shot in the dark, but maybe there's something funny?

string getAllNew = "SELECT * FROM dbo.HeaderAndDetail WHERE dbo.HeaderAndDetail.ProcessedToCsv = 0";