using System.Data.Odbc; string connectionString = "Driver={MySQL ODBC 8.0 Unicode Driver};" + "Server=localhost;" + "Database=myDatabase;" + "Uid=myUsername;" + "Pwd=myPassword;"; OdbcConnection conn = new OdbcConnection(connectionString); conn.Open();
using System.Data.Odbc; string connectionString = "Driver={MySQL ODBC 8.0 Unicode Driver};" + "Server=localhost;" + "Database=myDatabase;" + "Uid=myUsername;" + "Pwd=myPassword;"; OdbcConnection conn = new OdbcConnection(connectionString); conn.Open(); string query = "SELECT * FROM myTable"; OdbcCommand cmd = new OdbcCommand(query, conn); OdbcDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Console.WriteLine(reader["column1"] + ", " + reader["column2"]); } reader.Close(); cmd.Dispose(); conn.Close();In this example, we are querying a MySQL table and retrieving all records. We are creating a new OdbcCommand object by passing the SQL command and the open OdbcConnection object. Then, we are using an OdbcDataReader to iterate through the records and display the values of two columns. In summary, the System.Data.Odbc package library provides classes to facilitate working with ODBC database connections in C#. It enables you to connect to various data sources, issue SQL commands, and retrieve data from them using OdbcConnection, OdbcCommand, and OdbcDataReader classes.