Need recordset behavior in VB.NET w/ADO help?

You could translate that directly. The rs! FieldName syntax translates to row("fieldName") in VB.NET It would be easier if you were using LINQ, though.

You could translate that directly. The rs! FieldName syntax translates to row("fieldName") in VB.NET.It would be easier if you were using LINQ, though.

I may have to look into LINQ. I'm afraid I don't know enough about the VB. NET layout of the thing to start translating.

Don't know how to declare/initialize a recordset, etc. – user185998 Oct 15 '09 at 19:36 You don't declare recordsets. You've already got the DataSet, and your code shows you know how to loop through the rows. – John Saunders Oct 15 '09 at 20:31 Isn't row!

Fieldname legal in VB. NET too? I know it is for SQLDataReader – MarkJ Oct 16 '09 at 9:23 John - the current challenge is the rsMaster.

Open statement. I'm getting a lot of COM exception errors when trying to open the recordset - the system chokes on both the source and the connection. If I could get the recordset open, I'm great.

It's just prying that thing open that's proving to be the challenge... – user185998 Oct 16 '09 at 11:43 @Dave: don't you already have DataSets working? Don't use recordsets at all. Only use DataSet.

– John Saunders Oct 16 '09 at 14:24.

It would be pretty straight forward to convert that to a SQLDataReader to replace the recordset. Basically, the syntax is using conn as new sqlconnection({connection string}) using cmd as new sqlcommand("select * from tblDQ order by xid, xcode, xDOS", conn) cmd.connection.open() using reader as SQLDataReader = cmd. ExecuteDataReader() while reader.

Read do your thing here, referencing reader("field") end while end using 'dispose of the reader end using 'dispose of teh command end using 'close and dispose of the connection.

Ack! Almost, but isnt' the reader a read-only construct? I need to update a field in the database with the code.

– user185998 Oct 15 '09 at 20:52 Oops - yup. Missed that - didn't pay close enough attention. LINQ would definately be better then.

– rjrapson Oct 15 '09 at 22:34.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.