I am new to database work. I have a very simple database with only two
tables linked by a 1:1 relationship. I've read the tables contents into a
dataset and bound the two tables to textbox controls on a form. Using a
BindingNavigator I can cursor through the data. However, I don't understand
how to properly update new data entered within my form. I was able to get
the parent table to update correctly but never the child table. Fact is, I
keep losing the new child data entered into my form as I cursor through the
othter entries. Can someone point me to a clear example of how to update
Access tables with changes made to both the parent and linked child table?
--
-----------
Thanks,
Steve 3 1471
Hi Steve,
Thanks for your post!
Do you use BindingNavigator to change the current index of the parent table
databinding? Normally, each datasource will have each own current binding
index, so your child table and parent table will have a different binding
index.
If you setup the databinding correct, the .Net winform code will take care
of the datasource updating, you should not have such problem.
Is it possible for you to create a little sample project to demonstrate
your problem? For simplicity's sake, you'd better get rid of the database
dependency in your sample project and fill the datasource tables
programmatically with .Net code.
You may attach the sample project in the further reply. Thanks!
Best regards,
Jeffrey Tan
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
I'll try to put something together. In the mean time, do you know of any
examples that demonstrate what I'm trying to do?
--
-----------
Thanks,
Steve
""Jeffrey Tan[MSFT]"" wrote: Hi Steve,
Thanks for your post!
Do you use BindingNavigator to change the current index of the parent table databinding? Normally, each datasource will have each own current binding index, so your child table and parent table will have a different binding index.
If you setup the databinding correct, the .Net winform code will take care of the datasource updating, you should not have such problem.
Is it possible for you to create a little sample project to demonstrate your problem? For simplicity's sake, you'd better get rid of the database dependency in your sample project and fill the datasource tables programmatically with .Net code.
You may attach the sample project in the further reply. Thanks!
Best regards, Jeffrey Tan Microsoft Online Community Support ================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Steve,
Ok, I will wait for your sample project.
Currently, I can not find a specific sample based on your requirement, so I
want to work with you on it to find out the problem. Thanks.
Best regards,
Jeffrey Tan
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: BStorm |
last post by:
I ran into a maddening bug that I finally tracked down to Microsoft's Data
Access Blocks. It is in the SQL Helper UpdateDataSet method as follows:
Microsoft Code:
#region UpdateDataset
public...
|
by: LP |
last post by:
Hello,
In the past I used SqlCommandBuilder and SqlDataAdapter .Update method to
apply changes in a DataTable back to its table source in SQL Server. It
worked fine when DataSet had only 1...
|
by: M. David Johnson |
last post by:
I cannot get my OleDbDataAdapter to update my database
table from my local dataset table. The Knowledge Base
doesn't seem to help - see item 10 below.
I have a Microsoft Access 2000 database...
|
by: Jonathan Upright |
last post by:
Greetings to anyone who can help:
I'm using WebMatrix to make ASP.NET pages, and I chose the "Editable
DataGrid" at the project selector screen. As you may know, it defaults
to the Microsoft...
|
by: jaYPee |
last post by:
I have search a lot of thread in google newsgroup and read a lot of
articles but still i don't know how to update the dataset that has 3
tables.
my 3 tables looks like the 3 tables from...
| |
by: graham |
last post by:
Hi all,
<bitching and moaning section>
I am asking for any help I can get here... I am at the end of my tether... I
don;t consider myself a genius in any way whatsoever, but I do believe I
have...
|
by: Richard |
last post by:
Hi,
I have 1 dataset with 2 tables (Table1 as parent, Table2 as Child), 1 row in
both the tables.
I am updating it with a transaction. First parent then child.
When child update fails, it raise...
|
by: RSH |
last post by:
Hi,
I have a situation in where i have two instances of SQL server, the first is
our Production Environment, the second is our Development environment. Both
servers contain the same databases...
|
by: Stephen Plotnick |
last post by:
I have two events in the same program that executes the same sub rountine;
one is from a menu item the other is from a button.
THe button works perfectly and the menu item does not. See the code...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |