using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
namespace DataReader
{
class Class1
{
[STAThread]
static void Main(string[] args)
{
string strConn="Provider=SQLOLEDB;User ID=sa;Password=gatsol;Initial Catalog=vins;Data Source=211.236.186.207;";
string PdsBoardSQL =" Select Idx, Pwd, [Name], [Title], Num, MyRef, NewStep, NewLevel, Email, Url, RegDate, File1, File2, File3, pb.FormTypeID, ft.FormTypeName " +
" from PdsBoard as pb inner join FormType as ft on pb.FormTypeID=ft.FormTypeID ";
OleDbDataAdapter da = new OleDbDataAdapter(PdsBoardSQL, strConn);
DataTable tbl = new DataTable();
da.Fill(tbl);
//Find 메서드는PrimaryKey가 있어야만 동작을 할수 있다.
tbl.PrimaryKey = new DataColumn[] {tbl.Columns["idx"], tbl.Columns["FormTypeID"]};
object[] objCriteria = new object[] {1,1}; //idx=1, FormTypeID=1
DataRow row = tbl.Rows.Find(objCriteria);
if(row==null)
Console.WriteLine("행을 찾을수 없습니다");
else
Console.WriteLine("등록자 이름 : " + row["Name"]);
Console.WriteLine("등록자이메일 : " + row["Email"]);
Console.WriteLine("자료 제목 : " + row["Title"]);
Console.WriteLine("자료실 이름 : " + row["FormTypeName"]);
}
}
}