How to use MySQL database in visual c# 2010

Question

I need to use a database in my xna 4.0 game that will save data such as username, etc. can you give me an example on how to connect to a MySQL database and as well as an insert statement. thank you !

Umm. you want an example of an insert statement? Is it really that hard to google up some SQL syntax examples? We can help fix problems with your existing code here, but we're not here to teach you something you could very easily learn yourself. — Marc B
– Marc B, Commented Nov 30, 2011 at 3:39

Robert Harvey · Accepted Answer · 2011-11-30 04:08:33Z

1

Here is a walk through and wrapper class for mysql in c#. http://iseesharp.blogspot.com/2005/09/mysql-with-c.html

Usage:

DbWrapper myWrapper = new DbWrapper("localhost", "CS",
    "iseesharp", "seesharper");
myWrapper.Connect();

myWrapper.AddUser("Rowan", "ISeeSharp");
if (myWrapper.UserExists("rowan"))
{
    Console.WriteLine("Something's weird here");
}
else
    if (myWrapper.UserExists("Rowan"))
{
    Console.WriteLine("I exist, therefore I think!");
}

myWrapper.Disconnect();

edited Nov 30, 2011 at 4:08

Robert Harvey

182k48 gold badges349 silver badges516 bronze badges

answered Nov 30, 2011 at 3:38

box86rowh

3,4252 gold badges28 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use MySQL database in visual c# 2010

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related