Looping through datarow

Hi,

I am passing a datarow to a function and need to iterate through this
datarow and parse it. The number of columns is unknown so I need to do
something like this:

Public Sub ConvertByTabsDataRow(ByVal drIn As DataRow)

For i = 0 To drIn.ItemArray.Count
If drIn.IsNull Then
strLine = strLine & "N/A" & Chr(9)
Else
strLine = strLine & drIn.ItemArray(i).toString() & Chr(9)
End If
Next

End Sub

Count is not a member of ItemArray so I can not use it, how do I iterate
through this datarow?

Thank youDim cnt As Integer

cnt = drIn.Table.Columns.Count

For i = 0 To cnt-1
If (drIn(i).IsNull Then
...
...
Next

HTH

"AMD Desktop" <makblair@.yahoo.com> wrote in message
news:CMCdnWAd-_lDixTcRVn-jg@.magma.ca...
Hi,

I am passing a datarow to a function and need to iterate through this
datarow and parse it. The number of columns is unknown so I need to do
something like this:

Public Sub ConvertByTabsDataRow(ByVal drIn As DataRow)

For i = 0 To drIn.ItemArray.Count
If drIn.IsNull Then
strLine = strLine & "N/A" & Chr(9)
Else
strLine = strLine & drIn.ItemArray(i).toString() & Chr(9)
End If
Next

End Sub

Count is not a member of ItemArray so I can not use it, how do I iterate
through this datarow?

Thank you
Thanks a lot

"Shiva" <shiva_sm@.online.excite.com> wrote in message
news:OYzxW0cwEHA.908@.TK2MSFTNGP11.phx.gbl...
> Dim cnt As Integer
> cnt = drIn.Table.Columns.Count
> For i = 0 To cnt-1
> If (drIn(i).IsNull Then
> ...
> ...
> Next
> HTH
> "AMD Desktop" <makblair@.yahoo.com> wrote in message
> news:CMCdnWAd-_lDixTcRVn-jg@.magma.ca...
> Hi,
> I am passing a datarow to a function and need to iterate through this
> datarow and parse it. The number of columns is unknown so I need to do
> something like this:
> Public Sub ConvertByTabsDataRow(ByVal drIn As DataRow)
> For i = 0 To drIn.ItemArray.Count
> If drIn.IsNull Then
> strLine = strLine & "N/A" & Chr(9)
> Else
> strLine = strLine & drIn.ItemArray(i).toString() & Chr(9)
> End If
> Next
> End Sub
> Count is not a member of ItemArray so I can not use it, how do I iterate
> through this datarow?
> Thank you