Problem with NULL values

[Jonas Hansson]

Hi,
I have a problem regarding NULL values in a database when I retrieve the
data with the MySqlDataAdapter fill a DataSet with the returned value.
Whenever the SQL statement returns data that has a column of which the
first row has the value NULL, that whole column will be NULL for all
retrieved rows. Do I have to set a specific value in the
DataSet/MySqlDataAdapter for it to work as expected or is it a bug or is
it somehow supposed to work this way?

 

[Patrik Löwendahl [C# MVP]]

This sounds like something out of the ordinary, I've never experienced
anything similar.

The data table isolates all rows from each other and should not "remeber"
column data from previous rows.

Either this is a bug in the MySqlDataAdapter or your query is somewhat
strange.

 

[Jonas Hansson]

This sounds like something out of the ordinary, I've never experienced
anything similar.

The data table isolates all rows from each other and should not "remeber"
column data from previous rows.

Either this is a bug in the MySqlDataAdapter or your query is somewhat
strange.

I guess it's a bug in the MySqlDataAdapter then :/, because if I
copy/paste my SQL statement(s) directly into my db-client then it returns
all the values as I expect them.