Question about DataSet Tables 1

[Turpis]

I was curious as to whether there is any difference between:

Me.dsMaster.Tables(0)
Me.dsMaster.Tables("myTable")
Me.dsMaster.myTable

In most examples I see the second two types.

If there is truly 3 ways to refer to a single table in a dataset, what is 'good coding'?

Charles
Quality Assurance/Developer

 

[chrissie1]

if all three of them work. All of them are good practice. At least none of them is bad practice.
Personnaly I never used method number three and dont even know if it works

Christiaan Baes
Belgium

What a wonderfull world - Louis armstrong

 

[JohnYingling]

Method three occurs in a strongly type dataset. It gets converted to an index access i.e MyTable is a function that returns something like dsMaster.Tables(0). Access via a name in a string should be slower because it must be searched for in the table collection.

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing

http://www.VBCompare.com

Compare Code

http://www.VBSortGen.com

Generate Sort Class in VB

http://www.Vbcompare.com/Check.Htm(1979

Check To MS)

 

[Turpis]

Thanks Christiaan and John for your responses. A star to you John, I am always looking to avoid the slower coding sequences.

Charles
Quality Assurance/Developer