SIMPLE Data Access

[Noggin The Nog]

Hi All,

As an ex VB6 developer I find ADO.Net has go HORRIBLY complex.

I don't want disconnected recordsets, I just want to run a query on an
Access DB(SELECT ID FROM Blah WHERE...) to see if the record exists. How do I
do this AS SIMPLY AS POSSIBLE?

[Cecil Martin]

Use execute scalar and check the return value. Also, I suggest you get
"Database Programming with Visual Basic.Net" from APress. It is a great
book for learning ADO.NET.

"Noggin The Nog" <No**********@discussions.microsoft.com> wrote in message
news:82**********************************@microsof t.com...

Hi All,

As an ex VB6 developer I find ADO.Net has go HORRIBLY complex.

I don't want disconnected recordsets, I just want to run a query on an
Access DB(SELECT ID FROM Blah WHERE...) to see if the record exists. How
do I
do this AS SIMPLY AS POSSIBLE?

[Noggin The Nog]

Thanks Cecil.

I've been messing around with ADO.Net for ages! I'd got VB6 data access
completely sussed, now I've got to re-learn everything!

With all this extra power comes a massive learning curve. Somebody needs to
explain to Microsoft that every time they change something we all have to
invest hours / days / weeks relearning. The upshot is applications are taking
longer than ever to create.

Thanks again, I'll go on an ADO.Net course I think!
"Cecil Martin" wrote:

Use execute scalar and check the return value. Also, I suggest you get
"Database Programming with Visual Basic.Net" from APress. It is a great
book for learning ADO.NET.

"Noggin The Nog" <No**********@discussions.microsoft.com> wrote in message
news:82**********************************@microsof t.com...

Hi All,

As an ex VB6 developer I find ADO.Net has go HORRIBLY complex.

I don't want disconnected recordsets, I just want to run a query on an
Access DB(SELECT ID FROM Blah WHERE...) to see if the record exists. How
do I
do this AS SIMPLY AS POSSIBLE?