Result Recordset is not full

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL

Result Recordset is not full

Post by DirkPitt » Thu 31 Mar 2005 20:23

I do a select in this way:
string sql = "SELECT * FROM table_name"

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

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


Post by Guest » Thu 31 Mar 2005 20:42

I just read now another post that rais my problem...
Sorry ;)