Read data from DataView 2

[Andrzejek]

I have it working, but I am not sure if that's the best way to do it.

I create a table in my dataset:

[blue]
Private dvFileNumber As New DataView[/blue]

Dim strFile As String = "SELECT DISTINCT PSBRDG_PROJECTNAME, " _
    & " PSBRDG_PROJECTNUMBER, PSBRDG_FILE_NUMBER " _
    & " FROM S4111000.PSBRIDGE_INFORMATION"
[green]
'Create tblFileNumber in my dsDtSet[/green]
Call SetNewTableInDS(strFile, "tblFileNumber")
[blue]
dvFileNumber.Table = dsDtSet.Tables("tblFileNumber")[/blue]

I would like to use a DataView to filter my table to get what I want, but I need to populate a label. I know how to use DataView as a DataSource, but how do you get the data from DataView if you want to put this info into a label? Labels do not have DataSource.

For now I have:

For Each row As DataRow In dsDtSet.Tables("tblFileNumber").Select("(PSBRDG_PROJECTNAME = '" & cboPinNumber.SelectedValue & "') " _
    & " AND (PSBRDG_PROJECTNUMBER = '" & cboProjNumber.SelectedValue & "')")
    lblFileNo.Text = row("PSBRDG_FILE_NUMBER").ToString
Next

Filtering the table itself, which works fine.

I tried several variations of (code in red):

dvFileNumber.RowFilter = "(PSBRDG_PROJECTNAME = '" & cboPinNumber.SelectedValue & "') " _
    & " AND (PSBRDG_PROJECTNUMBER = '" & cboProjNumber.SelectedValue & "')"
[red]
lblFileNo.Text = dvFileNumber.Table.Rows(0).Item("PSBRDG_FILE_NUMBER").ToString   ...???[/red]

The [tt].RowFilter[/tt] works fine, it is just how do you get the data from DataView?

Or am I already *there* with [tt]Select[/tt] on the Table itself and should be happy with it? And forget about DataView in this case?


Have fun.

---- Andy

 

[RiverGuy]

Is this what you are looking for?

        For Each drv As DataRowView In MyDataView
            MessageBox.Show(drv.Item(0).ToString)
        Next

You can also bind the text of a label to a datasource as well.

Me.Label1.DataBindings.Add("Text", MyDataView, "ColumnName")

 

[Andrzejek]

Thanks RiverGuy. I knew I could count on you.....

Have fun.

---- Andy