C / C++ / MFC

Create a window in an ATL control

26-Nov-02 6:25

Are you willing to use Office Automation? That is probably your best bet, but when you build the app that uses office automation, it is dependant on a specific version of Excel. Here's the main page on MSDN for office automation docs:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoffdev/html/vsofficedev.asp

Once you're there, click on the link called "Visual C++/MFC - Information and Sample Code". Once there, you just scroll a bit to a sub heading called "Microsoft Excel Automation". You'll find several examples there that should help you get going. The first one looks like it may help you http://support.microsoft.com/default.aspx?scid=KB;en-us;q179706

Good luck.

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall

Jerome Conus25-Nov-02 22:02

Jerome Conus

25-Nov-02 22:02

Hi !

My app (VC6) is an ATL object, and I would like, during the initialization of the object, to create a window and to post messages to this window. Right now, the only thing the app is doing is to display a message box when a message is received....nad it doesn't work !!!

Here is what I'm doing :

Here is my window class :

<br />
#include "atlwin.h"<br />
#define WM_MYMESSAGE WM_APP+1<br />
<br />
class CMyWindow : public CWindowImpl<CMyWindow><br />
{<br />
public:<br />
   CMyWindow(){};<br />
   virtual ~CMyWindow(){};<br />
   DECLARE_WND_CLASS("MyWindow") <br />
<br />
   BEGIN_MSG_MAP(CMyWindow)<br />
      MESSAGE_HANDLER(WM_MYMESSAGE, OnMyMessage)<br />
   END_MSG_MAP()<br />
<br />
   LRESULT OnMyMessage(UINT nMsg, WPARAM wParam, LPARAM lParam, BOOL& Handled)<br />
   {<br />
      ::MessageBox(NULL,"Message","Message",MB_OK);<br />
      return 0;<br />
   }<br />
};<br />

and here is my interface code (in the class declaration, I just added a member of type CMyWindow*) :

<br />
CEventBox::CEventBox()<br />
{<br />
   m_pMyWindow=new CMyWindow;<br />
   RECT myRect;<br />
   myRect.bottom=100;<br />
   myRect.left=0;<br />
   myRect.top=0;<br />
   myRect.right=100;<br />
   m_pMyWindow->Create(NULL, myRect, NULL, 0, 0, 0U, NULL);<br />
}<br />
<br />
STDMETHODIMP CEventBox::SendEvent(long lNbrEvent, long lSpaceTime)<br />
{<br />
   PostMessage(m_pMyWindow->m_hWnd,WM_MYMESSAGE,0,0);<br />
   return S_OK;<br />
}<br />

For my tests, I try to use this ATL object in a VB project, where I call the method 'SendEvent' of the interface. Nothing crashed but I cannot see the window I created in the constructor of CEventBox and the message box of OnMessageBox is never displayed.

Any help will be greatly appreciated !
Thank you !
Jerome

Dynamicly create controls in dialog + scroll bar?

anonimous25-Nov-02 21:53

anonimous

25-Nov-02 21:53

Hi,
I like to create a nice looking icon list (similar to this).

I'm not skilled in GUI programming, so I like to ask for help. How about creating an empty CDialog, then dynamlically create and position all my icons and texts (icons can vary on runtime). Well, this would be similar to HTML and a scripting language filling the page with icons and text.

I have two questions:
1. Where do I create my controls, OnInitDialog() or PreSubclassWindow()? Sumthing I have too look at?
2. How do I get a scrollbar when controls do not fit into the dialog? For example when I have lots of icons, then the dialog should automatically show a vertical scroll bar.

Thanks for pushing me into the right direction. Smile | :)

Re: Dynamicly create controls in dialog + scroll bar?

Anonymous26-Nov-02 11:23

Anonymous

26-Nov-02 11:23

anyone a comment?

How to get NT group name from Windows 9x/ME client?

Ruxo Zheng25-Nov-02 20:15

Ruxo Zheng

25-Nov-02 20:15

My company has a NT domain server, connected by Windows 9x/Me clients. I want to write a program checking the user's group for authorization. Which WinAPI function can provide such information for window 9x/Me clients? Thanks. Dead | X|

Ruxo Zheng

help: ODBC CRecordSet update delay..

trustno125-Nov-02 18:42

trustno1

25-Nov-02 18:42

hi everyone,

my sdi application is base on listview and the contents displayed in the listview are retrieved from a database.. the database is accessed via odbc.. i use a dialog to gather input information.. whenever the information is submitted from the dialog, i created a crecordset/odbc object within the additem function in the dialog class and make sql insert call within the dialog class.. i called the updateallviews function from the sdi/listview right after the new new data is stored in the database, ie when the dialog get destroyed..

i'm getting the database update delay problem.. whenever i call updateallviews, the content of the listview doesn't get updated(the newly added item doesn't show up) until i call updateallviews the 2nd time.. does anyone know how to solve this database delay problem? thx!

SetItemText

David Kadish25-Nov-02 18:33

David Kadish

25-Nov-02 18:33

To All,
I am using SetItemText after the column is properly inserted and the InsertItem function is called. The Scrollbar shows that the rows have been inserted, but I can't see any text when using SetItemText. What a headache. What should I do? Eek! | :eek:

Roman Fadeyev25-Nov-02 18:57

Roman Fadeyev

25-Nov-02 18:57

David Kadish wrote:
What should I do?
You should write with what type of control you work. It is a ListView? Show a code. Do you think we have a telepathy?

perlmunger25-Nov-02 19:39

25-Nov-02 19:39

The List control can be a little bit quirky sometimes. Not knowing what your code looks like makes it a little difficult to diagnose, but here is my InsertItem/SetItemText code for a front-end application to a DVD collection database:

for( int i = 0; i < m_titles.GetSize(); ++i )
{

    CMovieTitle* title = (CMovieTitle*)m_titles[i];

    int itemCount = m_movieList.GetItemCount();
    m_movieList.InsertItem(itemCount, title->m_sTitle ,0);
    m_movieList.SetItemText(itemCount,1,title->m_sFormat);
    m_movieList.SetItemText(itemCount,2,title->m_sRegionCode);
    m_movieList.SetItemText(itemCount,3,title->m_sRating);
    m_movieList.SetItemText(itemCount,4,title->m_sReleaseDate);
    m_movieList.SetItemText(itemCount,5,title->m_sVideoReleaseDate);
    m_movieList.SetItemText(itemCount,6,title->m_sStudio);
    m_movieList.SetItemText(itemCount,7,title->m_sPresentation);
    m_movieList.SetItemText(itemCount,8,title->m_sFeatures);
    m_movieList.SetItemText(itemCount,9,title->m_sSound);
    m_movieList.SetItemText(itemCount,10,title->m_sLanguage);
    m_movieList.SetItemText(itemCount,11,title->m_sDuration);
}

CMovieTitle is a wrapper class that I use to hold one record from the database. In this example I am iterating through all of the records and inserting the data into a list control.

You also may be interested in how I am initializing my list control. Here's my code from OnInitDialog (my app is a dialog app):

m_movieList.InsertColumn( 0, "Movie Title", LVCFMT_LEFT, -1, 0);
m_movieList.InsertColumn( 1, "Format", LVCFMT_LEFT, -1, 1);
m_movieList.InsertColumn( 2, "Region Code", LVCFMT_LEFT, -1, 2);
m_movieList.InsertColumn( 3, "Rating", LVCFMT_LEFT, -1, 3);
m_movieList.InsertColumn( 4, "Release Date", LVCFMT_LEFT, -1, 4);
m_movieList.InsertColumn( 5, "Video Release Date", LVCFMT_LEFT, -1, 5);
m_movieList.InsertColumn( 6, "Studio", LVCFMT_LEFT, -1, 6);
m_movieList.InsertColumn( 7, "Presentation", LVCFMT_LEFT, -1, 7);
m_movieList.InsertColumn( 8, "Sound", LVCFMT_LEFT, -1, 8);
m_movieList.InsertColumn( 9, "Features", LVCFMT_LEFT, -1, 9);
m_movieList.InsertColumn( 10, "Language", LVCFMT_LEFT, -1, 10);
m_movieList.InsertColumn( 11, "Duration", LVCFMT_LEFT, -1, 11);

m_movieList.SetColumnWidth( 0, 60 );
m_movieList.SetColumnWidth( 1, 60 );
m_movieList.SetColumnWidth( 2, 60 );
m_movieList.SetColumnWidth( 3, 60 );
m_movieList.SetColumnWidth( 4, 60 );
m_movieList.SetColumnWidth( 5, 60 );
m_movieList.SetColumnWidth( 6, 60 );
m_movieList.SetColumnWidth( 7, 60 );
m_movieList.SetColumnWidth( 8, 60 );
m_movieList.SetColumnWidth( 9, 60 );
m_movieList.SetColumnWidth( 10, 60 );
m_movieList.SetColumnWidth( 11, 60 );

I hope this helps. If you have questions after looking at my code (which has been tested, BTW), feel free to send them my way.

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall

Rage25-Nov-02 20:16

Rage

25-Nov-02 20:16

perlmunger wrote:
m_movieList.SetColumnWidth( 0, 60 ); m_movieList.SetColumnWidth( 1, 60 ); m_movieList.SetColumnWidth( 2, 60 ); m_movieList.SetColumnWidth( 3, 60 ); m_movieList.SetColumnWidth( 4, 60 ); m_movieList.SetColumnWidth( 5, 60 ); m_movieList.SetColumnWidth( 6, 60 ); m_movieList.SetColumnWidth( 7, 60 ); m_movieList.SetColumnWidth( 8, 60 ); m_movieList.SetColumnWidth( 9, 60 ); m_movieList.SetColumnWidth( 10, 60 ); m_movieList.SetColumnWidth( 11, 60 );

Hi Matt,

Ever heard about that for{} instruction Poke tongue | ;-P

;P;P?

~RaGE();

perlmunger26-Nov-02 3:52

Make programme identify multi-display

26-Nov-02 3:52

Ever heard how inefficient for loops are? Might be tidy, but it is certainly slower. Not to mention, my column widths may not always be equal. Wink | ;-)

Thanks.

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall

TianYang25-Nov-02 17:56

TianYang

25-Nov-02 17:56

My computer have two VGA adapter ( No.1, No.2 ), set No.1 to the main display, No.2 is free, I want capture the content of No.1, then make some transform and copy to No.2.

The puzzle is, how to identify No.2( or No.3, No.4.. ), as far as know the function GetDC( NULL ) can get desktop( main display ) content.

Re: Make programme identify multi-display

Scott H. Settlemier26-Nov-02 6:50

Scott H. Settlemier

26-Nov-02 6:50

use EnumDisplayMonitors[^];
I think the callback gets you a dc
to the particular portion of the
virtual desktop for each monitor.

ADO Field names

devvvy25-Nov-02 16:44

25-Nov-02 16:44

hi, this old question... I need to retrieve the names of all columns given a table in form of an array of "char*"

I wrote. But this is syntatically incorrect of course:

pRs->Fields->GetItem( _variant_t(i))->get_Name(bstrFieldName);

tried to search for samples, all in VB:

For Each objField In objRecordset.Fields
' convert BSTR field name into char* field name....

Next

Havent been able to find one VC yet. Perhaps u can speed me up. THanks!

norm

Re: ADO Field names

perlmunger25-Nov-02 19:04

25-Nov-02 19:04

If you know the column number of the column name you're looking for, just do this:

short colIndex = 5;

CODBCFieldInfo info;
pRs->GetODBCFieldInfo(colIndex, info);

// do something with info.m_strName
// which now contains the column name

If you need to iterate through the fields, just get a column count with GetODBCFieldCount() on the recordset and loop through calling GetODBCFieldInfo each time.

Hope this helps.

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall

thanks but....

devvvy25-Nov-02 20:33

help! ADO - how to determine if a field is PK/FK

25-Nov-02 20:33

thanks but i was explicitly told that this job be done via ADO...

anyway, but one more question:

how can u check if a field is a PK or FK? ADO recordset Field properties?

Code fragment would be appreciated.

THnaks

norm

Re: thanks but....

Alexandru Savescu25-Nov-02 21:43

Alexandru Savescu

25-Nov-02 21:43

You may consider using Carlos Antollini ADO classes from here[^]

Best regards,
Alexandru Savescu

P.S. Interested in art? Visit this!

devvvy25-Nov-02 23:22

25-Nov-02 23:22

...

i'm almost done with my module... just need this one last line to determine whether a field is a PK or FK...

To get field name:
pRs->Fields->Item[j]->get_Name(&bstrFieldName);
//Convert BSTR to char*
if(pszFieldName==NULL)
{
//Additional error handling here.

}
WideCharToMultiByte(CP_ACP, 0, bstrFieldName, -1, pszFieldName, this->m_nMaxFieldName+1, NULL, NULL);

To get Field Type:
_itoa(pRs->Fields->Item[j]->Type, pszFieldType, 10);

But just dont know how to determine if a field is PK/FK (primary key and foreign key). and MSDN documentation for VC developers is so bad.

help!

norm

any ADO/C++ solution?

devvvy26-Nov-02 7:58