Result Recordset is not full
Posted: 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);
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
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