Re: recordset problem - C / C++ / MFC Discussion Boards

Re: How to lock taskbar in my program

NianHawk20-Jun-06 6:39

NianHawk

20-Jun-06 6:39

Thanks a lot

Nothing impossible, Nothing sure

Drawing to desktop

Aneurysm004-Jun-06 2:20

Aneurysm00

4-Jun-06 2:20

If I wish to draw a window, or an image onto the desktop, do I use obtain a HWND from GetDesktopWindow() and get a DC from there? I wish to draw onto the desktop , so that my image appears as though it were part of the wallpaper, e.g. all other windows sit on top of it.

Is there another HWND I should be looking for?

Re: Drawing to desktop

ThatsAlok4-Jun-06 19:11

ThatsAlok

4-Jun-06 19:11

Aneurysm00 wrote:
If I wish to draw a window, or an image onto the desktop, do I use obtain a HWND from GetDesktopWindow() and get a DC from there? I wish to draw onto the desktop , so that my image appears as though it were part of the wallpaper, e.g. all other windows sit on top of it.

Create DC by using this method
CDC myDC(NULL);

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

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

Re: Drawing to desktop

FarPointer4-Jun-06 21:09

FarPointer

4-Jun-06 21:09

Hi ,
Do you really have to draw on the desktop ,wont overriding the
CWnd::OnEraseBkgnd of your window work .that will give the same effect as drawing on the Desktop. Please check .

Regards,
FarPointer

recordset problem

SWDevil4-Jun-06 2:04

SWDevil

4-Jun-06 2:04

Hi,

I have an application in which I display records in a grid. I populate the grid using a recordset that contains the results of a query of the database.

The problem is that if I have a large database (about 80,000 records and above..) then it takes a few minutes to load the grid with all of the records.
I need to make this faster... Any ideas?

Re: recordset problem

C^hris L^osinger4-Jun-06 4:21

C^hris L^osinger

4-Jun-06 4:21

don't load all the data at once - only load the data your grid is currently showing.

Cleek | Image Toolkits | Thumbnail maker

Re: recordset problem

SWDevil4-Jun-06 5:08

SWDevil

4-Jun-06 5:08

Yeah - what I thought to do is show the first 400 records (for example), while searching for the other records.
I thought to load the data page by page, and display 400 records in each page.
So, it would work this way: display 400 records, then display another 400 (800 total), then another 400 (1200 total) and so on until I reach 78000 records.
But how can I do this with the recordset object?
Do I have to fill the recordset first with 400 records, then with 800 records, then with 1200 records, and eventually with 78000?

Re: recordset problem

C^hris L^osinger4-Jun-06 5:17

C^hris L^osinger

4-Jun-06 5:17

SWDevil wrote:
So, it would work this way: display 400 records, then display another 400 (800 total), then another 400 (1200 total) and so on until I reach 78000 records.

only load the ones you need to display. if they scroll, load enough new data to complete the grid, and discard the rest.

ideally, if your grid control allows, you can put it in charge of loading the data for the rows it has to display when it needs them. don't make it load data it doesn't need - just let it ask for rows X through Y when it needs to display them, and don't worry about any other rows.

Cleek | Image Toolkits | Thumbnail maker

Re: recordset problem

SWDevil4-Jun-06 5:39

SWDevil

4-Jun-06 5:39

ok - I understand your idea, but I don't understand how to actually implement it...

First of all - how can I know if I can put my grid control in charge of loading the data it needs?

Second - Let's say my grid control can't be put in charge of loading the correct data, how do I implement your idea?
Do I have to perform a new query each time?
For example: "SELECT * FROM TABLE1 WHERE field BETWEEN x and y" and then display the recordset that contains the result set?

Also - won't this solution take a lot of time also? isn't the solution of loading page by page better?

Re: recordset problem

C^hris L^osinger4-Jun-06 5:46

C^hris L^osinger

4-Jun-06 5:46

SWDevil wrote:
how can I know if I can put my grid control in charge of loading the data it needs?

i don't know what you're using for your grid, but some of the standard Windows controls allow this. for example, the CListCtrl can act as a "Virtual list control", which means it will send you a message when it needs data for an item. the MSDN has info on this.

SWDevil wrote:
Do I have to perform a new query each time?

ideally, you would cache some data.

SWDevil wrote:
Also - won't this solution take a lot of time also? isn't the solution of loading page by page better?

you're only ever loading, at most, the number of lines you can display at once, so the control will load faster and won't be required to maintain a large amount of memory to hold all the items.

Cleek | Image Toolkits | Thumbnail maker

Desktop right click menus in Win XP

Anil_vvs4-Jun-06 0:45

Anil_vvs

4-Jun-06 0:45

Hi All,

Can anyone tell me how to increase the max number of right click menus displayed on any particular icon on the desktop in Win XP?

Thanks and Regards,
Anil

Re: Desktop right click menus in Win XP

Sarath C4-Jun-06 1:14

Sarath C

4-Jun-06 1:14

Soory not quite sure about that.
check Micheal Dunn's "The Complete Idiot's Guide to Writing Shell Extensions" series. It might be useful.

Sa^Rath.

"Don't Do Different things... Do Things Differently..."

multiple connection using WinINet??

AhmedOsamaMoh4-Jun-06 0:09

AhmedOsamaMoh

4-Jun-06 0:09

how can i use WinINet to download a file through many connection and not only one like all the download manager

thx
bye

PrintWIndow Problems (black squares)

palako3-Jun-06 22:52

palako

3-Jun-06 22:52

Hi.

I´ve made a screen capture code using the PrintWindow function, been my input parameter the window handle I want to capture. This window has some buttons, labels, ... that as you may know act as child windows for the first.

It all works fine, mostly, but every 500 or 700 grabs I get one or two of them where child elements appear as black rectangles.

I've read [1] about something like this when child windows style is CS_CLASSDC or CS_PARENTDC. Obviously, I do not create the windows I capture, so I can't change that style.

So, I don't know how to face the problem. Maybe a PrintWindow alternative, but I need independence of the z-order (deep) of the window, getting a clear capture even if the window is not foreground.

Thanks in advance.

[1]http://www.codeguru.com/cpp/g-m/gdi/capturingimages/comments.php/c11231/?thread=9097

How to get the Size of the Window having the Html document in the Webbrowser application

Anamika20053-Jun-06 22:45

Anamika2005

3-Jun-06 22:45

In the WebBrowser application how to get the size of the window which includes the Html document in it , and the scrollbars also.

Regards
Shikha
NetStudio,Pune

Re: How to get the Size of the Window having the Html document in the Webbrowser application

Hamid_RT4-Jun-06 1:03

Hamid_RT

4-Jun-06 1:03

I guess your problem is scroll do you use CHtmlView?

whitesky

Re: How to get the Size of the Window having the Html document in the Webbrowser application

Anamika20054-Jun-06 20:53

Anamika2005

4-Jun-06 20:53

Thanks for your reply .

Yes, i have used the CHtmlView class in my application and i want the size of the html page document i can get size of the window with scrollbar by using getscrollinfo function but it is again not giving the size of the window having the html document.

Regards
Shikha
Netstudio,Pune

Re: How to get the Size of the Window having the Html document in the Webbrowser application

Hamid_RT4-Jun-06 22:20

Hamid_RT

4-Jun-06 22:20

Did you see GetHeight and GetWidth in this class

whitesky

Re: How to get the Size of the Window having the Html document in the Webbrowser application

Anamika20054-Jun-06 22:59

Anamika2005

4-Jun-06 22:59

Yes i can get the GetHeight,GetWidth function but again from that just i can get the height of the window without scrollbars which is not the whole size of the html document.

Regards
Shikha
Pune

Re: How to get the Size of the Window having the Html document in the Webbrowser application

ThatsAlok4-Jun-06 20:51

ThatsAlok

4-Jun-06 20:51

Shikha Jain wrote:
In the WebBrowser application how to get the size of the window which includes the Html document in it , and the scrollbars also.

is api GetWindowRect of any use?

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

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

Re: How to get the Size of the Window having the Html document in the Webbrowser application

Anamika20054-Jun-06 21:01

Anamika2005

4-Jun-06 21:01

Thanks for your reply,

But GetClientRect() only gives the client area size of the window i want the whole page size of the html document i.e with the scrollbars also.

Regards
Shikha
Netstudio,Pune

Re: How to get the Size of the Window having the Html document in the Webbrowser application

Anamika20054-Jun-06 23:15

Anamika2005

4-Jun-06 23:15

Actualy in the previous mail it is by mistake i have written GetClientRect .
yes GetWindowRect you have suggested ,
i have tried that but it again gives the size of the window excluding the scrollbars i.e not the whole html document size .

Regards
Shikha
Pune

Re: How to get the Size of the Window having the Html document in the Webbrowser application

Viorel.4-Jun-06 23:23

Viorel.

4-Jun-06 23:23

Supposing you actually need the full size of the HTML document, including the parts out of client area, a possible solution can look like this:

CComPtr< IHTMLDocument3 > doc = (IHTMLDocument3*)GetHtmlDocument();
IHTMLElement * doc_element;
doc->get_documentElement(&doc_element);
CComQIPtr<IHTMLElement2> element = doc_element;
long width;
long height;
element->get_scrollWidth(&width);
element->get_scrollHeight(&height);

Please note that the sizes are available only for fully loaded HTML documents, when GetReadyState() returns an appropriate value.

Hope this is what you need in your HTML-capturing application.

MS Access in VC++ [modified]

Tara143-Jun-06 21:52

Tara14

3-Jun-06 21:52

Hi,

I have a program coded in vc++6 and ms access as the database.The data connection is done using DAO.

Suppose I run this program on a computer that does not have microsoft office installed, will it still work? i.e. will it still be able to connect to the database?

If not, will installing the microsoft jet engine be sufficient?

Thanks,
Tara

Fortitudine Vinsinues!

-- modified at 4:22 Sunday 4th June, 2006

Re: MS Access in VC++ [modified]

Milton Karimbekallil4-Jun-06 20:23

Milton Karimbekallil

4-Jun-06 20:23

You dont need to install MS Office, but you have to install MDAC. Jet engine will come as part of MDAC.

cheers..Milton KB

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