LVCOLUMN lvColumn;
int nCol;
char str[5][256]={"MAC","FLOOR","DIRECTION","DOOR_STATE","OPERATION MODE"};
int width[5]={100,30,50,80,100};
for( int i=4; i>=0; i--)
{
lvColumn.mask = LVCF_FMT|LVCF_TEXT|LVCF_WIDTH;
lvColumn.cx = width[i];
lvColumn.pszText = str[i];
nCol = m_StoreItems.InsertColumn(0, &lvColumn);
}
m_StoreItems.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
// OLE_DB 연결
CoInitialize(0);
AfxOleInit();
CDataSource m_DataSource;
CSession m_Session;
CCommand<CDynamicAccessor> m_Select;
CCommand<CNoAccessor, CNoRowset, CNoMultipleResults> m_Command;
HRESULT hr;
// SQL OLE DB 일경우
hr = m_DataSource.OpenFromInitializationString( L"Provider=SQLOLEDB.1;Password=패스워드;Persist Security Info=True;User ID=아이디;Initial Catalog=elevator_state;Data Source=IP주소" );
if(FAILED(hr))
{
AfxMessageBox("소스 초기화 실패");
return 0;
}
hr = m_Session.Open(m_DataSource);
if(FAILED(hr))
{
AfxMessageBox("세션 열기 실패");
return 0;
}
hr = m_Select.Open(m_Session, "SELECT * FROM STATE");
if (hr == S_OK)
{
m_Select.MoveFirst();
do{
LVITEM lvItem;
lvItem.mask = LVIF_TEXT;
lvItem.iItem = i;
lvItem.iSubItem = 0;
lvItem.pszText = (char*)m_Select.GetValue(1);
m_StoreItems.InsertItem(&lvItem);
m_StoreItems.SetItemText( i, 1, (char*)m_Select.GetValue(5));
m_StoreItems.SetItemText( i, 2, (char*)m_Select.GetValue(6));
m_StoreItems.SetItemText( i, 3, (char*)m_Select.GetValue(7));
m_StoreItems.SetItemText( i, 4, (char*)m_Select.GetValue(8));
i++;
}while (m_Select.MoveNext() == S_OK);
}
else
{
// Query문 또는 DB 연결에 문제가 있다!
}
m_Select.Close();
m_Select.ReleaseCommand();
// OLE_DB 종료
m_Session.Close();
m_DataSource.Close();
CoUninitialize();
Trackback 0 And
Comment 0
LVCOLUMN lvColumn;
int nCol;
char str[4][256]={"1","2","3","4"};
int width[4]={100,100,100,100};
for( int i=3; i>=0; i--)
{
lvColumn.mask = LVCF_FMT|LVCF_TEXT|LVCF_WIDTH;
lvColumn.cx = width[i];
lvColumn.pszText = str[i];
nCol = m_StoreItems.InsertColumn(0, &lvColumn);
}
m_StoreItems.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
for( i=0; i<10;i++)
{
LVITEM lvItem;
lvItem.mask = LVIF_TEXT;
lvItem.iItem = i;
lvItem.iSubItem = 0;
lvItem.pszText = "test";
m_StoreItems.InsertItem(&lvItem);
m_StoreItems.SetItemText( i, 1, "test2");
m_StoreItems.SetItemText( i, 2, "test3");
m_StoreItems.SetItemText( i, 3, "test4");
}
Trackback 0 And
Comment 0
