C # connect to the mysql database,

C # connect to the mysql database,

1. Driver required

Download MySQLDriverCS-n-EasyQueryTools and select the version as needed.

2. Project import driver

1) Add in reference

Select

Light color in the figure, OK.

3. Code Block

Add header file

Using MySQLDriverCS;

Database connection code

MySQLConnectionString tConnStr = new MySQLConnectionString ("localhost", "wxj", "root", "", 3306); MySQLConnection tConn = new MySQLConnection (tConnStr. asString); tConn. open (); // Open the connection string tCmd = "SELECT * FROM wxj. stu; "; // command statement MySQLCommand cmd = new MySQLCommand (tCmd, tConn); // execute the query command MySQLDataReader tReader = cmd on the defined tConn object. executeReaderEx (); if (tReader. read () // Read one record at a time {Response. write (tRead Er ["name"]. ToString ();} tConn. Close (); // important! Close tReader. Close () in time ();

The remaining logic functions depend on your needs.