Re: Retrive data from SQL database & store it in Excel file - C / C++ / MFC Discussion Boards

Re: How to create a listbox in win32 with checkbox style

David Crow31-Mar-09 3:33

David Crow

31-Mar-09 3:33

nbugalia wrote:
When I am using ListControl on the dialog, the dialog is not becoming visible.

Can you elaborate, please? Confused | :confused:

"Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown

"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

reading html file in c++/vc++

siddunelogi30-Mar-09 22:41

siddunelogi

30-Mar-09 22:41

i want to read html file usin c++ or vc++ help me please

thanks in advance

Re: reading html file in c++/vc++

Rajesh R Subramanian30-Mar-09 22:48

Rajesh R Subramanian

30-Mar-09 22:48

See here[^]

It is a crappy thing, but it's life -^ Carlo Pallini

Re: reading html file in c++/vc++

Iain Clarke, Warrior Programmer30-Mar-09 23:19

Iain Clarke, Warrior Programmer

30-Mar-09 23:19

The answer to your actual question is:
You do it the same way you'd read any other file: CreateFile, ReadFile, CFile, CFile::Read, etc.

If you mean a file on a webserver somewhere, that's different.
Lookup InternetReadFile, InternetOpenUrl, etc. Read the documentation for those very carefully.

But that will just give you a big bunch of html.

If you want your program to understand the html, that's different again. But "parser" is the right search term to use. There are articles on codeproject that do various amounts of it, it will just depend on how sophisticated you need to be.

If you want to display html to a user, it's easier - look at CHtmlView in MFC.

Good luck,

Iain.

In the process of moving to Sweden for love (awwww).
If you're in Scandinavia and want an MVP on the payroll (or happy with a remote worker), give me a job!

Retrive data from SQL database & store it in Excel file

diptipanchal30-Mar-09 22:31

diptipanchal

30-Mar-09 22:31

I have a application where data will get stored in SQL 2000 database. Now i have to retrive data from database & store it in the excel file.

I am using VC++ 6.0 version with MFC, SDI & database connectivity through ODBC.

Could any one guide me to achieve this? Kindly let me know if you would need more details to reply to my question.

Thanks in advance.
Regards,

Dipti

Re: Retrive data from SQL database & store it in Excel file

Purish Dwivedi30-Mar-09 23:12

Purish Dwivedi

30-Mar-09 23:12

This link might help you.
http://www.codeproject.com/KB/database/simple_odbc.aspx

Being an Indian makes me feel proud.

Re: Retrive data from SQL database & store it in Excel file

diptipanchal31-Mar-09 0:10

diptipanchal

31-Mar-09 0:10

Thanks for your reply. I am new to VC++. This example is without MFC. Could you send me details on how to retrive data from SQL & store it in Excel.

Could you guide me on how to go about this?

Regards,

Dipti

Re: Retrive data from SQL database & store it in Excel file

David Crow31-Mar-09 3:44

David Crow

31-Mar-09 3:44

diptipanchal wrote:
Could you guide me on how to go about this?

Break the problem down into more manageable parts. Can you extract data from the database (e.g., using CRecordset)? Can you use Excel Automation?

Re: Retrive data from SQL database & store it in Excel file

diptipanchal31-Mar-09 18:16

diptipanchal

31-Mar-09 18:16

No, I have neither read data from database nor used excel automation before.

Could you send me some link or literature on the above?

Re: Retrive data from SQL database & store it in Excel file

David Crow1-Apr-09 2:49

David Crow

1-Apr-09 2:49

diptipanchal wrote:
Could you send me some link or literature on the above?

I have 2 semi-related articles.

Creating a language pack............

Purish Dwivedi30-Mar-09 22:22

Purish Dwivedi

30-Mar-09 22:22

How do we create a language pack?
Is there any tutorial available ?
Please provide the link.
Thanks

Re: Creating a language pack............

Iain Clarke, Warrior Programmer30-Mar-09 23:39

Iain Clarke, Warrior Programmer

30-Mar-09 23:39

If you mean for windows? I strongly doubt you can.

If you mean you want to have multiple resources in different languages in your software, well, just go and add them! Just right click to get properties and set the language of your choice.

There are articles on CP about internationalization / internationalisation you can read for more information.

Good luck,

Iain.

In the process of moving to Sweden for love (awwww).
If you're in Scandinavia and want an MVP on the payroll (or happy with a remote worker), give me a job!

Re: Creating a language pack............

Dimitris Vasiliadis31-Mar-09 8:37

Dimitris Vasiliadis

31-Mar-09 8:37

Maybe it's "Resource Only Dlls" you are looking for.

...Plug & Pray... Dead | X|

Re: Creating a language pack............

Purish Dwivedi31-Mar-09 20:14

Purish Dwivedi

31-Mar-09 20:14

I have created Resource only DLLs already but my system is not supporting all languages.
This will happen with the client also. So how can I support languages without installing language pack either through WIN XP CD or through microsoft site.
Where can I get free language pack which I can attach with my software.
Plz reply soon.
Thanks

Memory leak when return char* from DLL

Shivanand Gupta30-Mar-09 22:13

Shivanand Gupta

30-Mar-09 22:13

Hi ,
I have a problem of memory leak when we call a function from win 32 DLL in our MFC program.
DLL is C type and return value of my DLL is Char* and it is locally defined in function of DLL. and size is 1024 byte.

when functon call four times then MFC application hold 4 KB Extra memory.

Re: Memory leak when return char* from DLL

Rajesh R Subramanian30-Mar-09 22:16

Rajesh R Subramanian

30-Mar-09 22:16

Is the DLL allocating memory that the char* points to, on the heap? Probably then the calling application must free this memory up? Do you have any docs for that DLL? Or if you have the source code, you may verify this.

It is a crappy thing, but it's life -^ Carlo Pallini

Re: Memory leak when return char* from DLL

Shivanand Gupta30-Mar-09 23:18

Shivanand Gupta

30-Mar-09 23:18

i m using New and Delete in calling application(MFC).
but "delete []cData;" line have error runtime.
if we use cData='\0' and after this "delete []cData;"
then memory leak still continue.

how can free memory in MFC application.

Re: Memory leak when return char* from DLL

Rajesh R Subramanian30-Mar-09 23:32

Rajesh R Subramanian

30-Mar-09 23:32

If the memory is allocated with new in the DLL, then clean it up with delete after you've used the data. Where is the difficulty? I don't see anything more to 'discuss' about here.

It is a crappy thing, but it's life -^ Carlo Pallini

Re: Memory leak when return char* from DLL

Shivanand Gupta31-Mar-09 0:15

Shivanand Gupta

31-Mar-09 0:15

Actually i am using static linking a dll.
so when we used delete then runtime error occor about heap

Re: Memory leak when return char* from DLL

Akt_4_U30-Mar-09 22:18

Akt_4_U

30-Mar-09 22:18

When returning char* as return value, you must allocate memory in heap(using malloc or new), from your DLL and deallocate this memory(free or delete) after usage from the calling applciation.

prvn

Re: Memory leak when return char* from DLL

Shivanand Gupta30-Mar-09 23:16

Shivanand Gupta

30-Mar-09 23:16

i m using New and Delete in calling application(MFC).
but "delete []cData;" line have error runtime.
if we use cData='\0' and after this "delete []cData;"
then memory leak still continue.

Re: Memory leak when return char* from DLL

Iain Clarke, Warrior Programmer30-Mar-09 23:44

Iain Clarke, Warrior Programmer

30-Mar-09 23:44

shivanandgupta wrote:
if we use cData='\0' and after this "delete []cData;"
then memory leak still continue.

That should not be a surprise...

Either you are just making a silly mistake (which we all do), or it's a bit more complex and you are allocating and freeing from different heaps. This could happen if you statically link to the C++ runtime.

One simple choice would be to use IMalloc to allocate / free chunks of memory. Look at CoGetMalloc etc for documentation.

I still think it's likely to be something dumb... Are you sure the memory is not already freed elsewhere?

Iain.

In the process of moving to Sweden for love (awwww).
If you're in Scandinavia and want an MVP on the payroll (or happy with a remote worker), give me a job!

Re: Memory leak when return char* from DLL

Shivanand Gupta31-Mar-09 0:17

Shivanand Gupta

31-Mar-09 0:17

Thanks for Reply
i am calling DLL statically

Re: Memory leak when return char* from DLL

Shivanand Gupta31-Mar-09 1:04

Shivanand Gupta

31-Mar-09 1:04

i don't have any idea to use Imalloc and cogetmalloc function to free memory.
i m using statically DLL not a COM

Re: Memory leak when return char* from DLL

Niklas L1-Apr-09 1:46

Niklas L

1-Apr-09 1:46

shivanandgupta wrote:
if we use cData='\0' and after this "delete []cData;"
then memory leak still continue.

Well, if you set cData to '\0' you are manipulating the pointer, not the data it contains.

cData is set to null, and that is what you try to delete (and it always succeeds.)

Doesn't the DLL supply an API for freeing this string? IMHO dll's should always be designed that way.

home

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