Solved

Updating one table in a two-table relationship

Posted on 2006-11-09
1
167 Views
Last Modified: 2010-04-23
Hi all,

I have two related tables.
The first table holds member information, the second group information.
The member is part of a group (duh)
On startup, all my controls (unbound) are filled with correct data, and also my datagrid
When I add a new member, the data for the member table is saved, along with the key relating it to the second table.(groupID)
The actual updating is working OK, but immediately after the update, the line in the datagrid holding the info for the new member (row) is all screwed up.
It only shows nulls and second table data.
The datagrid is supposed to show only 1 column of the second table.

memberID | Name | Surname | Date | Group (2nd table)

When I close the app, and restart, the latest added record is displayed OK.

The datagrid is the only bound control. The members table has an autonumber for memberID.

This is my code :

        strSQL = "Select * from tblleden"
        Dim AddLid_DA As New OleDb.OleDbDataAdapter(strSQL, conn)
        Dim AddLid_DS As New DataSet
        Dim AddLid_DT As DataTable
        Dim AddLid_DR As DataRow
        Dim custCB As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(AddLid_DA)
        AddLid_DA.Fill(AddLid_DS, "Lid")
        AddLid_DT = AddLid_DS.Tables("Lid")
        Try
            AddLid_DR = AddLid_DT.NewRow

            AddLid_DR("date") = TextBox13.Text
            AddLid_DR("groupid") = groupID
            AddLid_DR("Name") = TextBox13.Text
            AddLid_DR("SurName") = TextBox14.Text
            AddLid_DT.Rows.Add(AddLid_DR)
            Dim modified As DataRow() = AddLid_DS.Tables("Lid").Select(Nothing, Nothing, DataViewRowState.Added)
            AddLid_DA.Update(modified)
            da.Fill(ds, "Leden") --->ds = the original two-table dataset

Any suggestions?



0
Comment
Question by:JamesBrian
1 Comment
 
LVL 13

Accepted Solution

by:
newyuppie earned 500 total points
ID: 17906352
is there an explicitly constructed relationship in VB NET on the original two-table dataset (ds)? is this dataset what you bind to the datagridview? whats the datagrid datasource and datamember props?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Tabcontrol Caption? 1 29
Code enhancement 5 22
Open a word document 23 33
Help with LINQ and XML 10 26
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now