DataView to dataGrid help

[mwfrancois]

Newbie here with hopefully a simple issue. I have searched and not found what I understand to be helpful. My problem is I am not getting any records returned to my datagrid. The field headings show up but no records. Any suggestions? Here is my code:

Private Sub SetUpGrid()

'Dimension dvVBCreditCard DataView object
Dim dvVBCreditCard As DataView

'Instantiate New DataView with data from table "VBCreditcard" in the dsVBCreditCard1 DataSet
dvVBCreditCard = New DataView(dsVBCreditCard1.Tables("VBCreditcard"))

'Filter Dataview by string in txtLname box
dvVBCreditCard.RowFilter = "LName = '" & txtLname.Text & "'"

'Set DataGrid equal to DataView
dgVBCreditCard.DataSource = dvVBCreditCard

End Sub

 

[Mike555]

You need to call .Databind.

Private Sub SetUpGrid()

        'Dimension dvVBCreditCard DataView object
        Dim dvVBCreditCard As DataView

        'Instantiate New DataView with data from table "VBCreditcard" in the dsVBCreditCard1 DataSet
        dvVBCreditCard = New DataView(dsVBCreditCard1.Tables("VBCreditcard"))

        'Filter Dataview by string in txtLname box 
        dvVBCreditCard.RowFilter = "LName = '" & txtLname.Text & "'"

        'Set DataGrid equal to DataView
        dgVBCreditCard.DataSource = dvVBCreditCard

        [b]'Bind DataGrid
        dgVBCreditCard.DataBind[/b]

    End Sub

 

[mwfrancois]

Mike555,
Thank you for your assistance. Unfortunately, I was unable to get the DataGrid records to show after adding the dgVBCreditCard.DataBind call. I received an error "Property access must assign to the property or use its value."
Do you have any other suggestions? Or, am I not understanding your first bit of help?

Here is the updated code:

'Dimension dvVBCreditCard DataView object
Dim dvVBCreditCard As DataView

'Instantiate New DataView with data from table "VBCreditcard" in the dsVBCreditCard1 DataSet
dvVBCreditCard = New DataView(dsVBCreditCard1.Tables("VBCreditcard"))

'Filter Dataview by string in txtLname box
dvVBCreditCard.RowFilter = "LName = '" & txtLname.Text & "'"

'Set DataGrid equal to DataView
dgVBCreditCard.DataSource = dvVBCreditCard

'Bind DataGrid
dgVBCreditCard.DataBindings()

 

[Mike555]

I don't see where you are filling the dsVBCreditCard1 dataset. Does this occur before SetUpDataGrid() is called?

 

[SqueakinSweep]

try using a Like Clause

dvVBCreditCard.RowFilter = "LName LIKE '" & txtLname.Text.Trim & "*'"

Sweep
...if it works dont f*** with it
...if its f****ed blame someone else
...if its your fault that its f***ed, say and admit nothing.

 

[chrissie1]

'Bind DataGrid
dgVBCreditCard.DataBind

is only neccesary for the ASP.NET datagrid.

not for windows forms.

And what happens if you leave out the rowfilter?

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting