[C#] How can i make a database connection?

[JayNike]

Hello guys, im really bad right now. I can't get my GUI connect to my extern Database. Its hosted on my own host, so how can i make a connection to the host, + a QUERY? Like if it connects, that it makes the Query what ive put in the textbox1?
Example:
Console.Command = "" + textbox1.text + "";
or
Console.Command = (textbox1.Text);
or something else, +
in the textbox i did write example: "SELECT pixels FROM users WHERE id = 1;"

Thanks in advance

 

[rice]

Hello guys, im really bad right now. I can't get my GUI connect to my extern Database. Its hosted on my own host, so how can i make a connection to the host, + a QUERY? Like if it connects, that it makes the Query what ive put in the textbox1?
Example:
Console.Command = "" + textbox1.text + "";
or
Console.Command = (textbox1.Text);
or something else, +
in the textbox i did write example: "SELECT pixels FROM users WHERE id = 1;"

Thanks in advance

read this article
Tutorial - Using MySQL in C# - C#
helped me out a lot

just get the connecter (MySql.Data.dll) + add it to references then just copy the code and modify it to your needs
Console.writeLine("HOST");
string host = Console.readLine();
Console.writeLine("USER");
string user = Console.readLine();
Console.writeLine("PASS");
string pass = Console.readLine();
Console.writeLine("DB");
string db = Console.readLine();
string conString = "server=" + host + ";userid=" + user + ";password=" + pass + ";database=" + db + "";

 

[yjlasher22]

Moved to coder's paradise. Reckon you can get more help here. Good luck!

 

[Supicioso]

read this article
Tutorial - Using MySQL in C# - C#
helped me out a lot

just get the connecter (MySql.Data.dll) + add it to references then just copy the code and modify it to your needs
Console.writeLine("HOST");
string host = Console.readLine();
Console.writeLine("USER");
string user = Console.readLine();
Console.writeLine("PASS");
string pass = Console.readLine();
Console.writeLine("DB");
string db = Console.readLine();
string conString = "server=" + host + ";userid=" + user + ";password=" + pass + ";database=" + db + "";

You don't even need the connector installed. You just need that file. I used it recently without connector installed and it still worked the same way.

Just a tid bit

 

[swdl]

i can see this job ,and use for me dbs

 

[James]

Not trying to be rude or anything but you could have googled mySQL in c#, there are tons of results to do with mySQL in .NET languages.

@Abysmal That's because the DLL imports the mySQL class into your project as service reference that way you don't have to use the connector. It's better for people who know what their doing, the connector pools connections for you automatically but using the DLL you have to do it yourself, if you want optimal performance.

 

[onemorejosh]

fyi, you can use linq-to-sql... just drag and drop tables into the designer... and you can access your code like

int? user_id = Users.Where(x=>x.UserName=="Jim" && x.Password=="coolpw").Select(x=>x.UserID).SingleOrDefault();

 

[Dawson]

Or you can move off of a garbage .net language and use say... C++ and grab one of the many good SQL libs.

 

[onemorejosh]

*ahem*.

Garbage COLLECTED .net language, you mean hehe

 

[Vakarian]

... Or you can make your own little databases VIA data sources.