C / C++ / MFC

5-Jan-09 8:10

manohar_balu wrote:
How to prevent this..?

By using Spy++ to see what window the dialog is modal to.

"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

File Exists

rdop4-Jan-09 18:14

rdop

4-Jan-09 18:14

Hi All

How can i check file is Exists or not?I am creating a file but before create a file i want to check File name is exists or not.Plz help me

Naveen4-Jan-09 18:20

Naveen

4-Jan-09 18:20

Use PathFileExists [^] function

nave

[OpenedFileFinder] [My Blog]

Hamid_RT4-Jan-09 18:35

4-Jan-09 18:35

You can use of FindFirstFile.

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 )

KarstenK4-Jan-09 21:01

KarstenK

4-Jan-09 21:01

if you find a file you got to close the handle. Blush | :O

Greetings from Germany

Hamid_RT4-Jan-09 21:14

4-Jan-09 21:14

Sure!

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 )

ThatsAlok5-Jan-09 0:19

ThatsAlok

5-Jan-09 0:19

Hamid. wrote:
Sure!

hummm

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

Sameerkumar Namdeo4-Jan-09 21:04

Sameerkumar Namdeo

4-Jan-09 21:04

_taccess()

How to create a custom list control in MFC ?

ThatsAlok5-Jan-09 0:20

ThatsAlok

5-Jan-09 0:20

ccpptrain wrote:
_taccess()

good! but i think, if i use it, it will increase my dependency on C runtime library. though they are fast but more error prone so beware while using it.

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

shah1864-Jan-09 18:08

shah186

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

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

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 )

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

Removing else in this statements How?

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 )

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

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

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

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

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

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

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