HELP with dataviews

[miltonb]

Can anyone help me?<BR><BR>I have a .vb file which queries a database and successfully returns some data in a dataset; it binds to a datagrid just fine using the defaultview; and when I check the rowcount of the defaultview like so: <BR><BR> response.write(dsAirports("airports").defaultview.Rows.Count.tostring())<BR><BR>it is OK...<BR><BR>Everything works fine until I try to create a new dataview out of this table like so:<BR><BR> dim mydataview as dataview<BR> mydataview = new dataview(dsAirports("airports"))<BR><BR>now I get basically an empty recordset; when I bind it to a datagrid I get nothing, and when I check the count property like so: <BR><BR> response.write (mydataview.count.tostring())<BR><BR>I get zero.<BR><BR>What am I doing wrong??<BR><BR>Any help would be greatly appreciated,<BR><BR>Wayne<BR>[email protected]:<BR><BR>Nevermind, I figured it out...just a spelling error!<BR>