|
You can find here[^] a project sample of how to connect to MySQL database through ODBC ... in fact, to any kind of dababase through ODBC.
|
|
|
|
|
Thank you.
Could you please suggest me a good book for MFC vc++.
|
|
|
|
|
|
Thanks for the help!
I'am having trouble understanding why it does this
BOOL CMyApp::InitInstance(){
..........
..........
CWinApp::InitInsatnce();
..........
..........
}
Could you please explain why do we need to call two InitInstance() and what is the main reason?
|
|
|
|
|
When you derive from a class and override one of its methods, it's common, and sometimes required, to call the base class implementation.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
|
|
|
|
|
Thanks for the reply. 
If you don't mind, could you please elaborate the "sometime required, to call the base class implementation" part with some example.
|
|
|
|
|
CMyApp is derived from CWinApp, so the line
CWinApp::InitInsatnce();
simply call the InitInstance method from parent CWinApp, which is the base implementation of CMyApp::InitInstance().
"sometime required" sometime is necesarry to call this base implementation, sometime not
|
|
|
|
|
Thanks
I am creating a simple MFC application. That has a search box which accept both string and integers to retrieve data from the Mysql database and display in the list box.
Please guide me how to create a search box that accepts when entered string and when entered integers.
|
|
|
|
|
Anything you type into a text box is a string, whether letters, numbers or special characters. If you want to use numeric text as integer values then you need to convert them with one of the conversion methods. See Data Conversion | Microsoft Docs[^].
|
|
|
|
|
Thank you for the information .
|
|
|
|
|
Hello,
I created an MFC dialog application which is connected to MySql database. I wanted to create a search button/Search query for database.
Could you give me some pointers for creating functions for the same which accept string as well as Integers. Thanks.
I've read about atoi(), but still having problem.
And for displaying the search result, which one is better to use listbox or listcontrol.
|
|
|
|
|
If you have more than one column data to display, I would use CListCtrl[^] or CMFCListCtrl[^]
If you want to use an edit to use it for SQL statement, then give more details about what you intend to do there (e.g. sold > 1000 ?)
|
|
|
|
|
SQl is not greater than 1000. I wanted to create a simple application first. Like for example.. I have a table with ID(primary Key), Name, DOB...etc columns.
What I wanted to create is a search box in the dialog application. when I type the Name in the search box it will display the result in the listbox/list control box. Similarly when I enter the ID in the search box it will return the same.
|
|
|
|
|
You can use CListCtrl or derivated to display db data.
In search box you can test the user input with is_digit[^] and act accordingly (if is number then use ID to get data, or if is not number, use string to get the name and so on.
|
|
|
|
|
Thank you for always helping. I really appreciate the help
I have created a search function and now it's displaying in the CListCtrl and working the way I wanted.
I'll try to extend the functionality like if I select the result in the CListCtrl it will take me to another dialog that contains the details of the selected. If I have any doubt i'll post it here.
Thanks again
|
|
|
|
|
You are welcome
|
|
|
|
|
Hello I'm back again 
How to get all the data present in a row displayed in the ListCtrl from the database and display those data in the next dialog?
For example:- There are name, age,dob..etc in a row.. when I select this row and press the select button.. It will take me to another where all this details will be display.
If you don't mind could you please give example.
Thanks.
|
|
|
|
|
Then you take all your list control data with CListCtrl::GetItemText[^] and you simply put them into next dialog, just like that:
CNextDlg dlg;
dlg.m_sName = m_ListCtrl.GetItemText(...);
dlg.m_sAge = m_ListCtrl.GetItemText(...);
dlg.m_sDOB = m_ListCtrl.GetItemText(...);
dlg.DoModal();
|
|
|
|
|
Thank you.
void CMyDlg::ResetListControl() {
m_ListControl.DeleteAllItems();
int iNbrOfColumns;
CHeaderCtrl* pHeader = (CHeaderCtrl*)m_ListControl.GetDlgItem(0);
if (pHeader) {
iNbrOfColumns = pHeader->GetItemCount();
}
for (int i = iNbrOfColumns; i >= 0; i--) {
m_ListControl.DeleteColumn(i);
}
}
I particularly don't understand this line :
CHeaderCtrl* pHeader = (CHeaderCtrl*)m_ListControl.GetDlgItem(0);
Could you please explain this line of code. Thanks
|
|
|
|
|
I think that line should be:
CHeaderCtrl* pHeader = m_ListControl.GetHeaderCtrl();
See here[^].
However, that line retrieve first control item from m_ListCtrl object ... does working that line ? I didn't met such approach ...
|
|
|
|
|
Confidence that I have solved all strange errors here, I come back with some issue generated by a legacy C code for linux, code that I intend to use it in a MFC app in windows OS.
Ok. I have a simple code:
int nRespond = _open(device, 020);
UINT err = ::GetLastError();
where devide is const char* and has value C (or D:, or E: )
The nRespond is -1 and err has value 5, which is mean Access is denied. What could be the problem here ? I ran the test app as administrator mode (ran from VS2017 as admin mode).
|
|
|
|
|
The problem appears to be that you are expecting Linux code to work on Windows. The _open function opens a file - on unix systems you can open directories and devices as files, but not on Windows.
If you're lucky the code is actually expecting a normal file and you just passed in a device letter by mistake. Otherwise you will have to port the code, replacing the Linux system functions with code that does the same thing on Windows.
|
|
|
|
|
|
So I cannot open disk with this function ? ... this is the original code ... strange ...
|
|
|
|
|
_Flaviu wrote: this is the original code
From where?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
