| View previous topic :: View next topic |
| Author |
Message |
NINTENDO Grandmaster Cheater Supreme
Reputation: 0
Joined: 02 Nov 2007 Posts: 1371
|
Posted: Sat Feb 16, 2008 7:40 am Post subject: C# local database. |
|
|
erm..
How do i open a connection to the local database with code?
_________________
Intel over amd yes. |
|
| Back to top |
|
 |
killersamurai Expert Cheater
Reputation: 0
Joined: 10 Sep 2007 Posts: 197 Location: Colorado
|
Posted: Sat Feb 16, 2008 9:32 am Post subject: |
|
|
I don't do much database programming, but I would either use xml or use microsoft access. You can use SQL, but that would require the user to have it installed on there computer.
Microsoft Access
XML
|
|
| Back to top |
|
 |
samuri25404 Grandmaster Cheater
Reputation: 7
Joined: 04 May 2007 Posts: 955 Location: Why do you care?
|
Posted: Sat Feb 16, 2008 9:52 am Post subject: |
|
|
| killersamurai wrote: | I don't do much database programming, but I would either use xml or use microsoft access. You can use SQL, but that would require the user to have it installed on there computer.
Microsoft Access
XML |
Not necessarily.
The SQL Database would be installed on a server computer, and the user connects to it.
For example, would game programmers want to have the entire SQL Database of users/passwords/emails/etc installed on every user's computer? No--something's bound to screw up. Rather, they have hte user connect to it, using a part of the game as a middle man.
~~~
However, if you just want to have the user get some information from their own computer, SQL would be overkill (and killersamurai would be right about the user having to have it installed)--in that case, you should just use XML.
Access =
_________________
|
|
| Back to top |
|
 |
NINTENDO Grandmaster Cheater Supreme
Reputation: 0
Joined: 02 Nov 2007 Posts: 1371
|
Posted: Sat Feb 16, 2008 10:53 am Post subject: |
|
|
Well.
I dont think it will overkill. It's simple information that will be saved.
I want a db instead of using a ini.
Can somebody now tell me how to connect to the db to get or modify information?
_________________
Intel over amd yes. |
|
| Back to top |
|
 |
samuri25404 Grandmaster Cheater
Reputation: 7
Joined: 04 May 2007 Posts: 955 Location: Why do you care?
|
Posted: Sat Feb 16, 2008 11:06 am Post subject: |
|
|
| Naablet wrote: | Well.
I dont think it will overkill. It's simple information that will be saved. |
Exactly why it'll be overkill.
| Naablet wrote: | | I want a db instead of using a ini. |
Ini files are way outdated--you shouldn't have even considered that. Rather, you should use XML files, or the registry. Both have ample tutorials on Google for C#.
| Naablet wrote: | | Can somebody now tell me how to connect to the db to get or modify information? |
Once again, a database is way overkill, and that's not how a database is supposed to be used: there is only supposed to be one database, on the server computer, and everyone else simply connects.
You'd be making a huge mistake to try to create a database on the user's computer is use that.
What happens when they hack the database? What happens when they don't have SQL installed? What happens when they uninstall SQL?
You can't "uninstall" XML, or the registry--you just can't.
_________________
|
|
| Back to top |
|
 |
NINTENDO Grandmaster Cheater Supreme
Reputation: 0
Joined: 02 Nov 2007 Posts: 1371
|
Posted: Sat Feb 16, 2008 11:09 am Post subject: |
|
|
Thanks.
I'll try xml.
Will the user's need Chilkat's xml lib installed if i add it to the program.
_________________
Intel over amd yes. |
|
| Back to top |
|
 |
CyClonenl Newbie cheater
Reputation: 0
Joined: 12 Mar 2005 Posts: 24
|
Posted: Mon Feb 18, 2008 9:36 am Post subject: |
|
|
What compiler do you use? Visual Studio?
Check out the Properties class, you can save settings easy using this class. [url=http://msdn2.microsoft.com/en-us/library/aa730869(VS.80).aspx]MSDN Article link[/url]
And connecting to a MYSQL database is possible, although quite weird if you ask me.. You need to install some sort of driver on the clients computer. Geekpedia link
|
|
| Back to top |
|
 |
|