TableNames from Database

Thanks a lot for that link, I think that's exactly what I need. I have a second question though...

What's the best way to delete all the data in .Net? From what I understand you're never suppose to have more then one connection to the database open at a time right?

So does that mean I should do it like this: (Sudeo code below)

' Dim X ' Counter Variable
' Dim ArrayTableNames() ' Array of all the tableNames in the database
' Dim Schema ' Returns all TableNames
' Dim DeleteRecordset ' Connection used to execute Delete commands
'
' Try
' Open the Schema
' For X = Schema.Count
' ArrayTableNames(x) = Schema.TableName(X)
' Schema.MoveNext
' Next X
' Close the Schema
' End Try
'
' For X = 0 to (ArrayTableNames.Count - 1)
' Try
' Open DeleteRecordset
' DeleteRecordset.RunQuery ("DELETE FROM ArrayTableNames(x)")
' Close DeleteRecordset
' End Try
' Next X