MS‘s BUG？ why can't get value from excel? - C / C++ / MFC Discussion Boards

How to create a custom list control in MFC ?

shah1864-Jan-09 18:08

4-Jan-09 18:08

How to create a custom list control in MFC which has following implemented :

Multicolumn sorting(time , text , numbers) .
Column coloring and dragging .
Set cell padding.
Subitem editing .

Please provide me with the code for the custom list control.

Re: How to create a custom list control in MFC ?

Hamid_RT4-Jan-09 18:36

Hamid_RT

4-Jan-09 18:36

Is this[^] helpful?

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )

Re: How to create a custom list control in MFC ?

Maximilien5-Jan-09 2:55

Maximilien

5-Jan-09 2:55

I would use a "grid" type control instead of a list type control (CListCtrl or CListBox).

have a look at either :

Chris Maunder's Grid[^]

or

The Ultimate Grid[^]

using CRichEditCtrl DisplayBand() function.

Prasann Mayekar4-Jan-09 17:55

Prasann Mayekar

4-Jan-09 17:55

i am trying to use the DisplayBand() function of CRichEditCtrl to print its contents on a memory DC and then displaying it elsewhere on a dialog. it displays fine all the formatting as well but the problem is that it is displaying a white background.

i want to remove the white bkgnd and make it transparent.

does any one know how to do it?

thanks

Re: using CRichEditCtrl DisplayBand() function.

Hamid_RT4-Jan-09 18:39

Hamid_RT

4-Jan-09 18:39

See here[^] and questions on the bottom of article.

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )

Removing else in this statements How?

monsieur_jj4-Jan-09 15:14

monsieur_jj

4-Jan-09 15:14

Hi all,

I had my code reviewed and I had a comment that its best to remove the else in this statements:

LRESULT CMainDlg::OnInstall(WORD, WORD wID, HWND, BOOL& )
{	
	string LaunchInstaller;
	string InstallFolder;
	InstallClass installclass;

	TCHAR tcItemText[MAXBYTES];

	if(UpdateList.GetItemText(Select, tcItemText, MAXBYTES))
	{
	InstallFolder = tcItemText;
	LaunchInstaller = installclass.ConstructInstallerKey(IDS_MANAGEKEY, InstallFolder);
		if (installclass.InstallUpdate(LaunchInstaller.c_str())) 
		{
			return 0;
		}
		else 
		{
			LaunchInstaller = installclass.ConstructInstallerKey(IDS_RERITEKEY, InstallFolder);
			if (installclass.InstallUpdate(LaunchInstaller.c_str())) 
			{
				return 0;
			}
			else
			{
				LaunchInstaller = installclass.ConstructInstallerKey(IDS_RERITEASIANKEY, InstallFolder);
				if (installclass.InstallUpdate(LaunchInstaller.c_str())) 
				{
					return 0;
				}
				else
				{
				LaunchInstaller = installclass.ConstructInstallerKey(IDS_RERITECHINAKEY, InstallFolder);
					if (installclass.InstallUpdate(LaunchInstaller.c_str())) 
					{
						return 0;
					}
				}
			}
		}
	}
	else
	{
    MessageBox ( _T("Please choose an item to install"), _T("Redmap Update Manager"), MB_ICONWARNING );
	}
	return 0;
}

Any suggestions on how the code should look like?

Thanks,
Jayjay

Re: Removing else in this statements How?

David Crow4-Jan-09 15:59

David Crow

4-Jan-09 15:59

LRESULT CMainDlg::OnInstall(WORD, WORD wID, HWND, BOOL& )
{    
    string LaunchInstaller;
    string InstallFolder;
    InstallClass installclass;
    TCHAR tcItemText[MAXBYTES];
 
    if(UpdateList.GetItemText(Select, tcItemText, MAXBYTES))
    {
        InstallFolder = tcItemText;
 
        LaunchInstaller = installclass.ConstructInstallerKey(IDS_MANAGEKEY, InstallFolder);
        if (installclass.InstallUpdate(LaunchInstaller.c_str())) 
            return 0;
 
        LaunchInstaller = installclass.ConstructInstallerKey(IDS_RERITEKEY, InstallFolder);
        if (installclass.InstallUpdate(LaunchInstaller.c_str())) 
            return 0;
 
        LaunchInstaller = installclass.ConstructInstallerKey(IDS_RERITEASIANKEY, InstallFolder);
        if (installclass.InstallUpdate(LaunchInstaller.c_str())) 
            return 0;
 
        LaunchInstaller = installclass.ConstructInstallerKey(IDS_RERITECHINAKEY, InstallFolder);
        if (installclass.InstallUpdate(LaunchInstaller.c_str())) 
            return 0;
    }
    else
    {
        MessageBox(_T("Please choose an item to install"), _T("Redmap Update Manager"), MB_ICONWARNING);
    }
 
    return 0;
}

"Love people and use things, not love things and use people." - Unknown

"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

MS‘s BUG？ why can't get value from excel?

ZhiLiangLin4-Jan-09 14:51

ZhiLiangLin

4-Jan-09 14:51

i want to get value from excel,for example:
COLUMN1 COLUMN2
----------------
123 456
ABC DEF
123 ABC
EFG HIJ

like this,i can't get '123' ,but i can get 'ABC'.
my code :
void ReadTrustListFromExcel(CString sFile)
{
CDatabase database;
CString sSql;
CString sItem1, sItem2;
CString sDriver;
CString sDsn;

sDriver = GetExcelDriver();//GetExcelDriver();
if (sDriver.IsEmpty())
{
return;
}

sDsn.Format(_T("ODBC;DRIVER={%s};DSN='';DBQ=%s"), sDriver, sFile);
TRY
{
database.Open(NULL, false, false, sDsn);
CRecordset recset(&database);

sSql.Format(_T("SELECT * FROM [%s$A1:IV65535]"),_T("EmailSheet"));

recset.Open(CRecordset::forwardOnly, sSql, CRecordset::readOnly);

while (!recset.IsEOF())
{
recset.GetFieldValue(short(0), sItem1);
recset.GetFieldValue(short(1), sItem2);
TRACE(_T("name:%s,addr:%s\r\n"),sItem1,sItem2);
recset.MoveNext();
}
database.Close();
}
CATCH(CDBException, e)
{
TRACE(_T("ERROR"));
}
END_CATCH;

Re: MS‘s BUG？ why can't get value from excel?

David Crow4-Jan-09 16:06

David Crow

4-Jan-09 16:06

ZhiLiangLin wrote:
sDsn.Format(_T("ODBC;DRIVER={%s};DSN='';DBQ=%s"), sDriver, sFile);

Is the value of sDsn correct?

ZhiLiangLin wrote:
sSql.Format(_T("SELECT * FROM [%s$A1:IV65535]"),_T("EmailSheet"));

Have you tried:

sSql.Format(_T("SELECT * FROM [%s$A1:B4]"), _T("EmailSheet"));

Does it have anything to do with those cells containing numbers? Do any of the rows read correctly?

"Love people and use things, not love things and use people." - Unknown

"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

Re: MS‘s BUG？ why can't get value from excel?

ZhiLiangLin4-Jan-09 18:21

ZhiLiangLin

4-Jan-09 18:21

the api 'getfieldvalue' can't get the value.

Re: MS‘s BUG？ why can't get value from excel?

David Crow5-Jan-09 3:56

David Crow

5-Jan-09 3:56

So have you used the debugger to step into that method to find out why?

"Love people and use things, not love things and use people." - Unknown

"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

Just-In-Time Debugger

Larry Mills Sr4-Jan-09 14:51

Larry Mills Sr

4-Jan-09 14:51

I had to re-install VS2008 when I re-installed the operating system. Somehow the "Just-In-Time Debugger" de not get installed. I tried going to Microsoft downloads for it and all they offer is VS20088 SP1. Every time I installed VS2008 SP1 it messed VS2008 up so I won't install it. Does anyone know how I can get a copy of the "Just-In-Time Debugger" from microsoft?(Microsoft Script Debugger is another name for it).

A C++ programming language novice, but striving to learn

Re: Just-In-Time Debugger

ThatsAlok5-Jan-09 0:24

ThatsAlok

5-Jan-09 0:24

microsoft bug team Smile | :)

will surly reply you back on this issue!

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
Never mind - my own stupidity is the source of every "problem" - Mixture

cheers,
Alok Gupta
VC Forum Q&A :- I/IV
Support CRY- Child Relief and You

Adobe GIL - any experience to share?

islobodan4-Jan-09 13:05

islobodan

4-Jan-09 13:05

Anyone have any experience and thoughts to share about Adobe GIL
GIL[^]

I'm considering GIL library as replacement for GDI+ for my ongoing project.

Thanks

How to make the cursor move to the next ctrol of EDIT automatic?

titan_sky_king4-Jan-09 12:55

titan_sky_king

4-Jan-09 12:55

I have a DIALOG project with more than fifty EDIT.I want to make the cursor move to the next EDIT when the length of each EDIT get five.

But I don't know how to realize it.Please help me!

Thanks!

Re: How to make the cursor move to the next ctrol of EDIT automatic?

Richard Andrew x644-Jan-09 14:08

Richard Andrew x64

4-Jan-09 14:08

You could handle the KeyPress event and call GetWindowText on the edit control to count how many chars have been entered.

Then, when 5 chars have been entered, call SetFocus on the next edit control to move the cursor there.

Re: How to make the cursor move to the next ctrol of EDIT automatic?

titan_sky_king5-Jan-09 17:45

titan_sky_king

5-Jan-09 17:45

Thanks very much!

Re: How to make the cursor move to the next ctrol of EDIT automatic?

Mark Salsbery4-Jan-09 15:17

Mark Salsbery

4-Jan-09 15:17

I'd go with Richard's reply, except instead of SetFocus, I'd use
the WM_NEXTDLGCTL message. WM_NEXTDLGCTL automatically selects the
edit control text so the user can just type if there's existing text.

Of course, if the edit control is empty it does't make a difference Smile | :)

Mark

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Re: How to make the cursor move to the next ctrol of EDIT automatic?

titan_sky_king5-Jan-09 17:46

titan_sky_king

5-Jan-09 17:46

Thank you very much!

Menus

BobInNJ4-Jan-09 5:59

BobInNJ

4-Jan-09 5:59

I am developing a GUI based application using C++ and MFC. I have a couple of menu options
that should be grayed out when the application starts up. What I mean by grayed out is that
they are not valid for the user to select and the visual appearance of the menu option should
reflect that. The menu is defined in an RC (resource script) file. What is the best way to
have these menu selections grayed out?

Thanks

Bob

Re: Menus

Mark Salsbery4-Jan-09 6:38

Mark Salsbery

4-Jan-09 6:38

Typically, the ON_UPDATE_COMMAND_UI Macro[^] is used to provide a command enabler function.

Mark

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Re: Menus

BobInNJ4-Jan-09 11:38

BobInNJ

4-Jan-09 11:38

Mark or anybody else that knows,

Thanks for the response. However, I am not sure what you are saying. Please consider
the following menu:

Selection 1
   Selection a
   Selection b
   Selection c
   Selection d

and the user chose Selection 1, I use then have a function (or method) to gray out
the sub-menu selection that I wanted grayed out. If so, how would the handler do
that?

I was thinking that I might do it when the menu is first created. I world do this by using the macro ON_WM_INITMENUPOPUP. What do you think of my approach?

Bob

Re: Menus

Richard Andrew x644-Jan-09 12:17

Richard Andrew x64

4-Jan-09 12:17

You can set the menu status with this function call:

CMenu::SetMenuItemInfo

Re: Menus

Mark Salsbery4-Jan-09 15:10

Mark Salsbery

4-Jan-09 15:10

BobInNJ wrote:
I am not sure what you are saying

I'm saying typically Selection a, Selection b, etc. each have an associated command
(for example, using the wizards, ID_SELECTION1_SELECTIONA)

// menu resource

IDR_MYMENU MENU 
BEGIN
    POPUP "Selection 1"
    BEGIN
        MENUITEM "Selection a",                 ID_SELECTION1_SELECTIONA
        MENUITEM "Selection  b",                ID_SELECTION1_SELECTIONB
    END
END



// added to message map of menu's window class
    ON_UPDATE_COMMAND_UI(ID_SELECTION1_SELECTIONA, &CMainFrame::OnUpdateSelection1Selectiona)
...
// added to menu's window class
void CMyMenuWindowFrame::OnUpdateSelection1Selectiona(CCmdUI *pCmdUI)
{
    if (some_state)
        pCmdUI->Enable(TRUE);
    else
        pCmdUI->Enable(FALSE);
}

Three advantages of using the command macros are:
1) MFC does the work for you
2) The IDE has wizards to add the command handler and enabler functions with just clicks
3) If you have a toolbar or possibly other context menu(s) with equivalent
commands, you only have to write the enabling code in one place.

That's the MFC way.....you are free to do it manually if you want to.

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Re: Menus

BobInNJ5-Jan-09 12:08

BobInNJ

5-Jan-09 12:08

Mark,

Thanks for the detailed response. It solved my problem.

Bob

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.