[Question] VB.NET and Databases.

So I have a database attached to my program which contains names.

But what I need to know is, how would I make the database update if theirs new names added to the database.

Example:

Computer A has my program but doesn't have a correct database. How would I make it so that Computer A can get an updated version from the Main computer.

Thanks in advance.

host the database on the server, use a connection string.

How you maintain the database is a matter of logic and what type of database you are using (3rd time today, awesome, I am glad to see that people are starting to use databases)

What type of database are you using SQL Server, MySQl , Access, Entity...

This matters somewhat

I'm going to start with Access as I find it very easy to work with

When you add a database the connection string will be

Code:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

where mydatabase is the name of your database.

You need to edit the data string so the source points to the hosting account instead of the local drive

You can do that in the database properties.

Note: When you create the database be sure to use a username and password for security, and set them in the above string

Example of database string in use

Code:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://mywebdomain.com\db\mydatabase.mdb;User Id=myusername;Password=mypassword;

Databases will update dynamically by checking the datastring for location then updating it's information "on the fly"

That's just the info I needed!

Thanks for the quick help!

Not a problem, It's what I hang around for

[Question] VB.NET and Databases.

Post a Reply

Similar Threads

Tags for this Thread