I imported an Access database, created a dataset, added a
bindingsource; and have been happily coding away - couldn't be easier.
My problems started when I added a column to the database - I can't
find a way to tell Visual Studio to "resync" the imported dataset and
the external DB!
I tried deleting the dataset, Visual Studio just crashed. Attempted to
create another Dataset, discovered it crashed in the middle of an
operation, and spent an hour manually cleaning up designer-generated
code and non-existent references then tried again - I was able to
create the dataset this time just fine.
It occured to me to change the column later on (from text to memo),
and what do you know: when I tried to delete the old dataset, VS
crashed *yet again!*
I've given up on VS on Vista, just too damn buggy - but I was
wondering if anyone knows a way of kicking-off an update or resync
sequence for an ADO.NET object(s) like the table adapter and dataset?
Thanks. 2 2515
Unfortunately, the way that you are doing it is exactly the way I would
referesh the designer generated code. You should be able to delete the
table from the data set, and then re-add it.
Can you post the access file, as well as a complete solution that shows
where it crashes? I've used the data designer a number of times doing just
this (against SQL databases, not access) and haven't had this problem.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m
"Computer Guru" <Co**********@N eoSmart.netwrot e in message
news:11******** *************@g 4g2000hsf.googl egroups.com...
>I imported an Access database, created a dataset, added a
bindingsource; and have been happily coding away - couldn't be easier.
My problems started when I added a column to the database - I can't
find a way to tell Visual Studio to "resync" the imported dataset and
the external DB!
I tried deleting the dataset, Visual Studio just crashed. Attempted to
create another Dataset, discovered it crashed in the middle of an
operation, and spent an hour manually cleaning up designer-generated
code and non-existent references then tried again - I was able to
create the dataset this time just fine.
It occured to me to change the column later on (from text to memo),
and what do you know: when I tried to delete the old dataset, VS
crashed *yet again!*
I've given up on VS on Vista, just too damn buggy - but I was
wondering if anyone knows a way of kicking-off an update or resync
sequence for an ADO.NET object(s) like the table adapter and dataset?
Thanks.
On Jul 31, 5:51 pm, "Nicholas Paldino [.NET/C# MVP]"
<m...@spam.guar d.caspershouse. comwrote:
Unfortunately, the way that you are doing it is exactly the way I would
referesh the designer generated code. You should be able to delete the
table from the data set, and then re-add it.
Can you post the access file, as well as a complete solution that shows
where it crashes? I've used the data designer a number of times doing just
this (against SQL databases, not access) and haven't had this problem.
--
- Nicholas Paldino [.NET/C# MVP]
- m...@spam.guard .caspershouse.c om
"Computer Guru" <ComputerG...@N eoSmart.netwrot e in message
news:11******** *************@g 4g2000hsf.googl egroups.com...
I imported an Access database, created a dataset, added a
bindingsource; and have been happily coding away - couldn't be easier.
My problems started when I added a column to the database - I can't
find a way to tell Visual Studio to "resync" the imported dataset and
the external DB!
I tried deleting the dataset, Visual Studio just crashed. Attempted to
create another Dataset, discovered it crashed in the middle of an
operation, and spent an hour manually cleaning up designer-generated
code and non-existent references then tried again - I was able to
create the dataset this time just fine.
It occured to me to change the column later on (from text to memo),
and what do you know: when I tried to delete the old dataset, VS
crashed *yet again!*
I've given up on VS on Vista, just too damn buggy - but I was
wondering if anyone knows a way of kicking-off an update or resync
sequence for an ADO.NET object(s) like the table adapter and dataset?
Thanks.- Hide quoted text -
- Show quoted text -
That's certainly a shame :-(
I haven't seen this particular issue before either; I'll create a new
solution and see if I can get it to happen there (the current solution
can't exactly be released :-)
I just reproduced it again for the hell of it - it's becoming a real
pain and happens each and every time I delete the dataset.
Thanks. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: PAUL EDWARDS |
last post by:
I have a windows form that is bound to a datatable. In VB6
I could just update the field contents and it would be
updated in the database, however if I update the text
property of the control from code it is 50% chance that
the update will make it back to the dataset. If I update
the dataset instead of the form, it does not show on the
form.
Is there a method that should be used?
|
by: Zlatko Matiæ |
last post by:
When working in .adp there is a peculiar Resync command property in forms.
I have noticed that I can avoid resync when putting stored procedures as
record source instead of views or in-line functions. Also, it seems that I
van't use resync with stored procedures...
As I couldn't find much informations in literature, can anybody familiar
with Access Projects give a comment about it and when Resync command should
be used ?
Thanks.
|
by: shumaker |
last post by:
The documentation for the resync method shows that it can work with a
"Record" object. How do I get just the current record displayed in a
form?
CurrentRecord returns a long number, not an actual object. Anyone know
of a method that allows me to use this number to index into a recordset
and get an actual Record object that I can call resync on?
|
by: Babu Mannaravalappil |
last post by:
Can somebody please help me figure out why the following method
exceptions out?
Execution at the line marked with ********** hangs for about 15
seconds and then I get an error that says an Unhandled
StackOverFlowException occurred. The execution does not even get
passed to the catch block. At the time of my test, only one of 12
tables in the dataset (catalogsDS) really has changes. The dataset is
not a huge one. Most tables have less...
|
by: Mojtaba Faridzad |
last post by:
Hi,
Please check these lines:
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet, "mytable");
DataRow row;
row = dataSet.Tables.Rows;
row.BeginEdit();
row = "555";
| |
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 northwind database that has
an employees, orders, and order details.
the following are the 3 tables in my sql database
students
schyrsem
|
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 an exception, and rollback the parent
update. But it also change the rowstate of the parent row from Added to
unchanged
When you try to save again parent row never get created in database. So
child update will fail again.
Please suggest what am I...
|
by: PAUL |
last post by:
Hello,
I have 2 tables with a relationship set up in the dataset with vb
..net. I add a new record to the parent table then edit an existing child
record to have the new parent ID. However when I do the update the changed
parentid in the child table fails to change. No error is given its just that
the change is not written to the Database.
When I step through the records for the child table the one I would expect
to be changed has a row...
|
by: Zorpiedoman |
last post by:
I keep getting a concurrency exception the second time I make a change and
attempt to update a dataadapter. It appears this is by design, so there must
be something I can do to avoid it.
Example:
I have a dataadapter that contains one table with one row. I change the
value of the 'FisrtName' column in that row from Jack to John. I call
..update on the dataadapter it goes through fine. Now I change that same
column in that same row...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |