database under query analyser of win mobile 5.0 emulator
-
I am a begineer in C#.net I have created a .sdf database in C# project of Visual Studio 2008. I have used microsoft SQL server compact 3.5 as a data source. I have set the copy to output directory property of that database as copy if newer. I have one table created under that database in VS 2008. When i run the application for the first time the database gets copied in the Query Analyser of Win mobile 5.0 emulator and i could see the table undet it. But when i add more table to the same database in C# project and then run the application once again, i could not see the newly added tables. Another problem i am facing is that the database in win mobile 5.0 emulator gets corrupted very often. What is the reason? I am losing my data due to this. I have SQL server management studio installed on my pc. I want to create a SQL server mobile database under it and then add that database to my project. Which data source i have to chose? What are the steps to be followe? What is the difference in using the database created in Query analyser and the database craeted in SQL server mobile? Thank in advance
-
I am a begineer in C#.net I have created a .sdf database in C# project of Visual Studio 2008. I have used microsoft SQL server compact 3.5 as a data source. I have set the copy to output directory property of that database as copy if newer. I have one table created under that database in VS 2008. When i run the application for the first time the database gets copied in the Query Analyser of Win mobile 5.0 emulator and i could see the table undet it. But when i add more table to the same database in C# project and then run the application once again, i could not see the newly added tables. Another problem i am facing is that the database in win mobile 5.0 emulator gets corrupted very often. What is the reason? I am losing my data due to this. I have SQL server management studio installed on my pc. I want to create a SQL server mobile database under it and then add that database to my project. Which data source i have to chose? What are the steps to be followe? What is the difference in using the database created in Query analyser and the database craeted in SQL server mobile? Thank in advance
hello, The reason for the database to get corrupted is that if your database is connected from the sql server and if you try to modify it from other location like (query analyzer in WM). Well about the database not being updated.. i too have not much idea. I faced the same problem..All i did was i made modification for the sql server and then replaced the old one in the mobile....