DataSet Select error

[tshad]

I have the following line which I believe was working before. The error I
am getting is:

An unhandled exception of type 'System.Data.EvaluateException' occurred in
system.data.dll

Additional information: Cannot find column [F1].

I am getting this error from the last line of:

sTemp = DataSetObj.Tables(1).Rows(0)(0)
sTemp = DataSetObj.Tables(1).Rows(0)(1)
drCollection = DataSetObj.Tables(1).Select("F1 = 'FRANK'")

I am getting data in the 1st 2 lines so obviously there there is a column 1
(which is what F1 is supposed to mean).

So why the error?

Thanks,

Tom

 

[Cor Ligthert [MVP]]

thad,

But is there a column with the name "F1"

Cor