database connections...Dataset...questions...

benfowler · April 28th, 2008, 12:46 PM

Hi there....

Im very new to this......
When do database connections need to be closed???
How can I reference a specific field in a DataSet???

Thanks for any reply.....

http://www.hiredpower.com/ - Personal Recovery Assistant.

BrianWren · April 29th, 2008, 02:14 PM

As I understand it, the dataset has a Tables collection. The tables colection has a Columns collection. Elements in these collections can be referenced by a string or an ordinal.

So:

Code:

    ds.Tables("TblCars").Columns("Year")
or
    ds.Tables(0).Columns(3)