DataView RowFilter Help

[JPTL]

Hello, i am having some problems to return Value from a control into a SQL string, in VB6 worked like above, now how can i do this

Dim cmf As DataView = New DataView(ds.Tables("Fotos"))
cmf.Sort = "S_COD"
cmf.RowFilter = "S_COD=" & Me.ListView1.Select & ""

Thanks, Regards

 

[Bucky]

When setting the DataViews Sort property, you may need to
specify whether to sort ASCending or DESCending.

cmf.Sort = "S_COD ASC"

 

[JPTL]

Thanks for helping, *.SelectedItems(0).Text* was missing in the ListView and the Conection *con*

("Select * From Fotos Where SE_COD=" & Me.ListView1.SelectedItems(0).Text & "", con)