|
Hi,
I need to pull some table from SQL server; some are for read-only purposes while others will be both for reading and writing. I need to put these tables on laptops which do not have SQL server installed. I was thinking of storing them in XML files. My questions are:
1. What is the best way to store the tables on laptops for application to use? These tables will need to be synchronized with the main server once connectivity is available.
2. I know for pocket pcs there is pull and push mechanism available. What kind of mechanism should I use in my case?
3. What precautions should I take or things I should be aware of for such a project?
Thanks in advance.
|
|
|
|
|
Hi,
1. I believe you have several options. Some of those are:
- use SQL Server compact edition on laptop. This way you have full database engine on laptop and you can use it as the normal database. In this case you can use replication between master and replicant database and no custom code is needed in order to transfer data between databases.
- save the tables as datasets directly using datasets WriteXml method. This is an easy way to serialize the data. Remember to store if rows are modified on laptop (don't accept changes until you get the data back to the server).
2. This depends on your solution. If you're meaning replication done using SQL Server, pull may be easier to implement but on the other hand it's not necessarily as secure as push.
3. - First of all security. How can get the data to laptop and which laptop. How and where the data is stored in laptop (root of C-drive may not be the best option ). Is the data encrypted and so on.
- modifications. If the data can be modified only in one place, you must implement logic how to prevent modifications in other places. For example if data is on the laptop, can it be updated at the server...
- Simultaneous modifications. If the data can be updated anywhere, you will end up to conflicts. This happens when data is modified in two places separately. When the data is combined from laptop to the server and the server is not in original state (as the data was when it was taken to laptop), what is the right conclusion (there's no obvious answer to this). Perhaps, the lates is correct or combination of both updates or so on... This is typically the most challenging issue in this kind of project...
Hope this helps you,
Mika
|
|
|
|
|
Mika,
Thanks.
I am going ahead and storing them as xml on the lap top. No two people will modify the same table but read from the same tables which rarely change--this makes things a lot easier.
Why not on the root of C drive? I don't understand. Then where is the best option?
|
|
|
|
|
Glad it helped you.
You should always consider security of the data when storing it to the hard drive, especially if the data is confidential in any way (actually you should consider this point always, even with memory operations).
Few things to start with:
- root of C-drive is visible to every user so the data is also
- user's own home directory is typically visible only to the user and people with administrative rights
- it's not a good practice to store files at root level, organize them in folders, preferrably named after the application.
Mika
|
|
|
|
|
Great thanks for the help. Very good and clear answer!
|
|
|
|
|
In both VS 2005 and 2008, it seems it is impossible to edit the contents of a template (at least a FormView template and a LogIn template inside a Master Page content container) in true WYSIWYG mode, because the width of the templates while they are being edited has no relationship to what they really look like. Example: put a Login Control inside a container in a Master Page. Grab the right side of the control and drag it. The width box shows that you are changing its size, but the size on the screen stays the same after you release the mouse. If you look at the page when not in edit mode, the control width will be what he width box says.
Is this a VS "feature" or is there some setting I have wrong?
|
|
|
|
|
Hi folks,
because I have a question. How can I create a certification request with .net-framework?
Regards Wolfgang
|
|
|
|
|
whaese wrote: How can I create a certification request with .net-framework?
There is not enough context. What sort of certification are you talking about?
|
|
|
|
|
Hello,
thank you for your interest. I'm trying a certification request PKCS#10 as ASN.1-data to create. The content and structure is in the relevant documents of the RSA. But how can I do this in .Net-Framework?
Regards
Wolfgang
|
|
|
|
|
Hi,
I am switching from VS 2005 to VS 2008. Till now we are using VSS that come with Visual Studio 6.0 as a Version Control.
I heard VS 2008 having inbuilt VSS feature, but after installing i did not get any option to create VSS project or connect to VSS Project.
Any one having idea/tutorial/link, that would be great help.
Thanks
Binod K.
(Miles to go before I sleep)
|
|
|
|
|
I don't know if it will connect to VSS 6.0. It will connect to VSS 2005. Perhaps it is time to upgrade.
There are no built in VSS features in VS 2008.
|
|
|
|
|
Use subversion instead.
I've used VSS 2005 and I didn't like it at all. I don't know why, but it was slow and prone to problems.
Subversion is free, fast and so far I only have good words for it.
If you haven't, you should check latest poll, it's about source and version control software.
|
|
|
|
|
Hi everyone,
I am not sure if I am on the right board, but I have an library written in .NET 2.0 which should be amended into a .NET 1.1 application.
Is there any way of doing this? I've tried to add as reference, load assembly and create a application domain to load this assembly but always the same error: Bad image file.
I believe that the best shot would be trying to create an application domain in .NET 2.0 and then load the assembly, but I couldn't force the application domain to use .net 2.0. Any other suggestion?
NOTE that I am using a valid .NET 2.0 assembly file, the problem is that the framework 1.1 does not recognise the file.
Cheers
|
|
|
|
|
Hi,
can't be done AFAIK. A process can only load assmeblies a single .NET version.
You'll have to up/downgrade everything to the same version.
|
|
|
|
|
I am not sure how the IIS works but I thought it would possible because that's the basic concept behind it (running different framework applications in the same process)
Quite sad news indeed.
|
|
|
|
|
Why don't you upgrade your application to .Net 2.0? It's always backward compatible you see.
|
|
|
|
|
You might be able to specify which framework should be used for the executable in a manifest file or something. However, it would not be able to work with Visual Studio integration of the controls/forms.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios
Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com
|
|
|
|
|
Hello all,
I need to know if a particular timer handler is already registered with a timer. I am using System.Windows.Forms.Timer.
Thanks
Sushma
|
|
|
|
|
Sushma K wrote: I need to know if a particular timer handler is already registered with a timer. I am using System.Windows.Forms.Timer.
And you thought we would know?
led mike
|
|
|
|
|
How about iterating through the Timer.Events property, using Delegate.Equals()
to compare each with your delegate?
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Hi,
if the only reason you want to know is to avoid you add it again, then first remove it (this
does not harm if it was not there to begin with), hence:
event-=handler;
event+=handler;
|
|
|
|
|
Hi Team,
I have created a application in Visual Studio 2005.Its a Simple application with one master page and some static pages and I have Deployed this appication on server. But i am getting this error
"The codefile attribute on the page directive is not allowed in this page."
I am not getting why i am getting this error.
Please reply me.
I need to run the application as soon as possible.
Thanks and Regards
Avesh Agarwal
|
|
|
|
|
|
Hi,
I am using an unmanaged DLL in my code and am running into problems because it is difficult to get the structures in the DLL to reset their state properly.
If I put the DLL in an AppDomain and unload the AppDomain, will that release the unmanaged DLL? That way, I could just start another AppDomain with the same DLL and have the state reset that way. This would be great, but I am not yet sure if it is possible.
Any help is appreciated.
Thanks,
klk
madness ? this.isSparta = true : this.isSparta = false;
|
|
|
|
|
That sounds like a serious hack solution. I do not recommend doing that. You have not provided enough information about the situation for us to determine what else might be appropriate as a solution.
K.L.K wrote: it is difficult to get the structures in the DLL to reset their state properly.
You need to explain that in detail otherwise we cannot understand the problem.
led mike
|
|
|
|