|
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
|
|
|
|
|
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
|
|
|
|
|
Where i can get activex control test container in visual studio 2008??
please respond me !!
Thanks
Raju !!!
|
|
|
|
|
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
|
|
|
|
|
Use GetDlgItem to obtain the control's handle and then call GetWindowTextLength [^].
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]
|
|
|
|
|
Thanks
There is sufficient light for those who desire to see, and there is sufficient darkness for those of a contrary disposition.
Blaise Pascal
|
|
|
|
|
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
|
|
|
|
|
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 
|
|
|
|
|
Thanks it helped me a loat
|
|
|
|
|
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 
Press F1 for help or google it.
Greetings from Germany
|
|
|
|
|
Thanks
|
|
|
|
|
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.
|
|
|
|
|
Try the WH_GETMESSAGE hook.
|
|
|
|
|
thanks, what a clever you are
|
|
|
|
|
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.
|
|
|
|
|
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. 
Thanking you,
Naveen HS
|
|
|
|
|
|
No you dont need to install MySql server in your PC. I will recommend using MySql++[^].
-Saurabh
|
|
|
|
|
Hi
i have a win32 console application. i need to use an activeX control in my project.
but my project have problem in execution. in calling Create function
COcxClass objmyActivX;
CWnd cw;
objmyActivX.Create(NULL, NULL, CRect(0,0,0,0),cw.FindWindow(NULL,NULL), 0);
my project is a service and i don't need any dialog or window in my project.
please help me
Zo.Naderi-Iran
|
|
|
|
|
Your code declares objmyActivX and cw and then tries to use them before either of them has been initialised to a value.
|
|
|
|
|
the objmyActivX will be initialize with calling Create function.
do i initialize with what value the cw?
Zo.Naderi-Iran
|
|
|
|
|
zon_cpp wrote: the objmyActivX will be initialize with calling Create function.
Not true I'm afraid. You are trying to invoke the Create() method on the objmyActivX object, which has no value. It would appear that you need to spend some time understanding C++ and whatever functionality you are trying to use here.
zon_cpp wrote: do i initialize with what value the cw?
I presume from its declaration this is some window belonging to the application but I don't really understand how this fits in to what you are attempting.
|
|
|
|
|
my project is a win32 console application !!!
in a dialog base project, this code has not any problem. but in win32 console project (win32 console) ...!
i think, the fourth paramet of create funtion is incorrect. but, what is it , the correct of this parameter ?
Zo.Naderi-Iran
|
|
|
|
|
If you had done a search on Google first you could have found this article[^].
|
|
|
|
|
thank you very much.
my time, for this problem, is very few. you helped me, thanks.
and this article: Getting the most out of IDispatch[^], solved my problem. 
Zo.Naderi-Iran
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
