VB.NET Multiple Statments

[RFH Reseller: creativeworks]

in vb.net i came across a command that lets you run multiple SQL Select Statements, and run through the using only one DB connection...

ie,

codetoconnect(SELECT statement1; SELECT statement2; SELECT statement3)

runthrough Statement1

movenext

runthrough Statement2

movenext

runthrough Statement3

Disconnect



what is the line that is my 'movenext' I can't refind the code!! Grr.

[RFH Reseller: Sol]

The line movenext should be to move to the next RecordSet and would depend on how you are reading the data from the database.

[RFH Reseller: creativeworks]

If anyone is interested, I refound what I lost!

if you perfrom a multiple select in one fetch from the database (ie, "SELECT * FROM table_a; select * FROM table_b")

then! you can use dbread.NextResult() (substitute dbread for your connection)

what's so good? you only need to perform one database connect, if using datareader than obviously you will stay connected to the database, but you can also use it for datasets if you have a more advanced DAL setup.

[RFH Reseller: askjim]

Are you using sql server, if so have you thought about doing the same thing using a stored procedure.