Hello there,
I need a little bit of help by getting a table to work.
BOOL CPrakt04Dlg::OnInitDialog()
{
CDialog::OnInitDialog();
SetIcon(m_hIcon, TRUE);
SetIcon(m_hIcon, FALSE);
Tabelle.InsertColumn(0,_T("Number"),LVCFMT_LEFT,35);
Tabelle.InsertColumn(1, _T("Name"), LVCFMT_CENTER, 60);
Tabelle.InsertColumn(2, _T("Age"), LVCFMT_LEFT,25);
Tabelle.InsertColumn(3, _T("Score"), LVCFMT_LEFT, 70);
int nItem;
nItem = Tabelle.InsertItem(0, _T("1"));
Tabelle.SetItemText(nItem, 1, _T("Brith"));
Tabelle.SetItemText(nItem, 2, _T("54"));
Tabelle.SetItemText(nItem, 3, _T("89"));
nItem = Tabelle.InsertItem(0, _T("2"));
Tabelle.SetItemText(nItem, 1, _T("Louis"));
Tabelle.SetItemText(nItem, 2, _T("50"));
Tabelle.SetItemText(nItem, 3, _T("110"));
nItem = Tabelle.InsertItem(0, _T("3"));
Tabelle.SetItemText(nItem, 1, _T("Magret"));
Tabelle.SetItemText(nItem, 2, _T("12"));
Tabelle.SetItemText(nItem, 3, _T("38"));
nItem = Tabelle.InsertItem(0, _T("4"));
Tabelle.SetItemText(nItem, 1, _T("Martin"));
Tabelle.SetItemText(nItem, 2, _T("30"));
Tabelle.SetItemText(nItem, 3, _T("70"));
return TRUE;
}
#if defined(_DEVICE_RESOLUTION_AWARE) && !defined(WIN32_PLATFORM_WFSP)
void CPrakt04Dlg::OnSize(UINT , int , int )
{
if (AfxIsDRAEnabled())
{
DRA::RelayoutDialog(
AfxGetResourceHandle(),
this->m_hWnd,
DRA::GetDisplayMode() != DRA::Portrait ?
MAKEINTRESOURCE(IDD_PRAKT04_DIALOG_WIDE) :
MAKEINTRESOURCE(IDD_PRAKT04_DIALOG));
}
}
#endif
void CPrakt04Dlg::OnBnClickedBnTbe()
{
int error;
sqlite3 *database;
error=sqlite3_open("Database01.db3", &database);
sqlite3_stmt *statement;
error=sqlite3_prepare(database, "CREATE TABLE example (number INTEGER,name TEXT,age INTEGER,score INTEGER);", -1, &statement, 0);
error=sqlite3_step(statement);
error=sqlite3_exec(database,"insert into example values (5,'david',20,8);",NULL,NULL,NULL);
error=sqlite3_finalize(statement);
error=sqlite3_close(database);
}
void CPrakt04Dlg::OnLvnItemchangedTb(NMHDR *pNMHDR, LRESULT *pResult)
{
LPNMLISTVIEW pNMLV = reinterpret_cast<LPNMLISTVIEW>(pNMHDR);
*pResult = 0;
}
This is my code until now, i need help so i can see the "insert into exampe values (5,'david',20,8);" in my ListCtrl.