here i struck up while doing my application
i am doing a small app which is MFC and SDI
i used dialog box to insert edit boxes ,comboboxees and datagrid and ado control which binded
what i need is if i entered any text in edit box and click on search button the result will be displyed in datagrid
i mean sorting (ex: id i entered "p" in editbox the datagrid have to show the names staring with "p"
void Dlg1::OnSearch()
{
CADODatabase* pAdoDb = new CADODatabase();
CString strConnection = _T("");
strConnection = _T("Provider=Microsoft.Jet.OLEDB.4.0;"
"Data Source=C:\\Final\\employeeData.mdb");
pAdoDb->SetConnectionString(strConnection);
if(pAdoDb->Open())
{
CString strEmpFirstName;
//GetDlgItem(IDC_EMPID)->GetWindowText(strEmpID);
GetDlgItem(IDC_FIRSTNAME)->GetWindowText(strEmpFirstName) ;
CString strQuery;
strQuery = ("SELECT * FROM empMaster where FirstName='PRABHAT'");
//LIKE '%" + strEmpFirstName + "%'";
pAdoDb->Execute(strQuery);
m_DataControl.Refresh();
pAdoDb->Close();
}
delete pAdoDb;
/*CString strEmpFirstName,strQuery;
GetDlgItem(IDC_FIRSTNAME)->GetWindowText(strEmpFirstName) ;
if(strEmpFirstName.IsEmpty())
{
MessageBox("Enter First Name to serach");
GetDlgItem(IDC_FIRSTNAME)->SetFocus();
//C_Recordset.m_strSort= "LastName DESC, FirstName DESC";
strQuery = "SELECT * FROM empMaster where FirstName LIKE '%" + strEmpFirstName + "%'";
m_DataControl.ExecuteDlgInit(strQuery);
m_DataControl.Refresh();
//GetDlgItem(IDC_ADODC1)->RecordSource = strQuery;
}*/
//C_Recordset.m_DataControl= "LastName DESC, FirstName DESC";
// TODO: Add your control notification handler code here
}
-------------
tis
|