c#链接mysql_C#连接mysql实例[转]

直接上代码，注意需要引用MySQL.data.dll

using System;

using System.Configuration;

using MySql.Data.MySqlClient;

///

/// TestDatebase 的摘要说明

///

public class TestDatebase

{

public TestDatebase()

{

//

// TODO: 在此处添加构造函数逻辑

//

}

public static void Main(String[] args)

{

MySqlConnection mysql = getMySqlCon();

//查询sql

String sqlSearch = "select * from student";

//插入sql

String sqlInsert = "insert into student values (12,'张三',25,'大专')";

//修改sql

String sqlUpdate = "update student set name='李四' where id= 3";