Database UI

I have to provide a UI, where the user can add new items in the DB.The DB has several fields and some of them are encrypted, butthe user should be able to view the decrypted data. I should also have the possibility to copy and paste an entire row or rows.The UI should look similar to the DB. I have tried the DB grid control, but I am not able to do much with it.

I am trying to filter a table type recordset in following way (directly call to DAO)
First derive a class CMyDatabase from CDaoDatabase, then add function SetFilter as follows (I am really not sure it's right or not):
void CMyDatabase::SetFilter(LPCTSTR szTable, LPCTSTR szFilter)
{
DAORecordset* pDAORecordset = NULL;
if (m_pDAORecordsets == NULL)
InitWorkspace();

try
{
DAO_CHECK(m_pDAORecordsets->get_Item(COleVariant(szTable, VT_BSTRT), &pDAORecordset));
DAO_CHECK(pDAORecordset->put_Filter(COleVariant(szFilter, VT_BSTRT).bstrVal));
}
... ...
}
The problem is m_pDAORecordsets is allways NULL. Can anyone help me out?
Thanks.

[sabari]

Maybe you have not initialised the Recordset object with a Database. Try CDAORecordset::Open
anad then access m_pDAORecordsets.