Click here to Skip to main content
15,888,351 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
sir......

actually i am creating a desktop application for practice paper set for any compition exam....
in witch he wants that he create the question on his own system after instoling .exe and after that he give same exe to students for solving these question after writing in cd........

i think this is non technical consept but if .exe file's database update from that system where it is instol than it can be possible....
Posted

1 solution

That depends on what kind of database you used for your application. There are 2 kinds of database here I want to notice:

1. File-based database, this is very easy to update, just copy and paste to the correct location, examples of these are Access database file (*.mdb), SQLite (*.sdb or any, the extension is not restricted), SQL Server CE (*.sdf),...

2. Service-based database, this is a little trickier, you have to remove the old database, attach the new one to the server, or using restore function (if the updated database file is a backup), or if your application supports connecting to multi databases, just create a new connection to attach the updated database. Examples of these are MS SQL Server (*.mdf and the log file with *.ldf), MySQL, Oracle, ...


I suppose your updated database has the same structure to the old one. (it means the update inludes only new data, not involving new structure).
 
Share this answer
 
v2

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900