.NET (Core and Framework)

foreach(DataTable table in ds.Tables)
    foreach(DataRow row in table.Rows)
    {
         foreach(DataColumn column in table.Columns)
         {
             //object data = row[column];
         }

         //OR
         //object data = row["ColumnName"];
         //OR
         //string data = row["ColumnName"].ToString();
    }

bassmaster_general wrote:

am writing a dll class to take in health patient information. On the developer side, how do i initialize my structure variables?

'code in the dll
Public Class MyClass

Private someData as ArrayList = New ArrayList

Private Structure PatientData
Public myDate as Date
Public myDouble1 as Double
Public myDouble2 as Double
Public myDouble3 as Double
End Structure

Private Function AddData(ByVal visitdate As Date, ByVal bmi As Double, ByVal height As Double, ByVal weight As Double) As Integer
Dim visit As PatientData
visit.myDate = visitdate
visit.myDouble1 = bmi
visit.myDouble2 = height
visit.myDouble3 = weight
visitData.Add(visit)
End Function end Class

'How do I populate these variables as the developer?

Friend Class PatientData

    Private _myDate As Date
    Private _myDouble1 As Double
    Private _myDouble2 As Double
    Private _myDouble3 As Double

    Public Property MyDate() As Date
        Get
            Return _myDate
        End Get
        Set(ByVal value As Date)
            _myDate = value
        End Set
    End Property

    'And so on with the other properties

    Public Sub New(ByVal VisitDate As Date, ByVal BMI As Double, _
    ByVal Height As Double, ByVal Weight As Double)
        _myDate = VisitDate
        _myDouble1 = BMI
        _myDouble2 = Height
        _myDouble3 = Weight
    End Sub

End Class

Public Class OtherClass

    Private _visitData As List(Of PatientData)

    Friend ReadOnly Property VisitData() As List(Of PatientData)
        Get
            If _visitData Is Nothing Then _visitData = New List(Of PatientData)
            Return _visitData
        End Get
    End Property

End Class

OtherClassInstance.VisitData.Add(New PatientData(visitDate, bmi, height, weight))

Peter Leipzig wrote:

As far as the species names as column headings. I understand your point, but for good or bad, the fishery that this program is to used in is one that is managed by the Federal Governemnt and has a management plan that identifies exactly the species involved, so adding new species will not be an issue.