|
gankanda wrote: using language is C++ not C#
Gina's en Credential providers are always written in a language that compiles to native code; it's not possible to implement these using the .NET framework. Again, for security-reasons.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hello,
I need to develop an Server - Client application (C#) that should do the following things :
1) Every Client should be able to create , edit or delete some documents(this part is done). After a change is done ( create,edit,delete) there must be a kind of synchronization between the clients through the server so that no matter what client we work on (the server could also have a client app installed) , the list of files would be the same at any time.
2) Server should have an SQL database that can be accessed by all clients no matter how many clients are.
3) Provide a way to connect your mobile phone to the server and read all the data in the database if necessary + access all the documents.
What I need are some suggestions about the three things that I wrote about. What technologies should I use.I read many articles but none of them seems to offer me a simple and efficient solution. I also had the idea to store everything in the database (data + files) but I don't think this is the best option because there can be almost 100 mb of new files created each day and database backups need to be done every day.
Thank you. Waiting for suggestions.
|
|
|
|
|
Rares T wrote: What technologies should I use.I read many articles but none of them seems to offer me a simple and efficient solution.
There isn't a single solution to this, they'll all bting their own benefits and costs.
I'd suggest using a Web API[^] to upload the documents. You can also take a look at this article[^]. The server can then save (either to filesystem or DB) and upate the Database with the new file information.
If you want a web front end you can use signalr[^] to keep things synchronised. If you are creating a forms app you can use signalr's methodology for long polling to keep things in sync.
Point 3 is simplified if you create a mobile and desktop enabled web front-end, but ultimately any app can consume the web api.
Rares T wrote: 2) Server should have an SQL database that can be accessed by all clients no matter how many clients are.
There is no system on Earth that can handle the italics part of the requirement, the best you can hope for is a highly scalable system. If you design you web api (& web-application) correctly so they can be web-farmed then you'll be pretty much set.
Rares T wrote: I also had the idea to store everything in the database (data + files) but I don't think this is the best option because there can be almost 100 mb of new files created each day and database backups need to be done every day.
I'd avoid putting the docs in the DB in any case. I'd ferry them off in a rational folder structure and make sure it isn't accessible from the web (downloaded via the web api only). The DB can be used to store the file location, that way you upgrade your file storage as needed without "risking" the database. You can also back up the DB and documents separately.
“Education is not the piling on of learning, information, data, facts, skills, or abilities - that's training or instruction - but is rather making visible what is hidden as a seed”
“One of the greatest problems of our time is that many are schooled but few are educated”
Sir Thomas More (1478 – 1535)
|
|
|
|
|
Thank you for your quick reply. The basic functionality that I need would be just to synchronize the documents between the clients. So for example if a have 4 computers connected through a switch an 1 computer is the "server" and the other 3 computers are the "clients" then if a clients makes any change (create, edit or delete) to documents, the changes should appear to the other clients.I thought that the easiest solution would be to do this through the server because a backup of the documents should be done every week. The functionality with the mobile phone is optional so it is not that important.I can do this without the mobile phone problem. So if you could offer me a solution to this problem (synchronization) it would be perfect. The application for each client is WPF (C#) and on the server the application has a sql database that contains just some simple data related to some persons right now. But on the documents synchronization problem it's a bit harder and it does not seem to be stable solutions available.
Thank you
|
|
|
|
|
You need to work out architecture you need for your situation. The WebAPI stuff I suggested will work. The problem is the synchronisation. Instant synchronisation is impossible, the latency introduced by the network sees to that. O
You need to decide whether you need updates in near-real time (e.g. at save or even edit) or when complete (e.g. when the user syncs). The first, fully collaborative approach is going to be hard: you could designate a server which holds the document and actually edits, and have the updates in near real-time so that the clients act as dumb-terminals in effect. The second approach is easier: you upload the doc and update a timestamp, the clients are either informed about this (better) or they get the document on a polling interval (a good half-way house approach is long-polling: you can Google for this) which sends documents newer than the last poll.
In either case either a web api or a WCF service could be of use, but you aren't going to have 100% instant sync and you will have concurrency problems. WCF has a bonus in that it can run peer-to-peer bu orchestrating across machines is going to be hard, so I think your client(s)/server approach seems good.
“Education is not the piling on of learning, information, data, facts, skills, or abilities - that's training or instruction - but is rather making visible what is hidden as a seed”
“One of the greatest problems of our time is that many are schooled but few are educated”
Sir Thomas More (1478 – 1535)
|
|
|
|
|
Rares T wrote: After a change is done ( create,edit,delete) there must be a kind of synchronization between the clients through the server so that no matter what client we work on (the server could also have a client app installed) , the list of files would be the same at any time.
If you're using the same database on the server, you'd have the same list of files. The server will not "inform" all clients that the list has changed though.
Rares T wrote: Provide a way to connect your mobile phone to the server and read all the data in the database if necessary + access all the documents.
What type of documents? What does "access" mean in this context, is it just "displaying" a document, or would one need to be able to edit a PDF document on a phone?
Rares T wrote: I also had the idea to store everything in the database (data + files) but I don't think this is the best option because there can be almost 100 mb of new files created each day and database backups need to be done every day.
I'm all in favour of putting files in the database; simply exclude the table from the backup, or put it in it's own database.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
How to Protect the dll or exe Code
|
|
|
|
|
Try an obfuscator - it will protect nothing, but may satisfy your requirements anyway.
|
|
|
|
|
harold aptroot wrote: it will protect nothing, but may satisfy your requirements anyway.
Oh you cynic you. But Yes.
“Education is not the piling on of learning, information, data, facts, skills, or abilities - that's training or instruction - but is rather making visible what is hidden as a seed”
“One of the greatest problems of our time is that many are schooled but few are educated”
Sir Thomas More (1478 – 1535)
|
|
|
|
|
kalyanacvk wrote: How to Protect the dll or exe Code
By not distributing it. Anything that's released, can be broken (given enough resources).
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I want to get the coordinate of the controls in the game ,is there any way except color detection.I want to make a simple bots  please help me![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Nope. You're essentially taking a screen shot of the flash game and going image manipulation and OCR to get the data you want.
Flash doesn't use controls that your code can get to.
|
|
|
|
|
Maybe it's not a good idea to simulate mouse_click by clicking the controls location ,right?
most web game bots using simulate data pack to make the bot ,yes?
|
|
|
|
|
|
Thank u very much,you helped a lot
|
|
|
|
|
Hi
I have an access database and i want to make this setup.
This setup will be install in a laptops or in a servers.
There are different ways to do this? and how can i make access database setup?
this database will be used from my c# project that i also make
setup.
I also understand that i must make database setup because when i try to run my project setup an error has occurred.
the error is :
---------------
Execute reader requires an open and available connection.The connection's current state is closed.
|
|
|
|
|
That error has nothing to do with creating a setup for the database. You don't have to make a seperate setup for the Access database. It's just a file.
That error means that you tried to use a connection to the database that you never opened. You have to open the connection and THEN you can read from it. It's a bug in your code...
|
|
|
|
|
i solve the error. i must include in my application folder the access file now it's ok ..
i have another question:
If i want to run my project access database from a server i have to make more work about it?
|
|
|
|
|
You can NOT put the database in the application folder under Program Files. Everything under Program Files is readonly by default. Admins don't like giving write permissions to anything under that folder.
Put your database in a more suitable location.
But, no matter where you put it, you'll have to change your applications connection string to tell it where to find the file.
If this is going to be a shared database used by more than one person, you really do NOT want to use an Access database.
|
|
|
|
|
the database will be use by minimum 3 person but this is not my decision i only follow instructions
from others.
because i don't make setup in previous times that must be in a server,
it is my first time.
Can you please tell me or give me some examples about how make setup access database that have to be save in a server??
thnx
|
|
|
|
|
There's nothing to setup for an Access database. You just copy the .MDB file to wherever it needs to go.
|
|
|
|
|
Let me add some reinforcement to Dave, DO NOT USE ACCESS AS A SERVER database, convert to SQL Server. Access is a single user database, Microsoft states this in the documentation. You should not be using for shared data. BTW SQL Server express is FREE, no charge unless you require more than 4gb at which point you need to get a server licence.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
It really depends how your application is connecting your .MDB?
If your application assumes the ms access database to be a specific folder like Application Installation folder, then you can follow below link <a href="http://vijirajkumar.blogspot.in/2010/03/create-setup-and-deployment-project.html">http://vijirajkumar.blogspot.in/2010/03/create-setup-and-deployment-project.html</a>[<a href="http://vijirajkumar.blogspot.in/2010/03/create-setup-and-deployment-project.html" target="_blank" title="New Window">^</a>] and to attach your 'Access' database: In the figure 4 of above tutorial -> right click on 'Application Folder' -> select 'File...' and then search the *.mdb file on your hard disk. When you compile (Debug or Release) it will copy the database to the App Folder.
While installation it will be copied to user’s application installation folder (i.e C:\Prog Files\xyz…)
|
|
|
|
|
zebra88 wrote: this database will be used from my c# project that
MS Access requires that the OS must have file level access to the database file.
So if you want 3 people (three different computers running the client app) to use it then all three of those must have the file viewable via Explorer.
|
|
|
|
|
Hi All
1. I have GridEX which bound to DataSet
2. One of the column is ceckbox cloumn
3. I fileter one of the column (not the ceckbox column) by the header column and I see the correct data in the Grid
4. I want to checked only the filtered record (the record which shown in the grid) how can I do it?
until now I Loop on all of the records in the dataset and checked all the records and finally refresh the grid
any advice
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
