c# odbcconnection mdb

[th80]

c'è qualcuno che mi può fornire del codice esempio per connetermi ad un database access (mdb)
e fare una semplicissima select???


grazie

[riccardone]

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()) {
Response.Write(myReader.GetInt32(0) + ", " + myReader.GetString(1));
}
// always call Close when done reading.
myReader.Close();
// Close the connection when done with it.
myConnection.Close();


http://msdn.microsoft.com/library/de...classtopic.asp

[albgen]

ti consiglio di usare oledb in quanto piu veloce