C / C++ / MFC

Re: Hot toconnect databases to dialog based project

3-Apr-06 3:00

Hi friends,
I've done a project which is dialog based application.Now I need to connect databases.So how do I proceed now.Do Ineed to redo the whole project in SDI.Pls help me in solving this problem.

bye

swapna_signsin

Waldermort3-Apr-06 3:05

Waldermort

3-Apr-06 3:05

What sort of database are you trying to connect to?

Re: Hot toconnect databases to dialog based project

swapna_signsin3-Apr-06 4:05

Re: Hot toconnect databases to dialog based project

3-Apr-06 4:05

MSACCESS

thatsme_cool3-Apr-06 3:07

thatsme_cool

3-Apr-06 3:07

I don't think so
In order to connect to Data base visit this link
http://www.codeproject.com/database/connectionstrings.asp[^]

Re: Hot toconnect databases to dialog based project

David Crow3-Apr-06 3:56

Re: How toconnect databases to dialog based project

3-Apr-06 3:56

swapna_signsin wrote:
Now I need to connect databases.So how do I proceed now.

If you already have a DSN created, just derive a class from CRecordset using ClassWizard (Ctrl+W).

swapna_signsin wrote:
Do Ineed to redo the whole project in SDI.

No, not at all.

"Let us be thankful for the fools. But for them the rest of us could not succeed." - Mark Twain

"There is no death, only a change of worlds." - Native American Proverb

swapna_signsin3-Apr-06 4:17

Re: How toconnect databases to dialog based project

3-Apr-06 4:17

Thanx for the reply,
but how do u create a DSN in Dialog based application.I mean how do u make use of ODBC Connection,bcoz u don't have a document/view when u'r using dialog based.

David Crow3-Apr-06 4:39

3-Apr-06 4:39

swapna_signsin wrote:
but how do u create a DSN

Use SQLConfigDataSource().

swapna_signsin wrote:
I mean how do u make use of ODBC Connection...

CRecordset handles the details for you. Just derive a class from it.

swapna_signsin wrote:
...u don't have a document/view when u'r using dialog based.

Whether you use document/view or not is irrelevant.

"Let us be thankful for the fools. But for them the rest of us could not succeed." - Mark Twain

"There is no death, only a change of worlds." - Native American Proverb

How do u connect to DSN

swapna_signsin3-Apr-06 4:34

3-Apr-06 4:34

HI,
Actually Iam a beginner,Sorry to trouble u again,So how do u connect to DSN in Dialog Based applications,bcoz u don't have a Doc/View in this and u can't connect ODBC thru that.I've to connect to MSACCESS database.

Pls do reply,
bye

swapna_signsin

David Crow3-Apr-06 4:45

3-Apr-06 4:45

swapna_signsin wrote:
So how do u connect to DSN in Dialog Based applications...

In exactly the same way you would in any other application.

swapna_signsin wrote:
I've to connect to MSACCESS database.

After you've got a DSN created (see here for an example), use ClassWizard to derive a class from CRecordset.

"Let us be thankful for the fools. But for them the rest of us could not succeed." - Mark Twain

"There is no death, only a change of worlds." - Native American Proverb

swapna_signsin3-Apr-06 5:24

3-Apr-06 5:24

Hi again,
I've tried it and I get the following errors :

1. 'CRecordSet' is not a class or a namespace namefor foll code: CRecordset::Dump(dc);
CRecordset::AssertValid();
2.'CFieldExchange':Undeclared Identifier
3.'CDatabase': Undeclared Identifier
and many of taht sort.

swapna_signsin

David Crow3-Apr-06 5:28

3-Apr-06 5:28

You failed to include afxdb.h.

"Let us be thankful for the fools. But for them the rest of us could not succeed." - Mark Twain

"There is no death, only a change of worlds." - Native American Proverb

swapna_signsin3-Apr-06 5:54

3-Apr-06 5:54

Thanx,I'll try it and reply soon.

bye

swapna_signsin

PostNcDestroy() question

ns3-Apr-06 2:57

3-Apr-06 2:57

I have

CDialog::PostNcDestroy();

m_pParentWnd->SendMessage(UDM_LISTCLOSED,0,0);

delete this;

and in the .h file

// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CTargetInfo)
	public:
	virtual BOOL OnInitDialog(); // called first time after construct

	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	virtual void PostNcDestroy();

	//}}AFX_VIRTUAL

The dialog was created by:

if(!m_tgtInfo)
{
    m_tgtInfo = new CTargetInfo(this, caseStudy);
    if(!m_tgtInfo) return true;
    m_tgtInfo->Create(IDD_DLGTGTINFO, (CWnd*)this);
    m_tgtInfo->ShowWindow(SW_SHOW);
}

When I close this modeless dialog, execution does not enter the PostNcDestroy function. However if I close the whole app, then the code does go into this function. What am I missing? I looked at sample code and there does not seem to be anything else I need to do... Confused | :confused:

thanks,
sb

-- modified at 9:00 Monday 3rd April, 2006

David Crow3-Apr-06 3:54

3-Apr-06 3:54

ns wrote:
CDialog::PostNcDestroy();
delete this;

Switch these two statements.

ns wrote:
When I close this modeless dialog, execution does not enter the PostNcDestroy function.

Have you called m_tgtInfo->DestroyWindow()?

"Let us be thankful for the fools. But for them the rest of us could not succeed." - Mark Twain

"There is no death, only a change of worlds." - Native American Proverb

ns3-Apr-06 4:00

3-Apr-06 4:00

When am I supposed to call m_tgtInfo->destroyWindow()? The user closes m_tgtInfo at which point I was trying to send a message to the parent (which instantiated m_tgtInfo)
thanks for helping,
sb

David Crow3-Apr-06 4:35

3-Apr-06 4:35

ns wrote:
When am I supposed to call m_tgtInfo->destroyWindow()?

When you want to dismiss the modeless dialog.

"Let us be thankful for the fools. But for them the rest of us could not succeed." - Mark Twain

"There is no death, only a change of worlds." - Native American Proverb

ns3-Apr-06 4:41

3-Apr-06 4:41

A miscommunication, I think.
The user closes the m_tgtInfo dialog using the system menu at the upper right corner (the cross). I don't dismiss it with code. Am I still missing your point? When the cross is clicked, I thought the postNcDestroy() function would run, but it doesn't. Thanks for your patience.
sb

David Crow3-Apr-06 5:16

3-Apr-06 5:16

Do you have the following:

void CTargetInfo::OnOK()
{
    DestroyWindow();
}
 
void CTargetInfo::OnCancel()
{
    DestroyWindow();
}
 
void CTargetInfo::OnClose()
{
    DestroyWindow();
}

"Let us be thankful for the fools. But for them the rest of us could not succeed." - Mark Twain

"There is no death, only a change of worlds." - Native American Proverb