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.