C # connect to mysql database _ MySQL-mysql tutorial

1. download MySQLDriverCS-n-EasyQueryTools to download the driver. select your own version. 2. import the driver to the project. 1. add the light color in the selection picture in reference. OK. 3. add the header file usingMySQLDriverCS to the code block to connect to the 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.