Insert and update doesn't change database (sdf)

Question

I have a problem with saving data to database named Settings.sdf. I have few files:

- Settings.sdf
- SettingsDataSet.xsd
 - SettingsDataSet.Designer.cs
 - SettingsDataSet.xsc
 - SettingsDataSet.xss

If I tried use UPDATE or INSERT INTO queries I would not update my database (Settings.sdf), only change data in cache file (whatever and wherever it is). I'm using correctly all SqlCeCommands. For example:

string conString = "Data Source=Settings.sdf";
con = new SqlCeConnection(conString);
con.Open();
...
using (SqlCeCommand com = new SqlCeCommand("UPDATE Settings SET [Value] = (@loc) WHERE [Key] = 'Location'", con))
{
    com.Parameters.AddWithValue("@loc", device.Location);
    com.ExecuteNonQuery();
}
...
con.Close();

How manage this problem? Why this command doesn't update directly my database?

svick · Accepted Answer · 2012-08-22 18:03:13Z

1

You can adjust your database path, you must set full path:

Adjust with:

string conString = "Data Source=" + Path.Combine(Your full path,"Settings.sdf");`

Add ; at the end of your query

using (SqlCeCommand com = new SqlCeCommand("UPDATE Settings SET [Value] = (@loc) WHERE [Key] = 'Location';", con))
{
...
}

edited Aug 22, 2012 at 18:03

svick

247k54 gold badges405 silver badges535 bronze badges

answered Aug 22, 2012 at 12:03

Aghilas Yakoub

29k5 gold badges49 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Aghilas Yakoub Over a year ago

add ; in the end of your query

Fka Over a year ago

I'm using WPF so it's bad to add Windows.Forms references. I can't use Application.StartupPath. The ';' at the end of the query is not necessery, but I've tried to use it and still nothing.

Jean Over a year ago

I have the same problem, but I added ; and

using (SqlCeCommand com = new SqlCeCommand("UPDATE Settings SET [Value] = (@loc) WHERE [Key] = 'Location';", con)) { ... }

but It doesn't work... Another idea?

Akrem · Accepted Answer · 2012-08-22 12:52:48Z

0

the changed maded in the sdf file in debug directory but when you run again the sdf will be created again, remove the create always and test again

answered Aug 22, 2012 at 12:52

Akrem

4,6628 gold badges39 silver badges64 bronze badges

Collectives™ on Stack Overflow

Insert and update doesn't change database (sdf)

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related