急请教一个ASP.NET and MySQL 的问题我安装了ODBC data provider
可是when i use
using Microsoft.Data.Odbc;
还是说 The type or namespace name 'Data' does not exist in the class or namespace 'Microsoft' (are you missing an assembly reference?)
芬特死了
一上午了
那位帮忙看看？
谢谢~~~
无语了....
应该用 using System.Data.Odbc
这里贴code会remove whitespace, 看起来比较麻烦. 你可以参考.NET Framewkrok SDK Documentation. 只要你的机器上装了.NET Framework, 就可以从"Start"里找到.
public void ReadMyData(string myConnString) {
string mySelectQuery = "SELECT OrderID, CustomerID FROM Orders";
OdbcConnection myConnection = new OdbcConnection(myConnString);
OdbcCommand myCommand = new OdbcCommand(mySelectQuery,myConnection);
myConnection.Open();
OdbcDataReader myReader;
myReader = myCommand.ExecuteReader();
// Always call Read before accessing data.
while (myReader.Read()) {
Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1));
}
// always call Close when done reading.
myReader.Close();
// Close the connection when done with it.
myConnection.Close();
}
这里贴code会remove whitespace, 看起来比较麻烦. 你可以参考.NET Framewkrok SDK Documentation. 只要你的机器上装了.NET Framework, 就可以从"Start"里找到.
public void ReadMyData(string myConnString) {
string mySelectQuery = "SELECT OrderID, CustomerID FROM Orders";
OdbcConnection myConnection = new OdbcConnection(myConnString);
OdbcCommand myCommand = new OdbcCommand(mySelectQuery,myConnection);
myConnection.Open();
OdbcDataReader myReader;
myReader = myCommand.ExecuteReader();
// Always call Read before accessing data.
while (myReader.Read()) {
Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1));
}
// always call Close when done reading.
myReader.Close();
// Close the connection when done with it.
myConnection.Close();
}
Freedom is slavery.
Ignorance is strength.
Huasing Association 1999 - 2013