连接.txt

常用c#知识库

1.安装Microsoft ODBC.net。
2.安装MySQL的ODBC驱动程序。
2.解决方案管理中添加引用Microsoft.Data.Odbc.dll(1.0.3300)
3.代码中增加引用
using Microsoft.Data.Odbc;
4.编写代码
			string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" + 
				"SERVER=localhost;" +
				"DATABASE=samp_db;" +
				"UID=root;" +
				"PASSWORD=;" +
				"OPTION=3";
			//Connect to MySQL using Connector/ODBC
			OdbcConnection MyConnection = new OdbcConnection(MyConString);    
			MyConnection.Open();
			Console.WriteLine("\n !!! success, connected successfully !!!\n");    
MyConnection.Close();