Operate the mysql database in the .NET environment - continued

From: http://www.cnblogs.com/jimmy/archive/2004/09/15/43402.aspx

Operate the mysql database in the .NET environment - continued

Finish

Operate the mysql database in the .NET environment

"When communicating with friends, I found Bytefx.Data why I couldn't display Chinese reasons and the way to solve (thanks to Venscent). The original Bytefx.data defaults to rely on the mysql default character set (Latin1) to encode, so display When Chinese is garbled. You can change the default character set of mysql: Add a line of default-character-set = GB2312 in "My.ini", as shown below: Of course, if you installed MySQL installed in other OS, you can Use the corresponding instructions to set this property. The result is OK pull .... Everyone can use this free Winter Winter pulling using this free Winter Winter pulling use Bytefx.data or some code of MySQL's official connector / net is as follows:

Using

System.windows.forms;

Using

System.data;

Using

Mysql.data.mysqlclient; mysqlconnection2.connectionstring

=

"

Connection timeout = 30; server = 192.168.8.112; user ID = zjmzs; password = zjmzs; port = 3306; data = popoface; pooling = true; min pool size = 3; Max pool size = 101

"

MysqlConnection2.open (); MySQLDataAdapter Adapter

=

New

MysqldataAdapter (); adapter.selectCommand

=

New

MySQLCommand

"

Select * from UploadCFD

"

, Mysqlconnection2; adapter.fill (dataset1);

In addition, in the http://www.cybercom.net/~zbrad/dotnet/mysql/ this place looked at his MySQL solution. Brad Merrill The people working in Microsoft mainly wrote a DLL calling mysql's libmysql.dll's interface, which is not a good method, but this has to be a function of the function in Libmysql.dll. In the mysql.cs provided by Brad Merrill, some commonly used functions have been written, but I don't try it in actually. If you are interested, you can try it. Let's take a look at the code of mysql.cs. :

Using

System;

Using

System.security;

Using

System.Runtime.InteropServices;

/ ** /

///