Using DataTable populated with a Sqldataadapter

[HawkeyeD]

Hello everyone,

I am fairly inexperienced with using datatables in VB. My question is this: Can I access a particular column of a table by name if it is not defined elsewhere like when I populate a datatable using sqldataadapter.

Example:

Dim dtTempTable As New DataTable

        Try
            Using sqlCmd As New SqlCommand
                sqlCmd.Connection = sqlConn

                With sqlCmd
                    .CommandType = CommandType.Text
                    .CommandText = "SELECT * FROM CustData ORDER BY CustID"
                    .CommandTimeout = 300
                End With

                Using daAdapter As New SqlDataAdapter
                    daAdapter .Fill(dtTempTable )
                End Using
            End Using

So can I now access a particular column of a row using the column name?

for example:

            For Each drRow In dtTempTable.Rows
                   tmpCustID = drRow.("CustID")

            Next

Is this the way it can be done? I believe this is the case, but can't find any definitive examples online (probably not searching properly)

Thanks,

Hawk

[dglienna]

You need the SELECTED ITEM #, so it doesn't always show only the LAST record in the recordset.

[HawkeyeD]

Thanks for the reply, but not sure I follow. Would it not show the record of the row I am on?

[dglienna]

Not unless you stop the loop at the row that you're at.

[HawkeyeD]

Oh I think I follow. That was just some code I whipped up to illustrate what I want to do.

Here's what I want

            For Each drRow In dtTempTable.Rows
                   tmpCustID = drRow.("CustID")
                   
                   'No do stuff with this record
                    'finished with this record, move on to the next one

            Next

What I was looking for was confirmation that using the above syntax, would the value of the current row I am on, pass the value at column "CustID" to the variable tmpCustID? Or do I need to get the data of that column at that row a differnent way?

Thanks again

[dglienna]

In VB, the combobox's value can be retrieved several ways. x=combobox.selectedvalue will return a row like the error says. What intellisense doesn't tell you is that you can retrieve the information from this row using .Item(0) so x=combobox.selectedvalue.item(0) will give you the value including the type like integer, etc.

posted the link in the other thread

No need to loop...

[HawkeyeD]

Thanks for the help. Much appreciated!

[Mur16]

This is late binding and can give a runtime error if the field doesn't exist. I think the syntax is drRow.Item("CustID") or drRow.Cell("CustID"). I'm not at my computer with VS installed.