mysql class c#_C#支持MYSQL吗？

展开全部

你可以使用Microsoft ODBC.net来解决所有在Windows平台可用的数据库

1.首先安e69da5e6ba903231313335323631343130323136353331333332626161装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";

//使用Connector/ODBC连接到MySQL

OdbcConnection MyConnection = new OdbcConnection(MyConString); //打开连接

MyConnection.Open();

Console.WriteLine("\n !!! success, connected successfully !!!\n");

MyConnection.Close();

2.以下是一个控制台程序中使用MySQL的例子 using Console = System.Console;

using Microsoft.Data.Odbc; namespace myodbc3

{

class mycon

{

static void Main(string[] args)

{

try

{

//Connection string for Connector/ODBC 2.50

/*string MyConString = "DRIVER={MySQL};" +

"SERVER=localhost;" +

"DATABASE=test;" +

"UID=venu;" +

"PASSWORD=venu;" +

"OPTION=3";

*/

//Connection string for Connector/ODBC 3.51

string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +

"SERVER=localhost;" +

"DATABASE=test;" +

"UID=venu;" +

"PASSWORD=venu;" +

"OPTION=3";

//Connect to MySQL using Connector/ODBC

OdbcConnection MyConnection = new OdbcConnection(MyConString);

MyConnection.Open();

Console.WriteLine("\n !!! success, connected successfully !!!\n"); //Display connection information

Console.WriteLine("Connection Information:");

Console.WriteLine("\tConnection String:" + MyConnection.ConnectionString);

Console.WriteLine("\tConnection Timeout:" + MyConnection.ConnectionTimeout);

Console.WriteLine("\tDatabase:" + MyConnection.Database);

Console.WriteLine("\tDataSource:" + MyConnection.DataSource);

Console.WriteLine("\tDriver:" + MyConnection.Driver);

Console.WriteLine("\tServerVersion:" + MyConnection.ServerVersion); //Create a sample table

OdbcCommand MyCommand = new OdbcCommand("DROP TABLE IF EXISTS my_odbc_net",MyConnection);

MyCommand.ExecuteNonQuery();

MyCommand.CommandText = "CREATE TABLE my_odbc_net(id int, name varchar(20), idb bigint)";

MyCommand.ExecuteNonQuery(); //Insert

MyCommand.CommandText = "INSERT INTO my_odbc_net VALUES(10,'venu', 300)";

Console.WriteLine("INSERT, Total rows affected:" + MyCommand.ExecuteNonQuery());; //Insert

MyCommand.CommandText = "INSERT INTO my_odbc_net VALUES(20,'mysql',400)";

Console.WriteLine("INSERT, Total rows affected:" + MyCommand.ExecuteNonQuery()); //Insert

MyCommand.CommandText = "INSERT INTO my_odbc_net VALUES(20,'mysql',500)";

Console.WriteLine("INSERT, Total rows affected:" + MyCommand.ExecuteNonQuery()); //Update

MyCommand.CommandText = "UPDATE my_odbc_net SET id=999 WHERE id=20";

Console.WriteLine("Update, Total rows affected:" + MyCommand.ExecuteNonQuery()); //COUNT(*)

MyCommand.CommandText = "SELECT COUNT(*) as TRows FROM my_odbc_net";

Console.WriteLine("Total Rows:" + MyCommand.ExecuteScalar()); //Fetch

MyCommand.CommandText = "SELECT * FROM my_odbc_net";

OdbcDataReader MyDataReader;

MyDataReader = MyCommand.ExecuteReader();

while (MyDataReader.Read())

{

if(string.Compare(MyConnection.Driver,"myodbc3.dll") == 0) {

Console.WriteLine("Data:" + MyDataReader.GetInt32(0) + " " +

MyDataReader.GetString(1) + " " +

MyDataReader.GetInt64(2)); //Supported only by Connector/ODBC 3.51

}

else {

Console.WriteLine("Data:" + MyDataReader.GetInt32(0) + " " +

MyDataReader.GetString(1) + " " +

MyDataReader.GetInt32(2)); //BIGINTs not supported by Connector/ODBC

}

} //Close all resources

MyDataReader.Close();

MyConnection.Close();

}

catch (OdbcException MyOdbcException)//Catch any ODBC exception ..

{

for (int i=0; i < MyOdbcException.Errors.Count; i++)

{

Console.Write("ERROR #" + i + "\n" +

"Message: " + MyOdbcException.Errors[i].Message + "\n" +

"Native: " + MyOdbcException.Errors[i].NativeError.ToString() + "\n" +

"Source: " + MyOdbcException.Errors[i].Source + "\n" +

"SQL: " + MyOdbcException.Errors[i].SQLState + "\n");

}

}

}

}

}

３．使用数据集的例子OdbcConnection con = new OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};" +

"SERVER=glf;" +

"DATABASE=qxk_db;" +

"UID=root;" +

"PASSWORD=;" +

"OPTION=3");

da=new OdbcDataAdapter("select * from achi_eval",con);

ds=new DataSet();

da.Fill(ds,"customers");

dtSource = ds.Tables["customers"];

pageSize=20;

maxRec = dtSource.Rows.Count;

PageCount = maxRec / pageSize;

if ((maxRec % pageSize) > 0)

{

PageCount += 1;

}

currentPage = 1;

recNo = 0;

LoadPage();

已赞过

已踩过<

你对这个回答的评价是？

评论

收起