Win form & Access Sql server using Get and Post(HTTP) Method

[thenndral]

Dear all,


I'm using VB.Net 2010 and sql server 2012


May be my question is wrong. Please give me suggestion.


I'm doing a remote monitoring system using Vb.net winform application.
1. Remote machine repeatedly send status and some sensitive data to sql server.
2. End user checks the machine status from sql server.


Sql server database is resides in the webserver. At first I access the database using connection string ie. give direct ip address of the webserver and access the data. we got security issues of sensitive data. So we plan to modify the source like sending data through http to sql server using win form. Is it right? I have no experience to take right decision so got confusion. Please guide me.

which method is perfect for this requirement and also data secure?
1. Get and post method (Vb.net winform) - I don't know how to use this method.
2. Asp .Net Webservice (*.asmx)


Please guide me in the right path.


Thanks a lot,
Thenndral

 

[JuggaloBrotha]

I would recommend creating a .Net WebService that does all the database calls, then just have your program access the service.