Tables with relations in a Dataset?

[Lars Netzel]

I have a VB.NET application based on MS access 2000 db.

I have a 1 to many relation between 4 tables...

tbl1 -> tbl2 -> tbl3 -> tbl4 (all with "one to many" relations)

I need to create a Dataset that includes all these tables and keeps the
realtion

When I use an OLEdb Adapter and generate a dataset (in VS) based on that I
get all the tables' columns in one long dataset and the relations are all
gone.

How do I solve this?

/Lars

[Cor Ligthert]

Hi Lars,

I do not know if you use the join, however there is a bug in that.

http://support.microsoft.com/default...b;en-us;318646

I made a sample with relations for Access.

I hope that will help you a little bit?.
Cor
\\\\
Dim Sql As String = "SELECT * from A, B Where " & _
"A.n = B.n AND A.n = 10"
Dim Conn As New OleDbConnection(connString)
Dim da As New OleDbDataAdapter(Sql, Conn)
da.Fill(ds, "A")
da.Fill(ds, "B")
Conn.Close()
Dim drlA As New DataRelation _
("AA", ds.Tables("A").Columns("A.n"), _
ds.Tables("B").Columns("B.n"))
ds.Relations.Add(drlA)
Dim dv As New DataView(ds.Tables("A"))
DataGrid1.DataSource = dv
DataGrid1.Expand(-1)
ds.WriteXml("mypath", XmlWriteMode.WriteSchema)
End Sub
///

[Lars Netzel]

Can I use the XML file for something after doing this or why do you write
one in the example? Can I rename that one to a *.xsd extention and include
in the project and use somehow?

Also, the relation that shows up in the datagrid... I want to have each
table in the dataset in it's own datagrid.. is that possible?

/Lars


"Cor Ligthert" <no**********@planet.nl> skrev i meddelandet
news:eW**************@TK2MSFTNGP11.phx.gbl...

Hi Lars,

I do not know if you use the join, however there is a bug in that.

http://support.microsoft.com/default...b;en-us;318646

I made a sample with relations for Access.

I hope that will help you a little bit?.
Cor
\\\\
Dim Sql As String = "SELECT * from A, B Where " & _
"A.n = B.n AND A.n = 10"
Dim Conn As New OleDbConnection(connString)
Dim da As New OleDbDataAdapter(Sql, Conn)
da.Fill(ds, "A")
da.Fill(ds, "B")
Conn.Close()
Dim drlA As New DataRelation _
("AA", ds.Tables("A").Columns("A.n"), _
ds.Tables("B").Columns("B.n"))
ds.Relations.Add(drlA)
Dim dv As New DataView(ds.Tables("A"))
DataGrid1.DataSource = dv
DataGrid1.Expand(-1)
ds.WriteXml("mypath", XmlWriteMode.WriteSchema)
End Sub
///

[Cor Ligthert]

Hi Lars,

I said it was a sample I had, in the XML file you can see the relations,

However do you have the resource kit.

With this and the samples for a Master-detail grid you should find
everything in my opinion.
(There are more samples for a Master detail grid in the resource kit)

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing it

http://msdn.microsoft.com/vbasic/vbr...q/#installvdir

I hope this helps a little bit?

Cor

[Ken Tucker [MVP]]

Hi,

http://www.onteorasoftware.com/downloads/multigrids.zip

Ken
-------------------
"Lars Netzel" <la*********@qlogic.se> wrote in message
news:Oq**************@TK2MSFTNGP09.phx.gbl...

I have a VB.NET application based on MS access 2000 db.

I have a 1 to many relation between 4 tables...

tbl1 -> tbl2 -> tbl3 -> tbl4 (all with "one to many" relations)

I need to create a Dataset that includes all these tables and keeps the
realtion

When I use an OLEdb Adapter and generate a dataset (in VS) based on that I
get all the tables' columns in one long dataset and the relations are all
gone.

How do I solve this?

/Lars

[Lars Netzel]

Thank you!

/Lars

"Cor Ligthert" <no**********@planet.nl> skrev i meddelandet
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi Lars,

I said it was a sample I had, in the XML file you can see the relations,

However do you have the resource kit.

With this and the samples for a Master-detail grid you should find
everything in my opinion.
(There are more samples for a Master detail grid in the resource kit)

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing it

http://msdn.microsoft.com/vbasic/vbr...q/#installvdir

I hope this helps a little bit?

Cor

[Lars Netzel]

Thank you!

/Lars

"Cor Ligthert" <no**********@planet.nl> skrev i meddelandet
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi Lars,

I said it was a sample I had, in the XML file you can see the relations,

However do you have the resource kit.

With this and the samples for a Master-detail grid you should find
everything in my opinion.
(There are more samples for a Master detail grid in the resource kit)

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing it

http://msdn.microsoft.com/vbasic/vbr...q/#installvdir

I hope this helps a little bit?

Cor