Select string as a column name in datatable?

[Guest]

Hi,

I have problem using the string I declared in selecting the column in my
datatable.
Please could you tell me am I doing something incorrect?
Here is my code:

Dim myString As String

Dim dv As DataView = New DataView(dsDataSet.Tables("myTable"), _
" '" & myString & "' = '" & otherString & "'", "",
DataViewRowState.CurrentRows)

It compiles without problem,
but when I run it, It returns nothing from my dataview.

Can anyone help please, many thanks

 

[Guest]

missed type.

the 1st line should be:

Dim myString As String = "Name"

 

[Guest]

Solved.

case closed.

 

[Cor Ligthert]

Jonhathan,

Although I often make instructions where other would use more lines, I never
do that with the dataview. Splitsing it up in three lines makes that much
less error sensitive.

dim dv as new dataview(mytable)
dv.sort = "mysort"
dv.rowfilter = "mysort = 1"

I hope this helps?

Cor