What I have to do: I have to create an application in C# that can add values in a database, search trough the database and so on.. This application will be on several Pc's ( this is a project for work ) and will insert values to the same database ( we want to create this database on a PC that is always ON) We have the permision to use Sql server enterprise 2008. I know that it's much, but I want to know how to create the database to be used not just in the main PC so everyone can insert data in it if they use the app, I think it's called multi user database.. If you could give me some ideas and explanations it would help me a lot.. I read a few tutorials but I couldn't understand how can I connect to a database if it is not in my Pc.. everything is blurry in my head.
OK, so, your database actually only needs one user (possibly also known as a schema, depending on your database), unless you want to limit who can do what.
Then, you need to configure your database to allow remote connections.
Once that's done, you'll be able to get something called a "connection string", which can be used in your application to open a connection to the database.
Once the connection is open, you can use SQL to read/write/edit the database.
If multiple users are going to be doing this simultaneously, you will need to look into things like row locking, transactions, and isolation modes.
I hope that helps your research get started