473,695 Members | 2,305 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

problem updating database

I use a table adapter to add rows to a database, using Update();
After adding a row to the database and closing the application, if I
run the application again, and call Fill(), I can see the new data, as
if it appears in the database. However, if I open the database itself
in the server browser and view the corresponding table I cannot see the
new data there. Furthermore, after viewing the table in the database,
when I fire the application, and call Fill(), the new data is not there
anymore. The same thing happens if I do refresh to the database in the
server browser window. What Refresh actually does is bring the database
to its older position.
Any idea about what I should do to get the database updated
permanently?

Thanks
Dani

Jan 12 '07 #1
3 1414
Hi Dani,
Any idea about what I should do to get the database updated
permanently?
If after you save the data you can close the application, restart it, call
Fill and see the data, then it is being persisted. Can you restart the
application once again and still see the data without using Server Explorer?

Maybe you're not using Server Explorer correctly and deleting the data,
somehow. What type of database is it?

--
Dave Sexton
http://davesexton.com/blog

"dani kotlar" <da*********@gm ail.comwrote in message
news:11******** **************@ 51g2000cwl.goog legroups.com...
>I use a table adapter to add rows to a database, using Update();
After adding a row to the database and closing the application, if I
run the application again, and call Fill(), I can see the new data, as
if it appears in the database. However, if I open the database itself
in the server browser and view the corresponding table I cannot see the
new data there. Furthermore, after viewing the table in the database,
when I fire the application, and call Fill(), the new data is not there
anymore. The same thing happens if I do refresh to the database in the
server browser window. What Refresh actually does is bring the database
to its older position.
Any idea about what I should do to get the database updated
permanently?

Thanks
Dani

Jan 12 '07 #2
Hi Dave,
Thanks for your answer. You are right, clearly the data is being
persisted. I am using SQL Server Express. As I said, once I view the
table data in the server explorer of visual studio 2005, the data goes
back to its initial position, before it was edited. Can it be some kind
of a bug in Visual studio 2005?
Dani

Dave Sexton כתב:
Hi Dani,
Any idea about what I should do to get the database updated
permanently?

If after you save the data you can close the application, restart it, call
Fill and see the data, then it is being persisted. Can you restart the
application once again and still see the data without using Server Explorer?

Maybe you're not using Server Explorer correctly and deleting the data,
somehow. What type of database is it?

--
Dave Sexton
http://davesexton.com/blog

"dani kotlar" <da*********@gm ail.comwrote in message
news:11******** **************@ 51g2000cwl.goog legroups.com...
I use a table adapter to add rows to a database, using Update();
After adding a row to the database and closing the application, if I
run the application again, and call Fill(), I can see the new data, as
if it appears in the database. However, if I open the database itself
in the server browser and view the corresponding table I cannot see the
new data there. Furthermore, after viewing the table in the database,
when I fire the application, and call Fill(), the new data is not there
anymore. The same thing happens if I do refresh to the database in the
server browser window. What Refresh actually does is bring the database
to its older position.
Any idea about what I should do to get the database updated
permanently?

Thanks
Dani
Jan 14 '07 #3
Hi Dani,

I guess it could be a bug, but I doubt it. Unfortunately, there's not much
anyone can do to help you unless you provide more detail. If you could
define the exact steps that you've taken so that readers can reproduce the
exact problem you are having then you'll get a better response. It's likely
that you'll find the solution yourself in trying to reproduce the problem
for the newsgroups.

--
Dave Sexton
http://davesexton.com/blog

"dani kotlar" <da*********@gm ail.comwrote in message
news:11******** **************@ a75g2000cwd.goo glegroups.com.. .
Hi Dave,
Thanks for your answer. You are right, clearly the data is being
persisted. I am using SQL Server Express. As I said, once I view the
table data in the server explorer of visual studio 2005, the data goes
back to its initial position, before it was edited. Can it be some kind
of a bug in Visual studio 2005?
Dani

Dave Sexton ???:
Hi Dani,
Any idea about what I should do to get the database updated
permanently?

If after you save the data you can close the application, restart it, call
Fill and see the data, then it is being persisted. Can you restart the
application once again and still see the data without using Server
Explorer?

Maybe you're not using Server Explorer correctly and deleting the data,
somehow. What type of database is it?

--
Dave Sexton
http://davesexton.com/blog

"dani kotlar" <da*********@gm ail.comwrote in message
news:11******** **************@ 51g2000cwl.goog legroups.com...
I use a table adapter to add rows to a database, using Update();
After adding a row to the database and closing the application, if I
run the application again, and call Fill(), I can see the new data, as
if it appears in the database. However, if I open the database itself
in the server browser and view the corresponding table I cannot see the
new data there. Furthermore, after viewing the table in the database,
when I fire the application, and call Fill(), the new data is not there
anymore. The same thing happens if I do refresh to the database in the
server browser window. What Refresh actually does is bring the database
to its older position.
Any idea about what I should do to get the database updated
permanently?

Thanks
Dani

Jan 14 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
2618
by: Frnak McKenney | last post by:
I'm using an in-core DataSet as an image of my application's 'database' (a multi-table Access97 mdb file). Updates are made to the DataTables within the DataSet via forms with bound TextBoxes, then written to the database... or at least that's what's supposed to be happening. Unfortunately, I've discovered that while it appears that when I create a new record/row I'm successfully updating the Access database, once the Update is...
1
2103
by: Steven Blair | last post by:
Hi, Here is a short decsription of my problem. I have written a dll for Database accessing. I have one method which can return a Dataset and another method which takes a Dataset and upates a Database. (Disconnected Datasets). The problem I have is a new SqlAdapter is required before updating the Database: Therefore, to allow the update I have to do the following:
1
1661
by: delta7 | last post by:
Hi, I'm new to C sharp and currently writing a small program that uses an Access 2003 database. I am currently having a problem when updating a row that includes numeric data. When updating just the text fields in the row everything works fine with the following command:
5
2029
by: junglist | last post by:
Hi guys, I've been trying to implement an editable datagrid and i have been succesful up to the point where i can update my datagrid row by row. However what used to happen was that once i updated one row, all of them were updated so i immediatelly figured out that i have to include the id of every entry in the update statement. This is where the problem is raised. My database is an Access database. The table i am updating contains a Date...
14
2122
by: Lars Netzel | last post by:
A little background: I use three Datagrids that are in a child parent relation. I Use Negative Autoincrement on the the DataTables and that's workning nice. My problem is when I Update these grid and write to the database and I set the new Primary Keys and related Fields to the new asigned atuonumbers in the Access.
2
4550
by: Mike Collins | last post by:
I cannot get the correct drop down list value from a drop down I have on my web form. I get the initial value that was loaded in the list. It was asked by someone else what the autopostback was set to...it is set to false. Can someone show me what I am doing wrong and tell me the correct way? Thank you. In the page load event, I am doing the following:
31
2439
by: Lag | last post by:
Having a problem updating my database from a web page, through a submission form. Can anyone help? ----THIS IS MY CODE IN update.php----(user, pass, and database are typed in directly, I changed them here for securiy reasons :) ) <?php /*---CONNECT TO DATABASE---*/
1
2031
by: r2destini | last post by:
Hi Friends, I am new to .Net. So I don't know much. I am facing a problem in updating database through ADO.Net I am creating the dataset and there is no problem in the updation and deletion or insertion in the dataset but when I am updating the
5
2611
by: Brad Baker | last post by:
I'm trying to write a simple asp.net page which updates some data in a SQL database. At the top of the page I have the following code: <%@ Page Language="C#" Debug="true" %> <%@ import namespace="System.Data" %> <%@ import namespace="System.Data.SqlClient" %> <script language="c#" runat="server"> public void Page_Load(object sender, EventArgs e) {
11
6062
by: SAL | last post by:
Hello, I have a Gridview control (.net 2.0) that I'm having trouble getting the Update button to fire any kind of event or preforming the update. The datatable is based on a join so I don't know if that's what's causing the behavior or not. It seems like the Update button should at least do something. When the Edit button is clicked, the grid goes into Edit mode and the Cancel button takes the grid out of Edit mode. So, I don't get what...
0
8631
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look ! Part I. Meaning of...
0
8572
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9115
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8984
jinu1996
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...
0
8825
tracyyun
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...
1
6491
isladogs
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...
0
4340
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4579
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3003
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.