1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using MySql.Data.MySqlClient;   //引用MySql
 6 
 7 
 8 namespace Csharp调用mysql
 9 {
10     class Program
11     {
12         static void Main(string[] args)
13         {
14             string constructorString = "server=localhost;User Id=root;password=;Database=company";
15             MySqlConnection myConnnect = new MySqlConnection(constructorString);
16             myConnnect.Open();
17             MySqlCommand myCmd = new MySqlCommand("insert into t_dept(name,year) values('jjj',22）", myConnnect);
18             Console.WriteLine(myCmd.CommandText);
19             if (myCmd.ExecuteNonQuery() > 0)
20             {
21                 Console.WriteLine("数据插入成功！");
22             }
23             myCmd.CommandText = "insert into t_dept(name,year) values('jjj4',22）";
24             Console.WriteLine(myCmd.CommandText);
25             if (myCmd.ExecuteNonQuery() > 0)
26             {
27                 Console.WriteLine("数据插入成功！");
28             }
29             myCmd.CommandText = "delete from t_dept";
30             Console.WriteLine(myCmd.CommandText);
31             if (myCmd.ExecuteNonQuery() > 0)
32             {
33                 Console.WriteLine("user表类型数据全部删除成功！");
34             }
35             myCmd.Dispose();
36             myConnnect.Close();
37         }
38     }
39 }

MySqlConnectionsqlCon= new MySqlConnection("Database=数据库名字;Data Source=服务器的ip地址;User Id=用户名;Password=用户密码");

MySqlConnectionsqlCon= new MySqlConnection("server=服务器的ip地址;user id=用户名;password=用户密码;database=数据库名字");

 string M_str_sqlcon = "server=服务器ip地址;User Id=用户名;password=用户密码;Database=数据库名字";//根据自己的设置
 MySqlConnection sqlCon = new MySqlConnection(M_str_sqlcon);

MySqlCommand  mycmd= new MySqlCommand("select * fromt_dept whereTITLElike '%p%'", sqlCon);