Can't bind to dataview.findrows result

[Niki]

I'm using findrows to extract specific rows from a dataview, and then want to
bind to them.

I'd assumed that you bound to the array result as you would to the the
dataview, but the system can't find the named col/item.

Dim dv As New DataView
dv.Table = ds.Tables("Replicate_Characters")
dv.RowFilter = ""
dv.Sort = "ReplicateID"
Dim drv() As DataRowView = dv.FindRows(195)
bmb = Me.BindingContext(drv)
txt_no.DataBindings.Add("Text", drv, "CharNo")
txt_min.DataBindings.Add("Text", drv, "CharMin")
txt_max.DataBindings.Add("Text", drv, "CharMax")
bmb.Position = 0

I've verified that following the findrows drv contains 3 rows, so it's not a
problem there, and if I bind directly to the dataview(dv) there's no problem.

Can anyone please advise as to where I'm going wrong?

Many thanks for any help!

Niki
--
Niki Reid
DARD, Belfast

[Bart Mermuys]

Hi,

"Niki" <Ni**@discussions.microsoft.com> wrote in message
news:14**********************************@microsof t.com...

I'm using findrows to extract specific rows from a dataview, and then want
to
bind to them.

I'd assumed that you bound to the array result as you would to the the
dataview, but the system can't find the named col/item.

Dim dv As New DataView
dv.Table = ds.Tables("Replicate_Characters")
dv.RowFilter = ""
Is there any reason why you can't use the row filter and bind to the dv:
dv.RowFilter = "ReplicateID = 195"

You can not bind to array's because they don't implement IList or any other
usefull interfaces for binding, you can bind to a single DataRowView though.

hth,
Greetings
dv.Sort = "ReplicateID"
Dim drv() As DataRowView = dv.FindRows(195)
bmb = Me.BindingContext(drv)
txt_no.DataBindings.Add("Text", drv, "CharNo")
txt_min.DataBindings.Add("Text", drv, "CharMin")
txt_max.DataBindings.Add("Text", drv, "CharMax")
bmb.Position = 0

I've verified that following the findrows drv contains 3 rows, so it's not
a
problem there, and if I bind directly to the dataview(dv) there's no
problem.

Can anyone please advise as to where I'm going wrong?

Many thanks for any help!

Niki
--
Niki Reid
DARD, Belfast

[Niki]

Bart

I've tried filtering which works fine but has a major performance hit (I'm
working in the compact framework). This looked just about perfect for what I
need - I'll just have to code something similar myself.

Thanks anyway,

Niki

"Bart Mermuys" wrote:

Is there any reason why you can't use the row filter and bind to the dv:
dv.RowFilter = "ReplicateID = 195"

You can not bind to array's because they don't implement IList or any other
usefull interfaces for binding, you can bind to a single DataRowView though.

[Cor Ligthert [MVP]]

Niki,

Than will your method give probably an even more performance hit.

Cor

[Cor Ligthert [MVP]]

>

Than will your method give probably an even more performance hit.

To explain that something more, you have to clone the datatable and than to
import the datarows which reflects the datarowview into that table.

You can use this sample (It is not exact the same). However I think the
method Bart told will give you more efficiency.

http://www.windowsformsdatagridhelp....7-d6ad9bebf57f

I hope this helps,

Cor