One dataset, two datagrid

[Agnes]

I got one dataset, one datatable, but two datagrids.
I use dataview.rowfilter = 'sex ="F" and dataview.rowfilter = 'sex ="M" to
filter the information
and set to two datagrids's datasource = dataview (one is F , other is M)
However , it doesn't work ..
Please help

[Cor Ligthert]

Agnes,

Normally that should work, when you use the right quotes.

\\\
dvF.rowfilter = "sex = 'F'"
dvM.rowfilter = "sex = 'M'"
dgF.datasource = dvF
dgM.datasource = dvM
///

That should work, and give a reply if when it does , I get the idea you
seldom do that.

Cor

[CJ Taylor]

I've had this same problem with ListBox controls. I had to create 2 copies
of the dataset because it uses the datasets cursor to determine certain
values.

Unless the datagrid makes its own copy of the dataset... Then you can
reference the same one, otherwise, a change in position in the datagrid will
cause a change in position on the underlying dataset.

this includes filtering..
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:eV*************@TK2MSFTNGP09.phx.gbl...

I got one dataset, one datatable, but two datagrids.
I use dataview.rowfilter = 'sex ="F" and dataview.rowfilter = 'sex ="M" to
filter the information
and set to two datagrids's datasource = dataview (one is F , other is M)
However , it doesn't work ..
Please help

[Agnes]

I try your codes, it doesn't work.
It only work for one datagrid in one windowform,
Now, mysolution is One Table, Two datasets, Two datagrids, one Dataset per
one datagrid.

"Cor Ligthert" <no************@planet.nl> ¦b¶l¥ó
news:uA**************@TK2MSFTNGP12.phx.gbl ¤¤¼¶¼g...

Agnes,

Normally that should work, when you use the right quotes.

\\\
dvF.rowfilter = "sex = 'F'"
dvM.rowfilter = "sex = 'M'"
dgF.datasource = dvF
dgM.datasource = dvM
///

That should work, and give a reply if when it does , I get the idea you
seldom do that.

Cor

[Cor Ligthert]

Agnes,

That was not code that was a snippet

Here a sample code, what I tested, however the same as the snippet.

It gives the longtime regulars from the US and the EU in different datagrid.

\\\It only needs 2 datagrids on a form
Private dtVBreg As DataTable
Private Sub Form1_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
CreateTables()
Dim dvEU As New DataView(dtVBreg)
Dim dvUS As New DataView(dtVBreg)
dvEU.RowFilter = "Country = 'EU'"
dvUS.RowFilter = "Country = 'US'"
DataGrid1.DataSource = dvEU
DataGrid2.DataSource = dvUS
End Sub
Private Sub CreateTables()
Dim drel As DataRelation

dtVBreg = New DataTable("Persons")
dtVBreg.Columns.Add("Name")
dtVBreg.Columns.Add("Country")
For i As Integer = 0 To 7
dtVBreg.Rows.Add(dtVBreg.NewRow)
Next
dtVBreg.Rows(0).ItemArray = New Object() _
{"Herfried K. Wagner", "EU"}
dtVBreg.Rows(1).ItemArray = New Object() _
{"Ken Tucker", "US"}
dtVBreg.Rows(2).ItemArray = New Object() _
{"CJ Taylor", "US"}
dtVBreg.Rows(3).ItemArray = New Object() _
{"Jay B Harlow", "US"}
dtVBreg.Rows(4).ItemArray = New Object() _
{"Terry Burns", "EU"}
dtVBreg.Rows(5).ItemArray = New Object() _
{"Tom Shelton", "US"}
dtVBreg.Rows(6).ItemArray = New Object() _
{"Cor Ligthert", "EU"}

End Sub

I will be glad to hear if this works or not?

Cor

I try your codes, it doesn't work.
It only work for one datagrid in one windowform,
Now, mysolution is One Table, Two datasets, Two datagrids, one Dataset
per
one datagrid.

"Cor Ligthert" <no************@planet.nl> ¦b¶l¥ó
news:uA**************@TK2MSFTNGP12.phx.gbl ¤¤¼¶¼g...

Agnes,

Normally that should work, when you use the right quotes.

\\\
dvF.rowfilter = "sex = 'F'"
dvM.rowfilter = "sex = 'M'"
dgF.datasource = dvF
dgM.datasource = dvM
///

That should work, and give a reply if when it does , I get the idea you
seldom do that.

Cor

[CJ Taylor]

woot!

"Cor Ligthert" <no************@planet.nl> wrote in message
news:eA**************@TK2MSFTNGP12.phx.gbl...

Agnes,

That was not code that was a snippet

Here a sample code, what I tested, however the same as the snippet.

It gives the longtime regulars from the US and the EU in different datagrid.
\\\It only needs 2 datagrids on a form
Private dtVBreg As DataTable
Private Sub Form1_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
CreateTables()
Dim dvEU As New DataView(dtVBreg)
Dim dvUS As New DataView(dtVBreg)
dvEU.RowFilter = "Country = 'EU'"
dvUS.RowFilter = "Country = 'US'"
DataGrid1.DataSource = dvEU
DataGrid2.DataSource = dvUS
End Sub
Private Sub CreateTables()
Dim drel As DataRelation

dtVBreg = New DataTable("Persons")
dtVBreg.Columns.Add("Name")
dtVBreg.Columns.Add("Country")
For i As Integer = 0 To 7
dtVBreg.Rows.Add(dtVBreg.NewRow)
Next
dtVBreg.Rows(0).ItemArray = New Object() _
{"Herfried K. Wagner", "EU"}
dtVBreg.Rows(1).ItemArray = New Object() _
{"Ken Tucker", "US"}
dtVBreg.Rows(2).ItemArray = New Object() _
{"CJ Taylor", "US"}
dtVBreg.Rows(3).ItemArray = New Object() _
{"Jay B Harlow", "US"}
dtVBreg.Rows(4).ItemArray = New Object() _
{"Terry Burns", "EU"}
dtVBreg.Rows(5).ItemArray = New Object() _
{"Tom Shelton", "US"}
dtVBreg.Rows(6).ItemArray = New Object() _
{"Cor Ligthert", "EU"}

End Sub

I will be glad to hear if this works or not?

Cor

I try your codes, it doesn't work.
It only work for one datagrid in one windowform,
Now, mysolution is One Table, Two datasets, Two datagrids, one Dataset
per
one datagrid.

"Cor Ligthert" <no************@planet.nl> ¦b¶l¥ó
news:uA**************@TK2MSFTNGP12.phx.gbl ¤¤¼¶¼g...

Agnes,

Normally that should work, when you use the right quotes.

\\\
dvF.rowfilter = "sex = 'F'"
dvM.rowfilter = "sex = 'M'"
dgF.datasource = dvF
dgM.datasource = dvM
///

That should work, and give a reply if when it does , I get the idea you
seldom do that.

Cor

[Cor Ligthert]

> woot!

Do you believe I understand that, with some more words around it maybe I
could, is this indian language?

Cor

[CJ Taylor]

Perhaps this is just an American programmer thing.

Or maybe just between my programming cohorts...

Can I get a woot woot!?

I used it because I made the Dataset list.. and that made me happy.

is this indian language?

[Frank]

I have a form with 1 dset, 1 dtbl and 2 dviews and 2 dgrids. Works fine. I
don't see why your example shouldn't work. Can't you try it yourself?
Frank

"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:eb**************@TK2MSFTNGP11.phx.gbl...

woot!

"Cor Ligthert" <no************@planet.nl> wrote in message
news:eA**************@TK2MSFTNGP12.phx.gbl...

Agnes,

That was not code that was a snippet

Here a sample code, what I tested, however the same as the snippet.

It gives the longtime regulars from the US and the EU in different

datagrid.

\\\It only needs 2 datagrids on a form
Private dtVBreg As DataTable
Private Sub Form1_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
CreateTables()
Dim dvEU As New DataView(dtVBreg)
Dim dvUS As New DataView(dtVBreg)
dvEU.RowFilter = "Country = 'EU'"
dvUS.RowFilter = "Country = 'US'"
DataGrid1.DataSource = dvEU
DataGrid2.DataSource = dvUS
End Sub
Private Sub CreateTables()
Dim drel As DataRelation

dtVBreg = New DataTable("Persons")
dtVBreg.Columns.Add("Name")
dtVBreg.Columns.Add("Country")
For i As Integer = 0 To 7
dtVBreg.Rows.Add(dtVBreg.NewRow)
Next
dtVBreg.Rows(0).ItemArray = New Object() _
{"Herfried K. Wagner", "EU"}
dtVBreg.Rows(1).ItemArray = New Object() _
{"Ken Tucker", "US"}
dtVBreg.Rows(2).ItemArray = New Object() _
{"CJ Taylor", "US"}
dtVBreg.Rows(3).ItemArray = New Object() _
{"Jay B Harlow", "US"}
dtVBreg.Rows(4).ItemArray = New Object() _
{"Terry Burns", "EU"}
dtVBreg.Rows(5).ItemArray = New Object() _
{"Tom Shelton", "US"}
dtVBreg.Rows(6).ItemArray = New Object() _
{"Cor Ligthert", "EU"}

End Sub

I will be glad to hear if this works or not?

Cor

I try your codes, it doesn't work.
It only work for one datagrid in one windowform,
Now, mysolution is One Table, Two datasets, Two datagrids, one Dataset per
one datagrid.

"Cor Ligthert" <no************@planet.nl> ¦b¶l¥ó
news:uA**************@TK2MSFTNGP12.phx.gbl ¤¤¼¶¼g...
> Agnes,
>
> Normally that should work, when you use the right quotes.
>
> \\\
> dvF.rowfilter = "sex = 'F'"
> dvM.rowfilter = "sex = 'M'"
> dgF.datasource = dvF
> dgM.datasource = dvM
> ///
>
> That should work, and give a reply if when it does , I get the idea you> seldom do that.
>
> Cor
>
>