problem updating database

[dani kotlar]

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

 

[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?

 

[dani kotlar]

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 כתב:

 

[Dave Sexton]

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

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 ???: