Hello,

I'm in urgent need of using the DataTable's Select()-method, but there appears to be a bug that makes the method not return all of the matches. When searching for an Int32 (or long) primary key, most of the rows are found, some are not (eg. "ID=1738933665" is found and "ID=1956736656" is not, but both are there).

Here you can a sample code for the bug:
http://www.aewnet.com/newsgroups/rne...50756&group=21

I haven't found any information at microsoft.com, nor anywhere else. I'm using the .NET Framework 1.0 (VS 2002).

Thanks in advance!!

-JAN

Yes, there's a bug in .NET framework 1.0
Try to use .NET Framework 1.1
or create DataView and use FilterRow property.

I am useing Visual Studio 2005 and framework 2.0 and am also getting incosistant results with the SELECT method of a datatable. I have added 2 tables to a dataset; one parent, one child. I am using a development environment so the data in each table is known and controlled. Stepping through the VB code, I can see where the select is sometimes failing (although some selects are working). This does not make sense to me since the same code adds records to the parent and child tables.

I fixed my problem with the datatable select method.
I am using framework 2.0 (Visual Studio 2005)

The fix is to add more qualifiers to the datatable column creation
My original code said
SubDT.Columns.Add("ContractID")

The revised code says
SubDT.Columns.Add("ContractID", System.Type.GetType("System.Int32"))

The SELECT method was fixed by more fully describing the column type in the tabel creation routine.