Page 1 of 1

Result Recordset is not full

Posted: Thu 31 Mar 2005 20:23
by DirkPitt
I do a select in this way:
string sql = "SELECT * FROM table_name"

DataSet ds = new DataSet();
PgSqlDataAdapter da = new PgSqlDataAdapter(sql,conn);
da.Fill(ds);

When I attach this DataSet to a DataGrid.DataSource, I see only 6 fields and not all fields of the table.
Something like this:

Field 1 Field2 Field 3 Field 4 Field 5 Field 6 Field 7 Field 8
"a" "b" "c" "d" "e" "f" null null
On the other hand if I execute the same query in pgAdmin III console the result is correct.
No exception is raised up.

Someone can help me?
Thanks in advance

Posted: Thu 31 Mar 2005 20:42
by Guest
I just read now another post that rais my problem...
Sorry ;)