|
handle CBN_EDITCHANGE
what you see after UpdateData?
Kuphryn
|
|
|
|
|
How to prevent CListCtrl from hiding its scrollbars?
Thanks
|
|
|
|
|
Hi again
I'm trying to connect to an access db using ADO
i use some sample codes to perform a simple SELECT query and display them through a recordset. I've tryed really hard to make it work i've searched everywhere pls help me find the problem.
This is the code i use::
<br />
#include <windows.h><br />
#include <stdio.h><br />
#include <iostream.h><br />
<br />
#import "C:\Program Files\Common Files\System\ADO\msado15.dll" \<br />
no_namespace rename("EOF", "EndOfFile")<br />
<br />
void main(int argc, char* argv[])<br />
{<br />
<br />
HRESULT hr = S_OK;<br />
_ConnectionPtr m_pConn;<br />
try<br />
{<br />
HRESULT hr = m_pConn.CreateInstance(__uuidof(Connection));<br />
if (FAILED( hr ))<br />
cout<<"Can't create an intance of ADO.Connection"<<endl;<br />
<br />
if (FAILED( m_pConn->Open(_bstr_t("Provider=Microsoft.Jet.OLEDB.4.0;Data Source =ADOTestDB.MDB"),<br />
_bstr_t( "" ),<br />
_bstr_t( "" ), <br />
adModeUnknown )))<br />
<br />
cout<<"Can't open datasource"<<endl;<br />
<br />
<br />
_CommandPtr pCommand;<br />
pCommand.CreateInstance (__uuidof (Command));<br />
pCommand->ActiveConnection = m_pConn; <br />
pCommand->CommandText = "Select Name,Dept From Student";<br />
_RecordsetPtr pRecordset;<br />
pRecordset.CreateInstance (__uuidof (Recordset));<br />
pRecordset->CursorLocation = adUseClient;<br />
pRecordset->Open ( (IDispatch *) pCommand, vtMissing, adOpenStatic,<br />
adLockBatchOptimistic, adCmdUnknown);<br />
<br />
_bstr_t valField1;<br />
int valField2;<br />
pRecordset->MoveFirst();<br />
if (!pRecordset->EndOfFile)<br />
{<br />
while(!pRecordset->EndOfFile)<br />
{<br />
valField1 = pRecordset->Fields->GetItem("Name")->Value;<br />
valField2 = pRecordset->Fields->GetItem("Dept")->Value.intVal;<br />
printf("%d - %s\n",valField2,(LPCSTR)valField1);<br />
pRecordset->MoveNext();<br />
}<br />
}<br />
<br />
<br />
}catch( _com_error &ce )<br />
{<br />
printf("Error:%s\n",ce.Description);<br />
<br />
}<br />
m_pConn->Close();<br />
<br />
}<br />
i get an exeption
"Can't create an intance of ADO.Connection"
and the i asks if i want to debug
Pls help me i'm trying a lot to connect to a db and enything i do seems to be wrong
and the truth is that everytime i post a msg about C++ and ADO no one
replies.
pls i'm desparate
|
|
|
|
|
ADO is a set of COM objects. To use COM from any thread, you need to call CoInitialize (or for advanced users that won't run on W9x or ME, CoInitializeEx).
Try putting
CoInitialize(NULL);
after your declaration of hr,
move your connection pointer inside your try block [it's a smart pointer, and needs to go out of scope or be released before calling CoUninitialize()]
Add
CoUninitialize();
after your catch block.
Steve S
Developer for hire
|
|
|
|
|
Hey Thanks Steve is FINALLY WORKING!!!
thanks you Steve S i'm so happy i was about to give up
BTW do you know any good reference that i can use to learn about ADO and COM objects because using sample codes i cannot understand the reall structure of ADO
i just copy paste without understanding.
Thanks again Steve S i appreciate all the help
|
|
|
|
|
No problem;
I'm more of an OLEDB man myself, but SAMS had a "Database Programming in VC++" which I think covered most techniques. COM itself has a relatively small surface area to learn, but there are lots of things that you need to know. Best bet is to look for tutorials in places like CodeProject.
Steve S
Developer for hire
|
|
|
|
|
Thanks again i found that book of Sams and Db programming in 21 days the problem is that he use the MFC and wizards which i don't really understand either.
Maybe your right the best place to learn from is the web
BTW can i ask something else.
i need to execute a query like:
"Select Name,Dept From Student WHERE Name=? "
i want the query to get the name from a variable of type string.
"Select Name,Dept From Student WHERE Name=token//token is a variable of type string which get the value from a different function
how can i do that? di i need to use stored procedures?
Thanks again steve S
|
|
|
|
|
I'd suggest putting CoInitialize(NULL) in WinMain/InitInstance/whatever, and CoUninitialize() in respective counterparts, if the design allows it. CoInitialize(NULL) is time consuming (although not as bad on newer operating systems, as it was back in the 9x days), and is therefore best kept out of the loop so to speak.
--
100% natural. No superstitious additives.
|
|
|
|
|
I thought that's what I'd said, but did not explicitly make the point, so thanks for pointing it out.
Good practice is to keep as much as possible out of loops - just look at the different code produced with and without optimisations turned on 
Steve S
Developer for hire
|
|
|
|
|
Hey, I have been programming c++ for 4-5 years now (my real love is Java), but I am trying to make an mfc project (VS 2005) for the first time.
I went through the wizard and then made some extra dialog boxes making sure to name all of the compnents(dropdown boxes, textboxes, etc). Now I am trying to connect the dialog boxes and I am having some problems.
I have tried looking at some tutorials online, but am still having some problems.
I am trying to create a dialog box (Main_DIALOG) when "ok" is clicked on in the orginal box (LogOn_DIALOG).
Here is what I have now:
I know this is a lot of code to look at, but I really don't know where the problem is. The wizard wrrote most of the code and I am freaking hating that.
-----------------------------------------------------------
#pragma once
class CMyLogOnDialog : public CDialog
{
DECLARE_DYNAMIC(CMyLogOnDialog)
public:
CMyLogOnDialog(CWnd* pParent = NULL);
virtual ~CMyLogOnDialog();
enum { IDD = LogOn_DIALOG };
protected:
virtual void DoDataExchange(CDataExchange* pDX);
DECLARE_MESSAGE_MAP()
public:
afx_msg void OnBnClickedButton();
};
----------------------------------------
#pragma once
class CMyMainDialog : public CDialog
{
DECLARE_DYNAMIC(CMyMainDialog)
public:
CMyMainDialog(CWnd* pParent = NULL);
virtual ~CMyMainDialog();
enum { IDD = Main_DIALOG };
protected:
virtual void DoDataExchange(CDataExchange* pDX);
DECLARE_MESSAGE_MAP()
};
-------------------------------------------------
#include "stdafx.h"
#include "ECO.h"
#include "MyLogOnDialog.h"
#include "MyMainDialog.h"
IMPLEMENT_DYNAMIC(CMyLogOnDialog, CDialog)
CMyLogOnDialog::CMyLogOnDialog(CWnd* pParent )
: CDialog(CMyLogOnDialog::IDD, pParent)
{
}
CMyLogOnDialog::~CMyLogOnDialog()
{
}
void CMyLogOnDialog::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
}
BEGIN_MESSAGE_MAP(CMyLogOnDialog, CDialog)
ON_BN_CLICKED(LogOnOK_Button, &CMyLogOnDialog::OnBnClickedButton)
END_MESSAGE_MAP()
void CMyLogOnDialog::OnBnClickedButton()
{
CMyMainDialog dlg;
dlg.DoModal();
}
----------------------------------------------
#include "stdafx.h"
#include "ECO.h"
#include "MyMainDialog.h"
IMPLEMENT_DYNAMIC(CMyMainDialog, CDialog)
CMyMainDialog::CMyMainDialog(CWnd* pParent )
: CDialog(CMyMainDialog::IDD, pParent)
{
}
CMyMainDialog::~CMyMainDialog()
{
}
void CMyMainDialog::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
}
BEGIN_MESSAGE_MAP(CMyMainDialog, CDialog)
END_MESSAGE_MAP()
----------------------------------------------------
I don't get any error messages, but my second window doesn't popup. Did I put my action handler in the wrong class? Or am I just totally off here?
I am sorry for asking such a stupid question, but I am really just not getting it which is weird considering how fast I picked up c++ and Java (witout any wizards).
Feeling Stupid,
Brandy
|
|
|
|
|
Don't be discouraged by the wizards. They are a great help once you understand what they are doing for you (this is where most people get choked up with MFC, and why they think it is a horrible library ... it is actually quite good if you understand what is under the hood).
Now, looking at your code, nothing glaring stands out (other than not making your dialog IDs all caps and not checking the return value of DoModal ... but I can forgive those 
Open the "Main" dialog in the resource editor and make sure that the dialog's settings match that of your "Log in" dialog (basically, you want it to be a popup with a frame).
If you decide to become a software engineer, you are signing up to have a 1/2" piece of silicon tell you exactly how stupid you really are for 8 hours a day, 5 days a week
Zac
|
|
|
|
|
I am not sure where the problem lies still, but I found other problems as well.
I tried just to see if I could get the text out of the Password textbox stored as C_Password, defined in the file ECODlg.h. I included ECODlg.h, but when I tried this code:
void CMyLogOnDialog::OnBnClickedButton()
{
CString password;
c_Password.getWindowText(password);
CMyMainDialog dlg;
dlg.DoModal();
}
it will not compile. I get the error:
error C2065: 'c_Password' : undeclared identifier
|
|
|
|
|
whats type c_Password?
whitesky
|
|
|
|
|
It is a CEdit.
I copied all of the dialogboxes over to a new project and started rewritting all of the actionhandlers and for some reason it works now.?
|
|
|
|
|
Could it be case sensitivity?
You mentioned a C_Password textbox:
aei_totten wrote: C_Password, defined in the file ECODlg.h
But your code has a lower case c_Password:
aei_totten wrote: c_Password.getWindowText(password);
----------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
If you are still having problems displaying your main dialog, change the DoModal call to the following:
int result = mainDlg.DoModal();
And place a breakpoint on that line. If you get to the breakpoint, then check the return value for DoModal. If you don't get to it, it means your message map isn't set properly (check the ID for your button and make sure you have correctly mapped the handler for it).
As far as this new problem ... I'm assuming you have an Edit Box on the dialog and that you set its password property (e.g. show up as *'s). Make sure the c_Password variable (which I'm assuming is the edit control) is a member of your CMyLogOnDialog class (you will see a declaration like: CEdit c_Password; in its header file). Additionally, the DoDataExchange method should have a DDX_Control call with the ID for that edit control and the c_Password variable as parameters.
If you decide to become a software engineer, you are signing up to have a 1/2" piece of silicon tell you exactly how stupid you really are for 8 hours a day, 5 days a week
Zac
|
|
|
|
|
Is your message handler, OnBnClickedButton, called when you click the button?
Put a breakpoint there and see if your app breaks.
Your message map looks strange to me, but I haven't done VS2005 yet so I don't know what kind of spells the wizard does. Have you edited the message map yourself?
I would like to the following in the message map:
ON_BN_CLICKED( IDC_LOGON_BUTTON, OnBnClickedButton )
where IDC_LOGON_BUTTON is the resource ID of the button and OnBnClickedButton is the function pointer to the message handler.
--
Roger
It's supposed to be hard, otherwise anybody could do it!
Regarding CodeProject: "resistance is pointless; you will be assimilated"
|
|
|
|
|
Hi, everybody
I need a POP3 server code in C or C++. Could you please suggest me where I can find such code?
Thanks in advance
--
======
Arman
|
|
|
|
|
Hi,
I request u to kindly ans :
"How to place an edit box and dialog box on a window(SDI)in VC++ dot Net".
Thank you very much.
|
|
|
|
|
|
I would like to have a control (a list) to always be the full length of the application screen, no matter what size the app is. Is there an easy way to have the control resize based on what size the user's resolution is?
thanks in advance.
|
|
|
|
|
You can always use the GetSystemMetrics API with the Screen Width and Height values and do some math to size your control properly (I assume you don't want the control to take up the entire screen). Something like the following:
<br />
const int ScreenWidth = ::GetSystemMetrics(SM_CXSCREEN);<br />
const int ScreenHeight = ::GetSystemMetrics(SM_CYSCREEN);<br />
<br />
CRect ControlRect;<br />
ControlRect.top = 100;
ControlRect.left = 50;
ControlRect.right = ControlRect.left + 300;
ControlRect.bottom = ScreenHeight - 50;
<br />
wndMyControl.MoveWindow(&ControlRect, TRUE);<br />
If you wanted the control on the right side, use the width variable and subtract the desired value from the starting place (and adjust your left value accordingly).
If you decide to become a software engineer, you are signing up to have a 1/2" piece of silicon tell you exactly how stupid you really are for 8 hours a day, 5 days a week
Zac
|
|
|
|
|
I suggest use Zac Howland answer and also you can use WM_SIZE with this code
for example if your window has WS_THICKFRAME or...
whitesky
|
|
|
|
|
hi
check out this article "http://www.codeproject.com/dialog/layoutmgr.asp"
hope u will find it useful...
There are two ways of meeting difficulties :you alter the difficulties, or u alter yourself to meet them(Phyllis Bottome).
regards
harilal
|
|
|
|
|
hi
How can i read the physical memory from a perticular address
in windows 98.
thanx
nirmal
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
