================================ Outline ====================================
ADO.NET - 데이터 가져오기
----------------------------------------------------------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.OleDb;
using System.Data.Sql;
using System.Data.SqlClient;
namespace datareader
{
class Program
{
static void Main(string[] args)
{
string StrSQL =
//데이터 베이스 문자열
@"Provider = Microsoft.Jet.OleDb.4.0; Data Source = D:\윤재희\Visual Studio 2013\Projects\20150619\20150619\Human.mdb";
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = StrSQL;
conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM HumanInfo", conn);
OleDbDataReader read = cmd.ExecuteReader();
Console.WriteLine("Name Age Phone No.");
while(read.Read())
{
Console.WriteLine(read[1] + "\t" +
read[2] + "\t" +
read[3]);
}
}
}
} |
