C # calls the MySQL database (using MySql.Data.dll connection) Mysql-connector-net-6.10.4.msi

Source: Internet
Author: User

: http://dev.mysql.com/downloads/connector/net/

Installation Instructions

1. Installation: Mysql-connector-net-6.10.4.msi

it: http://dev.mysql.com/downloads/connector/net/

Install Mysql-connector-net-6.10.4.msi on WINDOWS10 operating system

The default is installed on the C drive:

After installation, reference the component MySql.Data.dll in the application engineering.

Then reference the component in the Application project: MySql.Data.dll.

2. The installation steps are as follows:

After the installation is complete C:\Program Files (x86) \mysql\mysql Connector Net 6.10.4\assemblies\v4.5.2

MySql.Data.dll is C # operation MySQL driver file, is C # connection MySQL necessary plugin, make C # language more concise operation MySQL database. Then add a reference to the component in the project, enter the using MySql.Data.MySqlClient in the code page, and we'll be able to make a connection using the class library's function successfully.

3. Test procedure

Create a new C # console application named: CSharp call MySQL. Add a reference "MySql.Data.dll" in C #

Add code in Program.cs:

1 usingSystem;2 usingSystem.Collections.Generic;3 usingSystem.Linq;4 usingSystem.Text;5 usingMySql.Data.MySqlClient;//reference MySQL6 7 8 namespaceCSharp call MySQL9 {Ten     class Program One     { A         Static voidMain (string[] args) -         { -             stringConstructorstring ="Server=localhost; User id=root;password=;D Atabase=company"; theMysqlconnection Myconnnect =Newmysqlconnection (constructorstring); - Myconnnect.open (); -Mysqlcommand myCMD =NewMysqlcommand ("INSERT INTO t_dept (name,year) VALUES (' JJJ ',", myconnnect); - Console.WriteLine (mycmd.commandtext); +             if(Mycmd.executenonquery () >0) -             { +Console.WriteLine ("Data inserted successfully! "); A             } atMycmd.commandtext ="INSERT INTO t_dept (name,year) VALUES (' Jjj4 ',"; - Console.WriteLine (mycmd.commandtext); -             if(Mycmd.executenonquery () >0) -             { -Console.WriteLine ("Data inserted successfully! "); -             } inMycmd.commandtext ="Delete from t_dept"; - Console.WriteLine (mycmd.commandtext); to             if(Mycmd.executenonquery () >0) +             { -Console.WriteLine ("User table type data all successfully deleted! "); the             } * mycmd.dispose (); $ myconnnect.close ();Panax Notoginseng         } -     } the}

4. C # connection Database MySQL command

(1) Establish the connection:

New Mysqlconnection ("database= database name; The IP address of the data source= server; User id= username; password= User Password ");

Or:

New Mysqlconnection ("IP address of the server= server; user id= username; password= user password; database= database name ");

Or:

string " server= server IP address; User id= username; password= user password; database= database name "; // according to your own settings New Mysqlconnection (M_str_sqlcon);

Note: server= server IP address; User id= username, password= user password, database= database name, these order can be swapped, as long as the alignment of each string and identifier is good.

(2) Execute SQL command:

Set query commands

Mysqlcommand  New Mysqlcommand ("select * fromt_dept wheretitlelike '%p% '" , Sqlcon);

C # calls the MySQL database (using MySql.Data.dll connection) Mysql-connector-net-6.10.4.msi

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.