Network-Database Programming How to
-
Does anyone help me on network programming with vb.net? I started new project on database programming over the network. My project is desktop base application (not web base application), I don't know your country call that desktop application but my country (Thailand) does. I search on the internet and I found that I must use socket. I understand the database programming but network I can't. I try to apply the sample code from internet with my project but it's all fail. I have tried this about 1 month. If anyone can solve on this topic, please help me. My project is manipulate data on client that follow this strp 1. Client send the request to server. 2. Server will query data from main database then generate a xml file and send it to client. 3. Client recieve the text file and update the local database. 4. Client manipulate data. 5. Client query updated data and generate a xml file then send it to server. 6. Server recieve the text file and update main database. I don't connect the main database via notwork for security. I can check text file format and block it anyway. P.S. I'm a Thai student and my English language skill so weak, please try to understand my words. Thank you very much. Sitt
-
Does anyone help me on network programming with vb.net? I started new project on database programming over the network. My project is desktop base application (not web base application), I don't know your country call that desktop application but my country (Thailand) does. I search on the internet and I found that I must use socket. I understand the database programming but network I can't. I try to apply the sample code from internet with my project but it's all fail. I have tried this about 1 month. If anyone can solve on this topic, please help me. My project is manipulate data on client that follow this strp 1. Client send the request to server. 2. Server will query data from main database then generate a xml file and send it to client. 3. Client recieve the text file and update the local database. 4. Client manipulate data. 5. Client query updated data and generate a xml file then send it to server. 6. Server recieve the text file and update main database. I don't connect the main database via notwork for security. I can check text file format and block it anyway. P.S. I'm a Thai student and my English language skill so weak, please try to understand my words. Thank you very much. Sitt
Hi Sitt, We have a setup in our company that sounds similar to what you describe. We have a very simple approach that works very nicely. Our client application contains code to create xml files, and other code that can read xml files. Same thing for the server application. When the server app does something that should influence whatever happens on the client machines, it creates an xml file with the necessary data, and copies it to a shared or ftp folder. The client app checks this folder on a regular basis, and when it finds an xml file it reads it, and does something with the data. When the client app does something that should influence the server, it creates an xml file of its own and puts it in the same (or another) shared folder. The server also checks the folder on a regular basis, etc. This process is very easy to secure, and to create, but it is not very good if you need to have very fast traffic between clients and server. Hope this helps you, Johan