|
Hi,
some sample code for read data from xls file.
CDatabase database;
CString sSql;
CString Name, Address;
CString sDriver;
CString sDsn;
CString sFile = "c:\\kdr.xls"; // the file name. Could also be something like C:\\Sheets\\WhatDoIKnow.xls
// Clear the contents of the listbox
m_List.ResetContent();
// Retrieve the name of the Excel driver. This is
// necessary because Microsoft tends to use language
// specific names like "Microsoft Excel Driver (*.xls)" versus
// "Microsoft Excel Treiber (*.xls)"
sDriver = GetExcelDriver();
if( sDriver.IsEmpty() )
{
// Blast! We didn´t find that driver!
AfxMessageBox("No Excel ODBC driver found");
return;
}
// Create a pseudo DSN including the name of the Driver and the Excel file
// so we don´t have to have an explicit DSN installed in our ODBC admin
sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile);
TRY
{
// Open the database using the former created pseudo DSN
// sSql = "INSERT INTO demo (Name,Address) VALUES ('Nilesh','Pune')";
// database.ExecuteSQL(sSql);
database.Open(NULL,false,false,sDsn);
// Allocate the recordset
CRecordset recset( &database );
// Build the SQL string
// Remember to name a section of data in the Excel sheet using "Insert->Names" to be
// able to work with the data like you would with a table in a "real" database. There
// may be more than one table contained in a worksheet.
sSql = "SELECT Name, Address "
"FROM demo "
"ORDER BY field_1";
// Execute that query (implicitly by opening the recordset)
recset.Open(CRecordset::forwardOnly,sSql);//,CRecordset::readOnly);
// m_List.AddString( Name + " --> "+Address );
// recset.Open(NULL,sSql,NULL);
// Browse the result
// while( !recset.IsEOF() )
// {
// Read the result line
recset.GetFieldValue("field_1",Name);
recset.GetFieldValue("field_2",Address);
// Insert result into the list
// m_List.AddString( Name + " --> "+Address );
// Skip to the next resultline
recset.MoveNext();
// }
// Close the database
database.Close();
}
CATCH(CDBException, e)
{
// A database exception occured. Pop out the details...
AfxMessageBox("Database error: "+e->m_strError);
}
END_CATCH;
}
problem occur after
recset.Open(CRecordset::forwardOnly,sSql);//,CRecordset::readOnly);
it is not enter into condition. go to catch and throw error
Database error : To few parameters expected 2. why this error occur. pls give me where I am wrong in code.
my aim is when I click on Read button, display data from file. kindly give me a reply.
regards
kedar
Girish
Software Developer
|
|
|
|
|
vcforums wrote: sSql = "SELECT Name, Address "
"FROM demo "
"ORDER BY field_1";
I suspect that this is your problem. I see where you selected into the demo table the Name and Address but there is no mention of a "field_1". If the field that is in your SQL select statement does not exist, then you will get that "too few parameters" error. Make sure that all of the fields exist in the database that you are trying to read.
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
|
|
|
|
|
hi all,
how to acess messages from MSMQ Events when message arrived from source to Destination in OnArrived() function.
thanks,
uday.
uday kiran
|
|
|
|
|
I've got a console project, just console.cpp; stdafx.cpp; stdafx.h
Then something happend to it and breakpoints started to appear randomly in the code after launching it in debug mode.
I've cleaned solution and rebuilded it, useless.
Now I deteleted Debug and Release dirs, deleted *.ncb; *.sln; *.suo files and loaded project again. Useless, launch it in debug and thats it! breakpoints start to appear randomly. Ahhhhh....
9ine
|
|
|
|
|
I have no idea what is wrong with your system - have you ruled out a hardware problem? Are any other applications or your system affected?
Have you run a virus/spyware checker recently?
[I cannot stand people that vote on something without providing feedback when their vote may not be obvious. I cannot imagine any intelligent reason to vote your post a "3"...]
Peace!
-=- James
If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong!
Avoid driving a vehicle taller than you and remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road!
DeleteFXPFiles & CheckFavorites (Please rate this post!)
|
|
|
|
|
Nothing in Quarantine folder.
None of my application are affected and everything works fine.
The only changes I've done in Tools->Options->TextEditor->C/C++->Tabs
changed tab size from 4 to 2. resulted in indentation in source code shifted.
returned it back from 2 to 4 to get original indentation
9ine
|
|
|
|
|
|
9ine wrote: ...breakpoints started to appear randomly in the code...
I've seen this several times with VC++ v6.
"Let us be thankful for the fools. But for them the rest of us could not succeed." - Mark Twain
"There is no death, only a change of worlds." - Native American Proverb
|
|
|
|
|
I have to create transparent static text in an ATL Composite Control.
I did map WM_CTLCOLORSTATIC & WM_CTLCOLORDLG messages like
MESSAGE_HANDLER(WM_CTLCOLORSTATIC, OnCtlColorStatic)
MESSAGE_HANDLER(WM_CTLCOLORDLG, OnCtlColorStatic)
LRESULT OnCtlColorStatic(UINT uMsg, WPARAM wParam, LPARAM lParam, BOOL& bHandled )
{
bHandled = TRUE;
SetBkMode((HDC) wParam, TRANSPARENT);
return (LRESULT)GetStockObject(HOLLOW_BRUSH);;
}
But the Static Text not become transprent. What should I do? ( This is a non MFC ActiveX)
( When I called ::SetBkColor((HDC) wParam, RGB(0,0,255)); from this function, the bg color changed)
Any hints will be great help
|
|
|
|
|
There are a lot of example on how to hook keyboard and mouse, but i still can't find an example about hooking serial communication..
Could someone help me?
|
|
|
|
|
Hi!
I have a multiple page tab with clistctrl in each page.
When I toggle to different tab page, i dont want to see any selected item in clistctrl.
If i select items in list control in the first tab for example, and then go the second tab, when i go back to first tab, no items should still be selected.
how to do that? please help
|
|
|
|
|
I think you have to deselect those elements when you switch the tab. Windows can do it for you. Sorry!
|
|
|
|
|
MFC: In OnActivate(), Deselect all items of the CListCtrl.
~RaGE();
|
|
|
|
|
lorey wrote: ...i dont want to see any selected item in clistctrl.
Use the CListCtrl::SetItem() method.
"Let us be thankful for the fools. But for them the rest of us could not succeed." - Mark Twain
"There is no death, only a change of worlds." - Native American Proverb
|
|
|
|
|
...monsocket.cpp(4) : fatal error C1853: 'Debug/reseaup.pch' is not a precompiled header file created with this compiler
-> help me pleaaaassee !! 
what should i do this time ? 
thankssssssssss
|
|
|
|
|
aren't you compiling with a different compiler from Visual C++ ?
delete the .pch file, and/or disable the precompiled headers in the project settings
|
|
|
|
|
Hi all
I'm looking forward to purchase ExeCryptor (www.strongbit.com) to protect my shareware written in C++. But before I'd like to know independent opinions/experience if any.
My question is: Anybody uses execryptor? Can you tell me smth about? Are there some problems? Is it cost-effective?
Thank you in advance for any reply
Jean
|
|
|
|
|
hello everybody .. i think that it's a stupid question but i need answer thanks my problem is as defined :
//this is my constructor ... in a class
<bold>
varstr= new char[0];
but when i do :
<bold>
cout <<strlen(varstr);< bold=""> it returns : 4
so i need that it returns 0 !!
thank you again
A C++ illetrate
|
|
|
|
|
try this: cout <<strlen(*varstr); - it might work just fine for you. Good luck!
P.S. strlen(varstr); it will always return 4 bytes since it's an ADDRESS 
|
|
|
|
|
sorry but definition is a char*.
this is what i have in the header file:
private:<br />
char* definition;<br />
public:<br />
CStrg();<br />
and in the cpp file i have this
CStrg::CStrg()<br />
{<br />
definition = new char[0];<br />
cout<<strlen(definition)<<endl;<br />
}
when i put :
cout<<strlen(*definition)<<endl;
i have this error:
...CStrg.cpp(10) : error C2664: 'strlen' : cannot convert parameter 1 from 'char' to 'const char *'
|
|
|
|
|
don't confuse strlen() and sizeof
|
|
|
|
|
You've allocated memory for your string but you haven't put anything inside it. It's just coincidence that your cout is printing 4.
You also need to do this:
varstr[0] = '\0' ;
BTW, you've only allocated enough space for 1 character and given that strings always need at least one character for the terminating '\0', your string is always going to be empty
0 bottles of beer on the wall, 0 bottles of beer, you take 1 down, pass it around, 4294967295 bottles of beer on the wall.
Awasu 2.2 [^]: A free RSS/Atom feed reader with support for Code Project.
|
|
|
|
|
thank you Taka Muraoka it's works fine
thank you everybody
|
|
|
|
|
Hi All,
I have a non mfc dll(does not contain the CWinApp) which needs to talk to 2nd dll which uses mfc as a shared dll.I want to make a call to the 2nd dll from the 1st one inorder to display a dialog box. I'm using LoadLibrary to load the 2nd dll from the 1st one and using GetProcAddress to get the address of the function which creates an object of dialog box and calls DoModal on it.But when I make a call in this manner, the code is crashing at ASSERT((p = pMap->LookupPermanent(m_hWnd)) != NULL ||
(p = pMap->LookupTemporary(m_hWnd)) != NULL); in Wincore.cpp
Can anyone please tell me what the problem is.
Thanks in advance
Raghu
|
|
|
|
|
have u called
AFX_MANAGE_STATE(AfxGetStaticModuleState());
in the first line of the function which creates the dialog?
nave
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
