请问如何获取从表的值?
Private Sub jtcy_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim ds As New DataSet
Dim name As New SqlClient.SqlDataAdapter()
Dim jtcy As New SqlClient.SqlDataAdapter()
Dim conn As New SqlClient.SqlConnection()
Dim name1 As New DataTable()
Dim jtcy1 As New DataTable()
ds.Tables.Add(name1)
ds.Tables.Add(jtcy1)
conn.ConnectionString = "Data Source=HTTP-FDE23E1CB8\TD163; Initial Catalog=td;user id=sa;password=''"
name.SelectCommand = New SqlClient.SqlCommand("select id,姓名,所属部门,职位,入职日期 from name", conn)
jtcy.SelectCommand = New SqlClient.SqlCommand("select id,iid,职工姓名,成员姓名,关系,所在单位 from 家庭成员", conn)
conn.Open()
name.Fill(name1)
jtcy.Fill(jtcy1)
conn.Close()
Dim rltor As DataRelation
rltor = New DataRelation("name_to_jtcy", name1.Columns("id"), jtcy1.Columns("iid"))
ds.Relations.Add(rltor)
DataGridView2.DataSource = name1
DataGridView1.DataSource = name1
DataGridView1.DataMember = "name_to_jtcy"
Me.TextBox1.DataBindings.Add("text", ds.Tables(0), "id")
Me.TextBox2.DataBindings.Add("text", ds.Tables(0), "姓名")
Me.TextBox5.DataBindings.Add("text", ds.Tables("家庭成员"), "id")'请问这里如何点击从来行后获取从表“家庭成员”的ID值? End Sub