Adding Scrollbar to a Dialog in MFC - C / C++ / MFC Discussion Boards

efraimyy18-May-11 22:49

18-May-11 22:49

I would like to create a dialog box which contains an embedded Excel workbook. (Excel is installed on the computer, of course.) MS provides example code showing how to do something like this with a Document/View based app, but not in a dialog.

(I saw from searching this forum that there was a discussion about "Embedded Excel", but when I try to access it, I get an empty list with the message "Unable to load messages due to high load.")

Re: Embedding Excel in a dialog

Chandrasekharan P19-May-11 1:35

Chandrasekharan P

19-May-11 1:35

You can go to the project tab and select Add to Project Sub menu. This menu has another sub menu. select the last option. Components and control
When you select that a windows dialog will pop up with 2 folders. Select the first one. Search for Microsoft Office SpreadSheet. Select that and click OK.
The spreadsheet will be embedded in your dialog.

Re: Embedding Excel in a dialog

efraimyy19-May-11 2:58

efraimyy

19-May-11 2:58

I'm not sure what you mean by the "Project Tab" and "Add To Project". If I right-click on the solution, I get an item "Add New Project" and under that one of the possibilities is Visual C#/Microsoft Office/Excel Workbook, but I don't see how this will help me. Won't it just create a whole new project unrelated to my current one?

Re: Embedding Excel in a dialog

efraimyy19-May-11 3:00

efraimyy

19-May-11 3:00

I should have mentioned that I am using VS2008

Re: Embedding Excel in a dialog

Chandrasekharan P19-May-11 22:04

Chandrasekharan P

19-May-11 22:04

Forgot to mention, In the menu bar. There should be an option called Project. You should select that.

Re: Embedding Excel in a dialog

efraimyy21-May-11 21:40

efraimyy

21-May-11 21:40

I still don't see this.

In VS2008, all I have under the "Project" menu or the right-click menu on the project is "Add New Item" and "Components and controls" is not a selection from the dialog I get from that.

Re: Embedding Excel in a dialog

Chandrasekharan P22-May-11 18:42

Chandrasekharan P

22-May-11 18:42

What you can do is, Right click on the Dialog. You will get an option. Insert ActiveX Control. You will get the same component here also. Here you can select Microsoft Office SpreadSheet 11.0 or 10.0.

Hope it helps

Adding Scrollbar to a Dialog in MFC

pix_programmer18-May-11 20:52

pix_programmer

18-May-11 20:52

Hi!
I've added Vertical and Horizontal Scrollbar to a Dialog in MFC. I'm facing the following problems.

(i)I've loaded a Flash movie inside the Dialog. My movie is larger than my Dialog. But both the scrollbars are not appearing at

the beginning. After I reduce the dialog size only,the scrollbars appear.

(ii) When I reached the extreme of Horizontal Scrollbar or Vertical Scrollbar the movie is not fully displayed. Part of the movies

is cut.

(iii) Some kind flicking occurs during scrolling(both Vertical and Horizontal).

I've developed this application using VC++ 2008/MFC. Here's the code:

BOOL OnInitDialog()
{
   m_nScrollPos = 0; 
   m_nHScrollPos = 0;
}

void OnSize(UINT nType, int cx, int cy)
{
	CDialog::OnSize(nType, cx, cy);

	m_nCurHeight = cy;
	m_nCurWidth = cx;

	SCROLLINFO si;
	si.cbSize = sizeof(SCROLLINFO);
	si.fMask = SIF_ALL; 
	si.nMin = 0;
	si.nMax = m_rcOriginalRect.Height();
	si.nPage = cy;
	si.nPos = 0;
	SetScrollInfo(SB_VERT, &si, TRUE);  

	SCROLLINFO si1;
	si1.cbSize = sizeof(SCROLLINFO);
	si1.fMask = SIF_ALL; 
	si1.nMin = 0;
	si1.nMax = m_rcOriginalRect.Width();
	si1.nPage = cx;
	si1.nPos = 0;
	SetScrollInfo(SB_HORZ, &si1, TRUE); 
}

void OnVScroll(UINT nSBCode, UINT nPos, CScrollBar *pScrollBar)
{
	int nDelta;
	int nMaxPos = m_rcOriginalRect.Height() - m_nCurHeight;

	switch (nSBCode)
	{
	case SB_LINEDOWN:
		if (m_nScrollPos >= nMaxPos)
			return;

		nDelta = min(max(nMaxPos/20,5),nMaxPos-m_nScrollPos);
		break;

	case SB_LINEUP:
		if (m_nScrollPos <= 0)
			return;
		nDelta = -min(max(nMaxPos/20,5),m_nScrollPos);
		break;
	case SB_PAGEDOWN:
		if (m_nScrollPos >= nMaxPos)
			return;
		nDelta = min(max(nMaxPos/10,5),nMaxPos-m_nScrollPos);
		break;
	case SB_THUMBTRACK:
	case SB_THUMBPOSITION:
		nDelta = (int)nPos - m_nScrollPos;
		break;

	case SB_PAGEUP:
		if (m_nScrollPos <= 0)
			return;
		nDelta = -min(max(nMaxPos/10,5),m_nScrollPos);
		break;

	default:
		return;
	}
	m_nScrollPos += nDelta;
	SetScrollPos(SB_VERT,m_nScrollPos,TRUE);
	ScrollWindow(0,-nDelta);
	CDialog::OnVScroll(nSBCode, nPos, pScrollBar);
}

void Htmlbr::OnSize(UINT nType, int cx, int cy)
{
	CDialog::OnSize(nType, cx, cy);

	m_nCurHeight = cy;
	m_nCurWidth = cx;

	SCROLLINFO si;
	si.cbSize = sizeof(SCROLLINFO);
	si.fMask = SIF_ALL; 
	si.nMin = 0;
	si.nMax = m_rcOriginalRect.Height();
	si.nPage = cy;
	si.nPos = 0;
	SetScrollInfo(SB_VERT, &si, TRUE);  

	SCROLLINFO si1;
	si1.cbSize = sizeof(SCROLLINFO);
	si1.fMask = SIF_ALL; 
	si1.nMin = 0;
	si1.nMax = m_rcOriginalRect.Width();
	si1.nPage = cx;
	si1.nPos = 0;
	SetScrollInfo(SB_HORZ, &si1, TRUE); 
}

void Htmlbr::OnHScroll(UINT nSBCode, UINT nPos, CScrollBar *pScrollBar)
{

	int nDelta;
	int nMaxPos = m_rcOriginalRect.Width() - m_nCurWidth;

	switch (nSBCode)
	{
	case SB_LINERIGHT:
		if (m_nHScrollPos >= nMaxPos)
			return;

		nDelta = min(max(nMaxPos/20,5),nMaxPos-m_nHScrollPos);
		break;

	case SB_LINELEFT:
		if (m_nHScrollPos <= 0)
			return;
		nDelta = -min(max(nMaxPos/20,5),m_nHScrollPos);
		break;
	case SB_PAGERIGHT:
		if (m_nScrollPos >= nMaxPos)
			return;
		nDelta = min(max(nMaxPos/10,5),nMaxPos-m_nHScrollPos);
		break;
	case SB_THUMBTRACK:
	case SB_THUMBPOSITION:
		nDelta = (int)nPos - m_nHScrollPos;
		break;

	case SB_PAGELEFT:
		if (m_nScrollPos <= 0)
			return;
		nDelta = -min(max(nMaxPos/10,5),m_nHScrollPos);
		break;

	default:
		return;
	}
	m_nHScrollPos += nDelta;
	SetScrollPos(SB_HORZ,m_nHScrollPos,TRUE);
	ScrollWindow(-nDelta,0);

	CDialog::OnHScroll(nSBCode, nPos, pScrollBar);
}

What else need to be done to rectify the above problems?

Re: Adding Scrollbar to a Dialog in MFC

Chandrasekharan P18-May-11 22:04

Chandrasekharan P

18-May-11 22:04

Are you getting the size of the movie and then putting that value in the scroll bar?? why dont you try for Direct Show() API's?

Re: Adding Scrollbar to a Dialog in MFC

pix_programmer18-May-11 22:12

pix_programmer

18-May-11 22:12

Chandru080 wrote:
wDirect Show() API's

Can you be little bit more elaborate on this?

Re: Adding Scrollbar to a Dialog in MFC

Chandrasekharan P18-May-11 22:26

Chandrasekharan P

18-May-11 22:26

DirectShow API's are mainly used for media streaming. there are lot of examples in the net which will help you achieve your needs.
See the below link.
http://msdn.microsoft.com/en-us/library/dd375454%28v=vs.85%29.aspx[^]

voice chat in client/server

includeh1018-May-11 12:18

includeh10

18-May-11 12:18

voice chat in a socket client/server program.
assume the server has 3,000 clients connected, one client chats to others in voice (maybe a song).

I think it is not a good idea to submit the song to server from the client then server broadcasts to all other 3,000 clients through sockets, because a song may last for long time interval and consumes too many server's resources.

what do you do in the case?

.

Re: voice chat in client/server

Code-o-mat19-May-11 0:24

Code-o-mat

19-May-11 0:24

I check out what Peer-to-peer[^] networking is?

> The problem with computers is that they do what you tell them to do and not what you want them to do. <
> //TODO: Implement signature here<

How create a windows 7 gadget with MFC in VC++2010?

Hadi Dayvary18-May-11 7:36

Hadi Dayvary

18-May-11 7:36

Hi Any sample or help?

www.logicsims.ir

Re: How create a windows 7 gadget with MFC in VC++2010?

Mark Salsbery18-May-11 8:25

Mark Salsbery

18-May-11 8:25

A Windows Sidebar gadget?

Example: A Gadget for Browsing the Astronomy Picture of the Day[^]

Documentation: Windows Sidebar[^]

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

.def and 64 bit

Paul Bryan Porter18-May-11 5:57

Paul Bryan Porter

18-May-11 5:57

I have a .dll that I want to port to 64bit. To differentiate it from the 32 bit version I named it <name>64.dll only to find that the <module>64.dll that uses it couldn't load it as it
was still looking for <name>32.dll. That is when I discovered that the <name>32.dll is exported in the .def file. Changing the .def file to export <name>64.dll DOES work.

However,

The <name>32.dll and <name>64.dll are differentiated by configuration only, not project. A project can have only one .def file. Thus we have to remember to manually change the .def when changing compilations from 32 to 64 bit and vice versa.

The thought of using __declspec() instead of a .def file came up but I was told by the original programmer that he had to drop them for some problem and had to go to the .def file.

We thought about making two projects in the one <name>.sln file. But it seemed to be too much of a hassle for such a small problem.

So how can I make it so changing the configuration of a C++ project changes what is exported as the LIBRARY in a .def file?

Re: .def and 64 bit

Chris Meech18-May-11 6:30

Chris Meech

18-May-11 6:30

Just a guess, but #ifdef in the .def file looking for the different target might let you export something different. Smile | :)

Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

Re: .def and 64 bit

Paul Bryan Porter19-May-11 12:55

Paul Bryan Porter

19-May-11 12:55

Thanks for your answer chris,

Yes I had tried #ifdef in the .def file, however a .def is not c/c++ code. A .def file doesn't know what a #ifdef is. Its some other kind of language.

For instance in c/c++ code /* or // is comment. In a .def file ; is a comment.

Re: .def and 64 bit

C^hris L^osinger18-May-11 15:32

C^hris L^osinger

18-May-11 15:32

have you tried adding one .DEF for each configuration then excluding each from the build that doesn't use it (right-click, properties, choose the appropriate config, exclude from build) ?

i've never tried that with .def files, but it works for source files.

image processing toolkits | batch image processing

Re: .def and 64 bit

Paul Bryan Porter19-May-11 12:59

Paul Bryan Porter

19-May-11 12:59

Thanks for your response,

Yes I tried this. Basically Microsoft Visual Studio stops you from adding more than one .def file to any project.

So regardless if its a single configuration project or if it is a multi configuration project you can only have one .def file.

I am trying to add the .def file using the IDE's add to project methodology so you may know around this that I don't.

Re: .def and 64 bit

C^hris L^osinger19-May-11 13:15

C^hris L^osinger

19-May-11 13:15

is there any reason you need to specify the DLL's name in the .DEF file ? it's not required for the linker.

the .DEFs we use typically only have a DESCRIPTION tag and then the EXPORTS list

image processing toolkits | batch image processing

Re: .def and 64 bit

Paul Bryan Porter20-May-11 5:44

Paul Bryan Porter

20-May-11 5:44

Oh wow hey cool! Your right, the LIBRARY line will force a dependancy on a paticular name. But if you don't have the LIBRARY line in the .def file then the dependancy on the name is the name of the .dll itself.

Thanks! Much happiness Smile | :)

Create DSN for SQL Server at Run time

manju 318-May-11 2:36

manju 3

18-May-11 2:36

Hi all,
I am trying to create DSN SQL Server at run time,but i am not able to do it.

bool aDSNCreated = false;
	RETCODE retcode= SQL_SUCCESS;
	aDSNCreated = SQLConfigDataSource(NULL, ODBC_ADD_DSN, "SQL Server (*.MDF) \0", _T("DSN=Login\DBQ=E:\\Login_Data.MDF\0")); /
	if(aDSNCreated == false)
	{				
		retcode = SQLInstallerError(2, NULL,NULL,100,NULL);
         
	}

Am i doing anything wrong,please help me

Thanks
Manju

Re: Create DSN for SQL Server at Run time

David Crow18-May-11 3:08

David Crow

18-May-11 3:08

Have you tried:

SQLConfigDataSource(NULL, ODBC_ADD_DSN, "SQL Server (*.MDF)", _T("DSN=Login\0DBQ=E:\\Login_Data.MDF\0"));

What does SQLInstallerError() have to say?

"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

"Some people are making such thorough preparation for rainy days that they aren't enjoying today's sunshine." - William Feather

Open other Application From Dialogue

camuoi28817-May-11 22:59

camuoi288

17-May-11 22:59

I have a Dialogue and a Button "Open".I want when i click on "Open" Button,an other application will open.I know MFC guide to use CreatProcess Function but i don't know how to add this function into "Open" Clicked event. Frown | :(

Please help me.
Example i have:

void CThunghiemDlg::OnButtonOpen() 
{
	// TODO: Add your control notification handler code here
	
}

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