Re: Data from DB to Excel - C / C++ / MFC Discussion Boards

Re: C++ question for new grad

chan1126-Nov-09 10:31

chan11

26-Nov-09 10:31

Thanks a lot, I needed array structure for this and finally could figure that one out.

Regards,
Chan

Problem with installutil.exe while install a service...

jain_MS24-Nov-09 1:25

jain_MS

24-Nov-09 1:25

Hi,
Requirement : Need to add a service while installing a MSI ( in VS2005)

So I have added installutil.exe to my Setup project -> Custom Action
and i modified the installutil.exe properties as C:\program\testing1.exe ( in Argument Column)

After doing build and install, i am not able to see any service for my application , meanwhile ..i am able to see my application testing1.vshost.exe in TASKMANAGER.

your help much appreciated

Regds
Jain

Re: Problem with installutil.exe while install a service...

loyal ginger24-Nov-09 3:16

loyal ginger

24-Nov-09 3:16

Did you make sure the account you are using have the proper privilage to install a service?

Re: Problem with installutil.exe while install a service...

jain_MS24-Nov-09 3:56

jain_MS

24-Nov-09 3:56

Yes Loyal, i have administrator rights on this machine..

Meanwhile is it possible to install a service in Setup project using installutil.exe in CustomAction.

If not please provide a alternative solution.

Data from DB to Excel

hellogany23-Nov-09 22:50

hellogany

23-Nov-09 22:50

Hi All

I have developed a windows based application in VC++

The GUI Interacts with the DB and shows the result in the windw..

Til now am working fine.Now the next task is to download the available data from the DB to the excel sheet.

Can anyone guide me to do??

Thanks
Gany

Re: Data from DB to Excel

Rajesh R Subramanian23-Nov-09 22:54

Rajesh R Subramanian

23-Nov-09 22:54

Simply write the data as a CSV file[^]. Excel can handle a CSV file.

“Follow your bliss.” – Joseph Campbell

Re: Data from DB to Excel

Dave Calkins24-Nov-09 4:54

Dave Calkins

24-Nov-09 4:54

CSV is a good way to go as the other poster suggested. If that doesn't do it you could resort to using the Excel OLE Automation interface.

Re: Data from DB to Excel

David Crow24-Nov-09 17:03

David Crow

24-Nov-09 17:03

hellogany wrote:
Now the next task is to download the available data from the DB to the excel sheet.

Can anyone guide me to do??

You can also interact with Excel via ODBC. If you are using MFC, check out CDatabase and CRecordset. You'll need to create a DSN.

"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

Re: Data from DB to Excel

T210226-Nov-09 21:17

T2102

26-Nov-09 21:17

I believe that you can execute sql server code to create an xls file automatically. You also could use COM to create an excel file yourself.

Taken from another article I read
[^]

you can use
1> DTS Export/Import utility for that please go thru
http://support.microsoft.com/kb/319951[^]

2>exec master..xp_cmdshell but for that you need to enable from surface area configuration

3> BCP utility

4> you can use linked server for excel file to sql table.
INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=\\servername\e$\inetpub\wwwroot\game\myexcelfile.xls;',
'SELECT * FROM [scores]') select * from LinkedServerName.DBname.tbl_Stats

5> SSIS package to transfer data from a table in a SQL Server 2005 database to a Microsoft Excel spreadsheet

Reasons are not Important but Results are Important.
Swati Tripathi

missing activex control test container in visual studio 2008

Game-point23-Nov-09 22:43

Game-point

23-Nov-09 22:43

Where i can get activex control test container in visual studio 2008??

please respond me !!

Thanks

Raju !!!

GetDlgItemText

sashoalm23-Nov-09 20:44

sashoalm

23-Nov-09 20:44

How can I get the length of the string GetDlgItemText would return, so I can create a big enough buffer? In the documentation it says GetDlgItemText will just truncate the string to fit the buffer, but I don't want that.

There is sufficient light for those who desire to see, and there is sufficient darkness for those of a contrary disposition.
Blaise Pascal

Re: GetDlgItemText

CPallini23-Nov-09 20:52

CPallini

23-Nov-09 20:52

Use GetDlgItem to obtain the control's handle and then call GetWindowTextLength [^].
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

Re: GetDlgItemText

sashoalm24-Nov-09 4:19

sashoalm

24-Nov-09 4:19

Thanks

There is sufficient light for those who desire to see, and there is sufficient darkness for those of a contrary disposition.
Blaise Pascal

Printing Image

Benjamin Bruno23-Nov-09 20:13

Benjamin Bruno

23-Nov-09 20:13

Hi In my application I am printing image.But the image which I have printed is very large and it is inverted.I tried to scaledown the image,but its not working.

My Code

CRect				rcPrintRect;

rcPrintRect.left		= nXMargin;		
rcPrintRect.right		= nPageWidth - 2 * nXMargin;
rcPrintRect.top			= nYMargin;		
rcPrintRect.bottom		= nPageHeight - 2 * nYMargin;

StretchDIBits(
		pDC->m_hDC,
		nXMargin + 5000, 
		rcPrintRect.top, 
		rcPrintRect.right - 7500, 
		rcPrintRect.bottom - 10500,
		0,
		0,
		bmpInfo.bmiHeader.biWidth,
		bmpInfo.bmiHeader.biHeight,
		buffUnComDropImg,
		&bmpInfo,
		DIB_RGB_COLORS,
		SRCCOPY
	     );

How to solve this issue?

Thanks in advance

Re: Printing Image

tolw23-Nov-09 20:40

tolw

23-Nov-09 20:40

Try debugging to see the actual values you pass into the function call.

Looking at your code I would say that depending on the size of rcPrintRect the Destination rectangle can have negative width and height. Try hardcoding it for starters and see if it helps.

The documentation for the function states:
If nSrcWidth and nDestWidth have different signs, the function creates a mirror image of the bitmap along the x-axis.
If nSrcHeight and nDestHeight have different signs, the function creates a mirror image of the bitmap along the y-axis.

In other words:

Change:

nXMargin + 5000,
rcPrintRect.top,
rcPrintRect.right - 7500,
rcPrintRect.bottom - 10500,

to:

nXMargin + 5000,
rcPrintRect.top,
100,
100,

Hope this helps Smile | :)

Re: Printing Image

Benjamin Bruno2-Dec-09 0:28

Benjamin Bruno

2-Dec-09 0:28

Thanks it helped me a loat Smile | :)

Re: Printing Image

KarstenK23-Nov-09 21:56

KarstenK

23-Nov-09 21:56

it is a matter of the sign (+/-) of the parameters, but take care to print not more than your output DC-size.

In some case also the bits of your image are bottom-top in memory!!! It is an IBM legacy Roll eyes | :rolleyes:

Press F1 for help or google it.
Greetings from Germany

Re: Printing Image

Benjamin Bruno2-Dec-09 0:29

Benjamin Bruno

2-Dec-09 0:29

Thanks

how to hook sendmessage、postmessage and the key-down messsage on the same time, big john

nenfa23-Nov-09 20:10

nenfa

23-Nov-09 20:10

what a bad feelings i am, how to hook sendmessage、postmessage and key message on the same time, now i use WM_CALLWNDPROC, but only can hook sendmessage, would you like to help me, thank you very much.

Re: how to hook sendmessage、postmessage and the key-down messsage on the same time, big john

«_Superman_»23-Nov-09 20:44

«_Superman_»

23-Nov-09 20:44

Try the WH_GETMESSAGE hook.

«_Superman_»
I love work. It gives me something to do between weekends.

Microsoft MVP (Visual C++)

Re: how to hook sendmessage、postmessage and the key-down messsage on the same time, big john

nenfa23-Nov-09 20:52

nenfa

23-Nov-09 20:52

thanks, what a clever you are

Re: how to hook sendmessage、postmessage and the key-down messsage on the same time, big john

kcynic23-Nov-09 20:50

kcynic

23-Nov-09 20:50

what do you really want to do?
I think you can use SetWidnowsLong to replace its original processing function then you can get the first chance to deal with key message.
And for SendMessage and PostMessage, you can just hook the two API function as normal.

VC++ & MySQL

NaveenHS23-Nov-09 19:56

NaveenHS

23-Nov-09 19:56

Hello Everyone,

Can anyone please suggest me some tutorials and notes for connecting VC++ 8 with MySql ??

I have 2 pc’s here in one pc I have MySql installed & it’s a sever ,... for using MySql in my PC is it required to install SQL in my PC also ? or I can access the tables directly without installing MySql in my PC ?

I am very much new to both the things …so asking very silly Questions. Confused | :confused:

Thanking you,
Naveen HS

Re: VC++ & MySQL

KarstenK23-Nov-09 21:58

KarstenK

23-Nov-09 21:58

http://www.codeproject.com/script/Forums/Search.aspx?fid=0&kw=mysql+c[^] Roll eyes | :rolleyes:

Press F1 for help or google it.
Greetings from Germany

Re: VC++ & MySQL

Saurabh.Garg23-Nov-09 23:46

Saurabh.Garg

23-Nov-09 23:46

No you dont need to install MySql server in your PC. I will recommend using MySql++[^].

-Saurabh

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