get an alert email when this solution is edited

×Welcome aboard! We are happy you are here and wish you good net-raft!



Together We Can Simplify The World

the current number of solutions:  2072
.htaccess (1x)    AJAX (13x)    ANGULARJS (129x)    ASP (1x)    ASP.NET (4x)    BACKBONE.JS (47x)    BOOTSTRAP (12x)    C# (194x)    COFFEESCRIPT (28x)    CSS (71x)    HTML (46x)    JADE (32x)    JAVA (51x)    JAVASCRIPT (412x)    JQUERY (338x)    JQUERY MOBILE (5x)    JSON (5x)    LARAVEL (12x)    MYSQL (9x)    NODE.JS (99x)    ORACLE SQL (15x)    PERL (1x)    PHP (258x)    PYTHON (9x)    REACT (54x)    RUBY (23x)    RUBY ON RAILS (1x)    SHELL (1x)    SQL (80x)    SQL SERVER (3x)    TYPESCRIPT (47x)    VB.NET (25x)    W3.CSS (6x)    W3.JS (40x)    
join us

click to create your account

The most viewed C# solutions by country
Solution Country
Get real client latitude and longitude using C# ?Cinque Terre
Get real client latitude and longitude using C# ?Cinque Terre
get current url using C#Cinque Terre
get city country region timezone c#Cinque Terre
get current url using C#Cinque Terre

The most helpful C# solutions
Likes Solution Technology
606 detect ie C#C#
112 Get real client ip address using C# ?C#
104 how to initialize a connection to mysql database using C# ?C#
82 get real user country C#C#
76 get hostname using C#C#
Check out all of C# ...

connection mysql c#

(c# connection mysql )

- C#

 viewed 7

Comment:
C#

// add reference MySgl.Data

using System;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string connetionString = null;
MySqlConnection cnn ;
connetionString = "server=localhost;database=testDB;uid=root;pwd=xxx;";
cnn = new MySqlConnection(connetionString);
try
{
cnn.Open();
MessageBox.Show ("The connection is open!");
cnn.Close();
}
catch (Exception ex)
{
MessageBox.Show("The connection is refused!");
}
}
}
}


    

   
created: 13 days ago

The power of the user (%)

35%

Do you know a little more effective code ? Feel free to optimize ...


haven't you found what you're looking for ?
Write us your question ...
Login is not needed.