Hi, I am tejaswi and having a small doubt in VB regarding the collections class. The following code Is not working Dim temp as new clsParameterDetail Dim objcoll as new collection Temp.initializeobj() Objcoll.add( temp) Where as if I declare it as an array ( dim temp() as new clsParameterDetail ) And after redimensioning and initializing the temp array, It is accepting the statement (Objcoll.add(temp) ) What is the difference between an array and normal object. In case of a single object the .add is not working( giving a message like ‘property or method is not supported’) where as in case array it is accepting. It is not even accepting sth like objcoll.add(temp(parameterCount)) but it is accepting for strings even if it is not an array . Please clarify my count. And one more thing is – Is CType(obj,TypeName) a function available in visulbasic or only .net ? if in vb any references to be added , this function is not available here in vb here.here if i type vba. ,all are coking like cstr e.t.c but ctype i snot coming.

Hi, I am tejaswi and having a small doubt in VB regarding the collections class. The following code Is not working Dim temp as new clsParameterDetail Dim objcoll as new collection Temp.initializeobj() Objcoll.add( temp) Where as if I declare it as an array ( dim temp() as new clsParameterDetail ) And after redimensioning and initializing the temp array, It is accepting the statement (Objcoll.add(temp) ) What is the difference between an array and normal object. In case of a single object the .add is not working( giving a message like ‘property or method is not supported’) where as in case array it is accepting. It is not even accepting sth like objcoll.add(temp(parameterCount)) Please clarify my count. And one more thing is – Is CType(obj,TypeName) a function available in visulbasic or only .net ? if in vb any references to be added , this function is not available here in vb here.here if i type vba. ,all are coking like cstr e.t.c but ctype i snot coming.

there is a grid control in one window. i am trying to read the contents of that grid . using getclassname() function i have got the name of that controls class as 'ApexGrid.19'. now i am having a handle to that control. and class name. next i want to make use of this information to read that controls data. is there any way how to do it. how to get the various interfaces provided by that class. and how to include and use that class in our vc applications. please tell me.

nothing harm just. just i was afraid if sbdy access the contents of that file along its original contents these quotes may also come and disturb. thats why. no other problems.

hi .problem here . canu please tell how to establisth a connection between two databases. my problem is like this. there are two databases ( 2 objecs of Cdatabase class) one is an ms access database and other is excel database. i want to use tables of msaccess in excel database. both are in two different locations ( on the pc). is there any way of importing tables from msaccess database to other one. or any opther kind of a solution please . waiting for ur replyy. tejaswi.

i did not get whatu are telling. actually all those values in the values string are text values. so them i have written as 'content' . because in the sql sltatement they should be given as insert into tablename values('text1','text2',number e.t.c); so have used format('%s', variablevalue) for forming ValuesString . just now have seen while trying to print into number fields it is giving normally but while printing text values , the value of the cell is shown as normally only but preceded by a ' symbol when double clicking on the cell. after dblclk on cell the value is like '1234 for text, copy cell contents and paste it elsewhere in note pad they appearing like: ECMName MID_Hex peninsula 5678

thank you all very much

sSql.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s", sDriver,gsExcelFileName,gsExcelFileName); if( database.OpenEx(sSql,CDatabase::noOdbcDialog) ) { //Create table structure sSql = "Create Table MIDs ( ECMName TEXT,MID_Hex TEXT,MID_Dec TEXT,GroupBroadcast TEXT,ME_Number TEXT,AlarmLevel TEXT,SpecialWarning TEXT,AbuseType TEXT,ParameterName TEXT,Status TEXT,Instruction TEXT,MID TEXT,CID TEXT,DeleteCIDs TEXT,Display TEXT,Log TEXT,ServiceLamp TEXT,Telemetry TEXT,EventRecorder TEXT,ESET TEXT,Start TEXT,Actuate TEXT,Deactuate TEXT,Acknowledge TEXT,ServiceLight TEXT )"; //HistogramID number, HIstogramFormula TEXT)"; database.ExecuteSQL(sSql); . . . . . // The below is all sqlstatement how it is constructed. ValuesString.Format("'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s'",ControlValueArray[44][1],MIDHexValue,ControlValueArray[43][1],ControlValueArray[2][1],ControlValueArray[3][1],AlaramLevel,ControlValueArray[38][1],ControlValueArray[39][1],ControlValueArray[44][1],ControlValueArray[41][1],ControlValueArray[42][1],ControlValueArray[43][1],ControlValueArray[4][1],DeleteCIDs,ControlValueArray[32][1],ControlValueArray[31][1],ControlValueArray[30][1],ControlValueArray[29][1],ControlValueArray[33][1],ControlValueArray[28][1],"N/A",ControlValueArray[15][1],ControlValueArray[16][1],ControlValueArray[17][1],ControlValueArray[18][1] ); sSql = "INSERT INTO MIDs(ECMName ,MID_Hex ,MID_Dec ,GroupBroadcast ,ME_Number ,AlarmLevel ,SpecialWarning ,AbuseType ,ParameterName ,Status ,Instruction ,MID ,CID ,DeleteCIDs ,Display ,Log ,ServiceLamp ,Telemetry ,EventRecorder ,ESET ,Start ,Actuate ,Deactuate ,Acknowledge ,ServiceLight ) VALUES ("+ ValuesString+ ")"; database.ExecuteSQL(sSql); database.Close(); Like this it is adding to excel.

hi canu please tell me h ow to connect to a database created in microsoft access and acces data sign CDatabase class.

hi I am tejaswi . I wanted to read the contents from editboxes of a dialog window. am able to do so except for one edit box. That is apperaring on the screen as if it is read only. but not even able to copy the contents of that one manually. The caret is not coming there even if i click on the box with mouse. please tell how to read contents of it. any property is to be set or what. Thank you. Tejaswi

Thank you very much.

can u please tell me how to manipulate with one window in a dialogbox that looks like a grid of editboxes containing many rows,columns ( sth like the local variables window which appear in vc++ while doing step debugging).what kind of a control is it? for an edit box u sing the GetWindowText we can get its contents. pleas help me how to get the many values present in that grid object(window).

please validate the code here if sth is wrong. Only the case for edit box controls it is not working , i am tinking if any locking they have done there. have tried many other options also all of them commented in the below code. the main window therei is 'System Event" from which i anm trying to read the contents of all its sub windows( edit boxes e.t.c) void WManip(CWnd *WndActiveChild ,CWnd *WndParent) { CWnd * WndActiveChildRead; CEdit *WndEdit; LPTSTR EditText; COleDataObject ClipObj; tagSTGMEDIUM *strVar; LPCTSTR lpctFormat; int ControlID,WinCount = 0; CString rString,temprString,text; WndActiveChild->SetForegroundWindow(); WndActiveChild->SetFocus(); // WndActiveChild->OpenClipboard(); // if (( (WndActiveChild->GetClipboardOwner()) ->GetWindowText(rString) ) != 0 ) // (WndActiveChild->GetClipboardOwner()) ->GetWindowText(rString); // if (rString != "") // AfxMessageBox("some thingn hapend "+rString); ControlID = WndActiveChild->GetDlgCtrlID(); WndActiveChild->GetWindowText(rString); AfxMessageBox(rString); //WndEdit = WndActiveChild ; // ClipObj.AttachClipboard(); // strVar = new tagSTGMEDIUM; // ClipObj.GetData(CF_TEXT, strVar,NULL); // WndActiveChild ->GetLine(0,EditText); // WndParent ->GetDlgItemText(ControlID,rString); // temprString.Format("%s%d%s", (LPCTSTR) rString,ControlID, (LPCTSTR)EditText ); //(LPCTSTR) rString, AfxMessageBox(temprString); // the following code is just for testing i have put. if (rString.Compare("&Edit") == 0) { WndActiveChild->PostMessage(WM_LBUTTONDOWN,0,0); Sleep(50); WndActiveChild->PostMessage(WM_LBUTTONUP,0,0); // WndParent->CheckDlgButton(i,1); } // WndActiveChild->EnableWindow(false); WinCount ++; } void CConfigTool_AutomateDlg::OnOK() { int i,WinCount = 0; CString rString,temprString,text; CEdit EControl; CWnd * pActWindow,*pActChildWindow,*pActChild1Window, *pActChild2Window ; // pActWindow = CWnd::GetActiveWindow(); pActWindow = CWnd::FindWindow(NULL ,"System Event"); pActWindow->SetForegroundWindow(); // pActWindow->ShowWindow(SW_SHOWMAXIMIZED); pActChildWindow = pActWindow->GetTopWindow(); while (pActChildWindow != NULL) { WinCount ++; pActChild1Window = pActChildWindow->GetTopWindow(); while(pActCh

hello friend, i want a help regarding retrieving data from a Window's Edit boxes. The situation is like this:There is a window( seems to be a dialog box produced by some Application). The window is containing many sub windows(controls inside it). my requirement is to read the data present in those controls/sub windows/edit boxes. The extent to which i have come is, able to get a handle to that edit box( of class CWND). with that handle it is also working if i try to enable/disable all windows/controls present in a maibn parent window . if i am using the function ::GetWindowText(), i am not getting the text in that edit box( where as for all button window i am getting their captions like &OK,&Edit e.t.c). please tell me how to access the text present in the editboxes. and my problem is like this said above in last paragraph.