Csharp/CSharp Tutorial/ADO.Net/OdbcDataReader
Версия от 18:31, 26 мая 2010; (обсуждение)
Read result set from OdbcDataReader
<source lang="csharp">using System; using System.Data; using System.Data.Odbc; class MainClass {
static void Main(string[] args) { string connString = @"dsn=northwindodbc"; string sql = @"select * from employee"; OdbcConnection conn = null; OdbcDataReader reader = null; try { conn = new OdbcConnection(connString); conn.Open(); OdbcCommand cmd = new OdbcCommand(sql, conn); reader = cmd.ExecuteReader(); Console.WriteLine("Querying database {0} with query {1}\n", conn.Database, cmd.rumandText ); while(reader.Read()) { Console.WriteLine("{0} | {1}", reader["FirstName"].ToString().PadLeft(10) , reader[1].ToString().PadLeft(10) ); } } catch (Exception e) { Console.WriteLine("Error: " + e); } finally { reader.Close(); conn.Close(); } }
}</source>