간단한 SQL Server OLEDB 예제

string ConnectionString = "Provider=SQLOLEDB;Server=.;database=PGSMS;Integrated Security=SSPI;"; String sSQL = "select 아이디, 노드명 from Nodes"; OleDbConnection oConn = new OleDbConnection(ConnectionString); oConn.Open(); OleDbCommand oCmd = new OleDbCommand(sSQL, oConn); OleDbDataReader oReader = oCmd.ExecuteReader(); int idxID = oReader.GetOrdinal("아이디"); int idxNodeName = oReader.GetOrdinal("노드명"); while (oReader.Read()) { Console.WriteLine("{0} {1}", oReader.GetValue(idxID), oReader.GetValue(idxNodeName)); }