Re: Read / Create Excel file with out using odbc - C / C++ / MFC Discussion Boards

KarstenK4-Jan-10 2:01

4-Jan-10 2:01

check that the work of the Java-App isnt virtualized.

It isnt the right way to create some directories in the prog dir, if it isnt a installation. Better use the user-dirs

Press F1 for help or google it.
Greetings from Germany

Re: User permission problem with MFC

bhanu_85094-Jan-10 5:32

bhanu_8509

4-Jan-10 5:32

If I use the All Users/Application Data/ directory then the files created by Administrator cannot be overwrite by the Limited account user.

Please help me.

Re: User permission problem with MFC

KarstenK4-Jan-10 20:38

KarstenK

4-Jan-10 20:38

user data belongs in the user directorys.

If it are global settings than the admin can also write them in the registry.

Is is an architectual issue Unsure | :~

Press F1 for help or google it.
Greetings from Germany

Re: User permission problem with MFC

Rolf Kristensen6-Jan-10 10:45

Rolf Kristensen

6-Jan-10 10:45

A dirty hack could be to create an installer for your application, that grants access to everyone to the application folder.

One have to be an administrator to install the application, but then any user can use it.

Read / Create Excel file with out using odbc

Game-point3-Jan-10 23:00

Game-point

3-Jan-10 23:00

Hello Sirs,

How to Excel file read and create without using odbc.

Thanks

Failure is Success If we learn from it!!

Re: Read / Create Excel file with out using odbc

Cedric Moonen3-Jan-10 23:15

Cedric Moonen

3-Jan-10 23:15

Google for "Excel automation".

Cédric Moonen
Software developer

Charting control [v3.0 - Updated]
OpenGL game tutorial in C++

Re: Read / Create Excel file with out using odbc

Paresh Chitte3-Jan-10 23:42

Paresh Chitte

3-Jan-10 23:42

Please refer,

http://msdn.microsoft.com/en-us/library/aa155776%28office.10%29.aspx[^]
http://support.microsoft.com/kb/216686/[^]

Hope this will help.

Regards,
Paresh.

Re: Read / Create Excel file with out using odbc

CikaPero13-Jan-10 23:35

CikaPero

13-Jan-10 23:35

Hi,

I recommend that you don't use Excel Interop because it has many known issues, especially when used in web applications.

You could check out GemBox.Spreadsheet .NET Excel component for reading and writing XLS, XLSX, CSV, ODS and HTML files.

It is independent of Excel, light on resources and extremely fast.

It also supports advanced scenarios like Excel export/import to DataTable so you can easily bind your Excel files to UI controls with data binding.

Save Excel to ASP.NET stream web demo demonstrates it's usage in web application.

Connect to IRC server

Thilek3-Jan-10 20:55

Thilek

3-Jan-10 20:55

Hi guys,

I would like to create a simple program that can connect to a irc server and then send message on the main.. Can anyone give me ideas how to do it.... i have seach for some simple code but then could nt run on my visual studio since its showing so many errors...

can anyone given some simple codes to connect ?

Thank you.

Re: Connect to IRC server

ThatsAlok3-Jan-10 22:09

ThatsAlok

3-Jan-10 22:09

Thilek wrote:
I would like to create a simple program that can connect to a irc server and then send message on the main.. Can anyone give me ideas how to do it.... i have seach for some simple code but then could nt run on my visual studio since its showing so many errors...

I think you should search for simple socket based application, or try to create some client-server based application before actually jumping in Internet relay chat arena....

Frankly speaking, it will give great help and knowledge to you, once you able to make urself a small chattign application.

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
Never mind - my own stupidity is the source of every "problem" - Mixture

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

Re: Connect to IRC server

Moak3-Jan-10 23:12

Moak

3-Jan-10 23:12

Have a look at Beej's guide to networking programming[^], another starting point is the Winsock Programmer's FAQ[^], both come with examples. The rest is IRC protocol specific,

/M

Webchat in Europe Java | [Coffee]

(only 4K)

Re: Connect to IRC server

Thilek4-Jan-10 19:25

Thilek

4-Jan-10 19:25

Thanks guys... i manage to write the program in JAVA since i did socket programming in JAVA before.... i will try to work on this first.. once its could be done as i wanted, then i will do it with C++ since i wanted the program to be in C++ Smile | :)

Thanks a lot with your ideas and suggestions... It was all about socket to connect to IRC... never know it will be easy as this.... Really helped me..

disable CString value

Rakesh53-Jan-10 20:41

Rakesh5

3-Jan-10 20:41

hi all,

i have a value like this in my application..

CString strTemp = "hello world";

now, i want the word "world" to be disabled(grayed out..) like wat appear in a static text box..

is it possible?

Thanks,
Rakesh.

Re: disable CString value

KingsGambit3-Jan-10 20:50

KingsGambit

3-Jan-10 20:50

CString class holds just a string (array of characters). It doesn't have any color information associated with it.

Re: disable CString value

Cedric Moonen3-Jan-10 20:55

Cedric Moonen

3-Jan-10 20:55

How are you displaying the string ? As already mentioned by somebody else, CString is just a class containing data and doesn't have any relation with how it will displayed.

Cédric Moonen
Software developer

Charting control [v3.0 - Updated]
OpenGL game tutorial in C++

Re: disable CString value

«_Superman_»3-Jan-10 21:12

«_Superman_»

3-Jan-10 21:12

What you want is a different color for a word.
You can only disable/enable windows and not words.
Also as Rejeesh said, you cannot do that with a CString alone.
You could use a control similar to a rich edit control and show one word with a different color.

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

Microsoft MVP (Visual C++)

Re: disable CString value

Nelek3-Jan-10 22:02

Nelek

3-Jan-10 22:02

If you are using the string in pDC->TextOut (...) you can do it as well by changing the font color, but you can't do it only depending on words, you will need different strings, so you print one, change the color and then print the next.

this[^] or this[^]may be useful for you as well.

Regards.
--------
M.D.V. Wink | ;)

If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpfull answers is nice, but saying thanks can be even nicer.

Re: disable CString value

Rajesh R Subramanian3-Jan-10 22:15

Rajesh R Subramanian

3-Jan-10 22:15

Rakesh5 wrote:
i have a value like this in my application..

CString strTemp = "hello world";

now, i want the word "world" to be disabled(grayed out..) like wat appear in a static text box..

is it possible?

Sorry, but that isn't possible.

Kindly buy and read a beginner level book on Windows programming.

“Follow your bliss.” – Joseph Campbell

Re: disable CString value

Michael Schubert4-Jan-10 5:10

Michael Schubert

4-Jan-10 5:10

One way to store colour information in a CString is to use HTML tags and then dump the string into a HTML enabled control.

-or-

Use RTF codes and dump into a Rich Edit Control.

Re: disable CString value

CPallini4-Jan-10 11:36

CPallini

4-Jan-10 11:36

Michael Schubert wrote:
One way to store colour information in a CString is to use HTML tags and then dump the string into a HTML enabled control.

Another way to store color information in a CString:

CString strBackground = "Blue";

(pardon!)

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: disable CString value

Michael Schubert4-Jan-10 22:00

Michael Schubert

4-Jan-10 22:00

Good point.

Another method:
CString strBackground = "Blue";

Re: disable CString value

CPallini4-Jan-10 22:27

CPallini

4-Jan-10 22:27

CString strBackground = "█";
Big Grin | :-D

Assertion error in SetWindowPos()

Anu_Bala3-Jan-10 19:01

Anu_Bala

3-Jan-10 19:01

Im using following code to reduce the dialog width.it show assertion error

void CToolTab::ReduceWidth()
{
	this->SetWindowPos(&CWnd::wndBottom,0,80,100,800,SWP_NOSIZE);
}

assertion error in bolded line

BOOL CWnd::SetWindowPos(const CWnd* pWndInsertAfter, int x, int y, int cx,
	int cy, UINT nFlags)
{
	ASSERT(::IsWindow(m_hWnd) || (m_pCtrlSite != NULL));

Here m_hWnd shows 0x0000.
Im reducing the width after pressing button in the same dialog.

Anu

Re: Assertion error in SetWindowPos()

KingsGambit3-Jan-10 19:34

KingsGambit

3-Jan-10 19:34

From which function are you calling ReduceWidth()?

Re: Assertion error in SetWindowPos()

«_Superman_»3-Jan-10 19:36

«_Superman_»

3-Jan-10 19:36

I believe you're calling SetWindowPos in a place where the window has not been created yet.
Is it in the WM_SIZE handler?

Add a condition before you call SetWindowPos.

if (::IsWindow(this->m_hWnd))
    this->SetWindowPos(&CWnd::wndBottom,0,80,100,800,SWP_NOSIZE);

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

Microsoft MVP (Visual C++)

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