multiple table in datagrid

[Thanks]

I meet a system.ArgumentException: cannot create a child list for field x.

my coding as follow

Dim cn As SqlConnection
Dim da As SqlDataAdapter, da1 As SqlDataAdapter
Dim ds As DataSet

Try

cn = New SqlConnection(str)
cn.Open()

da1 = New SqlDataAdapter("select id,Name from x", cn)

da = New SqlDataAdapter("select id,Code from y", cn)

ds = New DataSet

da1.Fill(ds, "x")
da.Fill(ds, "y")

ds.Relations.Add("z", _
ds.Tables("x").Columns("id"), _
ds.Tables("y").Columns("id"))

Me.mygrid.DataSource = ds.Tables("x")
Me.mygrid.DataMember = "x.z"

Catch e As Exception
MessageBox.Show(e.ToString)
Finally
cn.Close()
End Try

What's wrong of my coding? I would like to remove the error message ...

Thanks

[Ken Tucker [MVP]]

Hi,

When you bind to a datareleation you need to use setbinding. Here
is an example.

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

Ken
-------------------------
"Thanks" <Th****@discussions.microsoft.com> wrote in message
news:C6**********************************@microsof t.com...

I meet a system.ArgumentException: cannot create a child list for field x.

my coding as follow

Dim cn As SqlConnection
Dim da As SqlDataAdapter, da1 As SqlDataAdapter
Dim ds As DataSet

Try

cn = New SqlConnection(str)
cn.Open()

da1 = New SqlDataAdapter("select id,Name from x", cn)

da = New SqlDataAdapter("select id,Code from y", cn)

ds = New DataSet

da1.Fill(ds, "x")
da.Fill(ds, "y")

ds.Relations.Add("z", _
ds.Tables("x").Columns("id"), _
ds.Tables("y").Columns("id"))

Me.mygrid.DataSource = ds.Tables("x")
Me.mygrid.DataMember = "x.z"

Catch e As Exception
MessageBox.Show(e.ToString)
Finally
cn.Close()
End Try

What's wrong of my coding? I would like to remove the error message ...

Thanks

[Thanks]

Hi ken

Thanks for your web site. After adding the setdatabinding, the
system.ArgumentException still exist ... no luck!

Me.mygrid.SetDataBinding(ds, "x")
Me.mygrid.SetDataBinding(ds, "y")
Me.mygrid.SetDataBinding(ds, "x.z")

Actually, after showing the system.ArgumentException, my datagrid can show
the data records that I want ... but I dont want the error message ...

any idea?
Thanks

"Ken Tucker [MVP]" wrote:

Hi,

When you bind to a datareleation you need to use setbinding. Here
is an example.

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

Ken
-------------------------
"Thanks" <Th****@discussions.microsoft.com> wrote in message
news:C6**********************************@microsof t.com...

I meet a system.ArgumentException: cannot create a child list for field x.

my coding as follow

Dim cn As SqlConnection
Dim da As SqlDataAdapter, da1 As SqlDataAdapter
Dim ds As DataSet

Try

cn = New SqlConnection(str)
cn.Open()

da1 = New SqlDataAdapter("select id,Name from x", cn)

da = New SqlDataAdapter("select id,Code from y", cn)

ds = New DataSet

da1.Fill(ds, "x")
da.Fill(ds, "y")

ds.Relations.Add("z", _
ds.Tables("x").Columns("id"), _
ds.Tables("y").Columns("id"))

Me.mygrid.DataSource = ds.Tables("x")
Me.mygrid.DataMember = "x.z"

Catch e As Exception
MessageBox.Show(e.ToString)
Finally
cn.Close()
End Try

What's wrong of my coding? I would like to remove the error message ...

Thanks

[Thanks]

I sorted out the problem. Thanks ken

"Thanks" wrote:

Hi ken

Thanks for your web site. After adding the setdatabinding, the
system.ArgumentException still exist ... no luck!

Me.mygrid.SetDataBinding(ds, "x")
Me.mygrid.SetDataBinding(ds, "y")
Me.mygrid.SetDataBinding(ds, "x.z")

Actually, after showing the system.ArgumentException, my datagrid can show
the data records that I want ... but I dont want the error message ...

any idea?
Thanks

"Ken Tucker [MVP]" wrote:

Hi,

When you bind to a datareleation you need to use setbinding. Here
is an example.

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

Ken
-------------------------
"Thanks" <Th****@discussions.microsoft.com> wrote in message
news:C6**********************************@microsof t.com...

I meet a system.ArgumentException: cannot create a child list for field x.

my coding as follow

Dim cn As SqlConnection
Dim da As SqlDataAdapter, da1 As SqlDataAdapter
Dim ds As DataSet

Try

cn = New SqlConnection(str)
cn.Open()

da1 = New SqlDataAdapter("select id,Name from x", cn)

da = New SqlDataAdapter("select id,Code from y", cn)

ds = New DataSet

da1.Fill(ds, "x")
da.Fill(ds, "y")

ds.Relations.Add("z", _
ds.Tables("x").Columns("id"), _
ds.Tables("y").Columns("id"))

Me.mygrid.DataSource = ds.Tables("x")
Me.mygrid.DataMember = "x.z"

Catch e As Exception
MessageBox.Show(e.ToString)
Finally
cn.Close()
End Try

What's wrong of my coding? I would like to remove the error message ...

Thanks