c# - Database file .sdf does not update after closing application ...

Question

4.00/5 (1 vote)

See more:

I am developing a C# application with a .sdf database, I have SELECTs, UPDATEs and INSERTs, and all they work while I'm compiling the application.

I mean, I add, delete and modify records, and it works okay i can play with all my information while the app is running. BUT if I close the app and after it, I run it again, all the data is like in the begining, there's not any change in my DB.sdf

It looks like if all my changes were on the RAM memory or something like that...

This is my UPDATE code:

SqlCeConnection connDisp = new SqlCeConnection();
                    connDisp.ConnectionString = ("Data Source =" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)) + "\\ACB.sdf;Password=acaf;Persist Security Info=False;");
                    try
                    {
                        connDisp.Open();
                        StringBuilder query = new StringBuilder();
                        SqlCeCommand comm = new SqlCeCommand();
                        
                        query.Append("UPDATE ACCT SET NPL ='0004',MODO='M' WHERE NUVO='00003' AND NUIA= '01' AND NUPO= '00700' AND SMCT='000' ");
                        comm.CommandText = Convert.ToString(query);
                        
                        comm.Connection = connDisp;
                        comm.ExecuteNonQuery();
                        comm.Dispose();
                        this.Refresh();
                        connDisp.Close();
                    }
                    catch (SqlCeException exce)
                    {
                        MessageBox.Show("Exception: "+exce.Message);
                    }

**Any idea about Why I can't write on my .sdf database?**
I've visited lots of blogs but anyone helped me.
Is it wrong if I ask for a demo mobile app?

Hope somebody help me
Thank You..

Posted 5-Feb-14 12:26pm

Ripoll_Ionn

Add a Solution

Comments

CHill60 5-Feb-14 18:52pm

Not sure about this ... have you got multiple copies of the database ... have a look in your debug and release folders for example. Or if the database is in a "protected" folder (e.g. Program Files) then it will have been virtualised.

Ripoll_Ionn 5-Feb-14 19:05pm

I have just 1 database, but as far as I know, when I compile my app, my database is copied to my bin\debug foler. Isn't it?

But I think it's not the problem because I made the app, and I installed it on my windows mobile.. -And my app is on C:\Users\Myuser\- and The problem continues...

Another idea?

TnTinMn 5-Feb-14 19:45pm

When you created the datasource, did you click Yes when prompted by this dialog?
---------------------------
Microsoft Visual Studio
---------------------------
The connection you selected uses a local data file that is not in the current project. Would you like to copy the file to your project and modify the connection?
---------------------------
Yes No Help
---------------------------

This is a common issue when people say their changes when running under VS are not persisting. If you did, you will see the database file in the Solution Explorer. Check the properties of the file. Most likely "Copy To Output" is set to "Copy Always"; change it to "Copy If Newer".

Ripoll_Ionn 6-Feb-14 10:14am

I saw it, It says "Copy if newer"... In Build action section, it says "content"...

TnTinMn 6-Feb-14 19:37pm

"I mean, I add, delete and modify records, and it works okay i can play with all my information while the app is running. BUT if I close the app and after it, I run it again, all the data is like in the begining, there's not any change in my DB.sdf"
Does this mean that you have pulled the modified data and show the the modified table in the UI or does it just mean that nothing crashed?

Ripoll_Ionn 11-Feb-14 18:37pm

Yes, all the information was manipulated as I wanted and in environment was displayed correctly; If I edited a record, after updating the information, the record is displayed with the changes made, if I eliminated one more, and after upgrading my screens that record didn't appear

But after stopping the application and pressing F5... Surprise! looked like it had not been removed and / or modified any record

TnTinMn 11-Feb-14 20:38pm

I am a bit confused as I'm sure you are with this. One thing that I am going to recommend is that do not build the connection string path every place you need it as that can be a source of errors (not saying that that is the cause of your current problem). Add a project property setting of type connection string and use that when needed. Do not include the password as part of the stored string; you can append that at startup.

i.e.: Data Source=|DataDirectory|Northwind.sdf

Make sure you set the DataDirectory for the application before any calls are made that will need the path
i.e: AppDomain.CurrentDomain.SetData("DataDirectory", Application.StartupPath);

The only way I have been able to recreate your issue is by using a dataset and editing it between runs. This seems to force VS to copy the original DB to the output directory even if it is older.

You could also try setting "Copy To Output" to "Do Not Copy"; just make sure that you have a copy in the output directory and see if that resolves the issue.

I'm sorry, but I really do not know what else to recommend at this point.

Good Luck.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ripoll_Ionn · Answer 1 · 2014-02-17T10:49:00

I finally understand what happened with this topic.

When I run my application, my database was selected from my root, but when It was compiled, my database was moved to \bin\bd.sdf

So, all my updates and deletes were done BUT ON MY bin\database.sdf.

I closed the applicatión and after I want to compile it again, the full \bin\db.sdf was replaced with my first one.

And this was like "cycled".

In conclusion: I just had to watch where the database was taken, and where the changes were made in it..

My codeline are OK.

Thank You guys!

c# - Database file .sdf does not update after closing application ...

1 solution

Solution 1

Add your solution here

Preview 0

c# - Database file .sdf does not update after closing application ...

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us