Visual Basic/Visual Studio 2008 Embedded SQL

[m1c]

What is the easiest (as most like simple embedded SQL) to declare and
open/then process a cursor in Visual Basic/Visual Studio 2008?

I wish it were as simple as it was in MF Cobol or C and its flavors
where your could just use EXEC SQL .......... END EXEC.

 

[Cor Ligthert[MVP]]

What is a cursor related to VB, in my idea that is something on my screen,
do you mean that?

 

[Smokey Grindel]

This kinda defeats the purpous of ADO.NET if you where to do that like
FoxPro use to... look at LinQ and see if there is anything useful there for
you

 

[aaron.kempf]

Do it in classic ADO!

-aaron

This kinda defeats the purpous of ADO.NET if you where to do that like
FoxPro use to... look at LinQ and see if there is anything useful there for
you







- Show quoted text -

 

[m1c]

Do it in classic ADO!

-aaron





- Show quoted text -

Well do you have examples of how to declare the ADODB Database
connection, and how to declare and execute cursors?
Here is pseudocode for the app:
My app is pretty simple:

Table1:
DB ClassOffice
PK Field ClassOffice

Table2:
Candidate
Office (references Table1.ClassOffice)
jpeg file
PK Candidate

Table3:
OfficeName
Candidate (references Table2.Candidate)
Vote INTEGER NOT NULL,
DateTime

So I need to declare a cursor for Table1 (assuming it has two rows or
more
for ClassOffice - like Class President, Class Clown)
and also declare a cursor for Table2(multiple Candidate rows for each
office, whether it's Class President or Class Clown)


And stop at end of set for instance the Class President so users can
place a
vote for that office, then do the same for the next office, ClassClown

Doesn't look like stored procedures can do it.

 

[m1c]

Do it in classic ADO!

-aaron





- Show quoted text -

Yes, but what is the "Classic ADO" syntax/implementation in Visual
Studio/Basic 2008?

 

[RobinS]

Do it in classic ADO!

-aaron





- Show quoted text -

--Yes, but what is the "Classic ADO" syntax/implementation in Visual
--Studio/Basic 2008?

Be careful about listening to him. He was trolling pretty heavily in here
last year.

What do you mean by your original request? If you clarify, someone will
probably help you.

RobinS.
GoldMail.com