vb doesn't accept expressions for filtering?

[nacho2]

Hi, this is driving me crazy... let's see:

I need to show a window with data of a client, now i need to tell the textboxes in this popping window (after I double click on a list of all my clients) to get the data from the dataset selecting the row where the idclient is the one the user double clicked on.

I'm using a dataview (also tried to use dataset.table.select(...)) but won't accept an expression like this Dataview1.Rowfilter="IdClient=var" where var is a variable which has the Id value I want to use.

what can I do?

Thanks in advance

[techgnome]

Originally posted by nacho2
Hi, this is driving me crazy... let's see:

I need to show a window with data of a client, now i need to tell the textboxes in this popping window (after I double click on a list of all my clients) to get the data from the dataset selecting the row where the idclient is the one the user double clicked on.

I'm using a dataview (also tried to use dataset.table.select(...)) but won't accept an expression like this Dataview1.Rowfilter="IdClient=var" where var is a variable which has the Id value I want to use.

what can I do?

Thanks in advance

That's because ADO has no clue about your variable......

Dataview1.Rowfilter="IdClient=" & var.ToString

Tg

[nacho2]

beautiful! thanks!