can you explain a little bit better please
Explain better what you want to do.
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?
So ur trying to develop a program to connect to several location using the dyndns software?
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.
I have done a simple flowchart. have attached.
Have attached a simply flowchart for better picture.
Dyndns provides you with a name for the site instead of the IP address. you have to change the connection string when u change the request to another database. For example
So u only need to change the conection string when you select another location to point the the selected database, Something like this:
Dont forget to open SQL server ports to allow remote connections to your database.
I hope this is the kind of answer you are searching for.
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?
Yes, you need to change connection string to fetch data from another server. Are you connecting to database with plain code or using a ui feature?.
With plain code i mean something like this:
dim con as new sqlconnection("Server=kulay.dyndns.com;Database=myDataBase;Trusted_Connection=True;") dim com as sqlcommand=nothing con.open com=new sqlcommand("select * from surveys",con) dim datar as sqldatareader=com.executenonquery while datar.read ' code to handle data msgbox datar.item(0) & " - " & datar.item(1) end while datar.close com.dispose con.close con.dispose
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 case "Jaya" conString="Server=jaya.dyndns.com;Database=myDataBase;Trusted_Connection=True;" case "Kulai" conString="Server=kulay.dyndns.com;Database=myDataBase;Trusted_Connection=True;" end select dim con as sqlconnection=new sqlconnection(conString) ' remaining code to use data
Hi, as I was told that my code doesn’t scale well at all, I thought perhaps I’d try to get a better understanding of interfaces/abstract classes and classes and the relationship between them.
I don’t want at this stage work on a big separate project as I've already got plenty ...
Hey, so I wanna ask how I need to create a method who will remove word if in that word is 2 same chars. Example: "Potato" in this word there is a 2 "o" chars so this word will need to be removed. "Forum" in this word there is no ...
Hi I'm having a problem implementing a mini shopping cart drop down in the header to show the user all the products they have in their shopping cart. It seems the only solution for this is Ajax, and I've looked all over and can't find anything that I could possibly ...