I am trying to make a Visual Basic Program that will sync all computer that have the program on them

Question

I am making a checkin for our church and it will checkin kids. We are putting on 3 different computers and I need them all to have up to date information about the kid because they get points if the bring there Bible or bring a friend etc. And there is going to be a checkin computer and a gift shop computer and we need those points and all the information to be up to date. We need it so when they hit save in the checkin program the child can go back to the gift shop and spend their points that they have. I have created a database and now I just need to have it so that all the computers will have the same information of a network.

Please help......

 

Answer 1

To Start - what database ? Some are better at sharing than others..........

Answer 2

Use a single database with each computer making a connection the same database.

sql server express will do a very nice job for you.

Answer 3

Use a single database with each computer making a connection the same database.

sql server express will do a very nice job for you.

Can you explain that more in depth.

Please

---

Pumaboy999999

Answer 4

HI pumaboy,

Welcome to the MSDN forum.

I think your issue is too general for us to help you. You know what you want well, so you can start with it by install a database.  At the same time, here is some basic knowledge of database you need to learn, such as how to create a table, how to fill the data, and how to connect the VB.Net application with database.  Pay attention that different database has different ways to deal with. So I agree with Devon, and suggest you to choose a database which suit for you firstly.

Hope this helps. 

---

Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us

Answer 5

In your original post you said 3 diff computers, then you listed 2 diff computers - is the 3rd one a server ?

You also said you created a Database - using what ?

 

Answer 6

yes the third one is a server and i created a database using SQL Server 2008 management studio. So what do I do know

---

Pumaboy999999

Answer 7

If you search for "vb net connect to sql database" you will get more information than you could digest in10 lifetimes. This is not what I'd call an easy project, If you aren't familiar with databases, I would suggest you do a lot of reading and planning before you start writing any code. From what you have said, you need at minimum tables for the kids, for each creditable item or activity, for each debitable item. Someone needs to administer adding and possibly removing or editing each possible item.

Answer 8

I have the database written and the program is working correctly but i am putting them on my computers. We need the program to stay up to date and connect to the server

---

Pumaboy999999

Answer 9

Hi Pumaboy,

>>We need the program to stay up to date and connect to the server

So you need to change your connect string in your application to connect the remote darabase, and set your database to allow remote connection. For more information, please check:

How to enable remote connections in SQL Server 2008?: http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

SqlConnection.ConnectionString Property: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx

Hope this helps.

---

Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us

Answer 10

Hi Pumaboy,

We haven’t heard from you for several days. I’d like to mark the helpful replies as answer firstly. If you have any additional questions, you also can unmark the replay and post your question here. 

Sorry for any inconvenience and have a nice day.

---

Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us