Sorry that i didnt explain much. I have created a Survey System for Driving Schools. What they require is, when the student does the survey the data can be viewed by the Admin to see what the students have answered according to Categories. This is to monitor the Instructor, Customer Service and Tranportation KPI. So they want this system to be centralized, For example the Admin from School A Located at Location A can view and print the report from School B Located at Location B, vice versa. Anything else you need me to explain?
Hi, i have already developed it, but i just dont know how to connect using dyndns, in order for the Admin to get results from different location. For example: my interface has got few buttons of Location Name such as Permas Jaya,Kulai,Johor Jaya. So when the admin from permas jaya click's Kulai it should fetch the data from the server in Kulai and display it.
So do i write this connection strings at the buttons? I have already created a ConnectDB with the connection string, but do i sepcify multiple connection string in order for it to fetch the particular data?
dim con as new sqlconnection("Server=kulay.dyndns.com;Database=myDataBase;Trusted_Connection=True;")
dim com as sqlcommand=nothing
com=new sqlcommand("select * from surveys",con)
dim datar as sqldatareader=com.executenonquery
' code to handle data
msgbox datar.item(0) & " - " & datar.item(1)
If you program the solution with the provided code, you just have to add a conditional statement to choose which connection string should be used, store it into a variable and replace the string used in the creation of the object "con". Something like this.
dim conString as string = string.empty
select case cmbLocation.selecteditem
dim con as sqlconnection=new sqlconnection(conString)
' remaining code to use data