VB6 to VB.Net - "Control.DataSource"

[gccosta]

in vb6 i have this working:

rsvar.Open "select * from clients", cn, adOpenKeyset, adLockOptimistic
    For Each Control In cad_clientes.Controls
    If TypeOf Control Is TextBox Then
        Set Control.DataSource = rsvar
    End If
    Next Control

how can i do the same thing in VB.Net??

Thank you,
Guilherme

[Pirate]

Is cad_clientes the name of the form ? if yes , then just replace it with Me keyword .

[gccosta]

this code:

rsvar.Open("select * from clientes where fornecedor = 'f' order by nome", cn, adOpenKeyset, adLockOptimistic)
 
        For Each Control In Me.Controls
 
            If TypeOf Control Is TextBox Then
                Control.DataSource = rsvar
            End If
 
        Next Control

works, but the "Control" word the vb.net doesn´t found!!

[Pirate]

Put this at the first line of the above code :

Dim Control As Control

[Edneeis]

Or if you have VS 2003:

rsvar.Open("select * from clientes where fornecedor = 'f' order by nome", cn, adOpenKeyset, adLockOptimistic)
 
        For Each ctrl As Control In Me.Controls
            If TypeOf Control Is TextBox Then
                ctrl.DataSource = rsvar
            End If
        Next

Although the bigger question is why are you using the old ADO instead of ADO.NET?

[gccosta]

and how i use ADO.NET?
is there a lot of diference??
it´s better or faster??

i use to program VB6 and Java. I am starting with VB.Net, so probably, i will do a lot code in the wrong way, i mean, i will program not like the thinkers of VB.net excpet we do!!

Thanks a lot,
Guilherme

[Pirate]

Definitely you need a book or some tutorials . Search the forum for some million of links on this issue ...lol

[Edneeis]

You might try reading the ADO.NEt section here: http://samples.gotdotnet.com/quickstart/howto/