C / C++ / MFC

text from edit to list box

4-Dec-02 0:15

i don´t know, if i understand you right, because my english is not so good.

if you have a listCtrl in MFC, for example: m_ctrlListBox, then you can add a string to the listbox: m_ctrlListBox.AddString("Hi");
if want to to select this entry you can do something like this:

<br />
m_ctrlList.AddString("Hi");<br />
m_ctrlList.SetCurSel(0);<br />
int place=m_ctrlList.GetCurSel();<br />
CString buffer;<br />
m_ctrlList.GetText(place, buffer);<br />

now the buffer includes the first entry of the listbox.

hope i could help you.
mfc

xxhimanshu3-Dec-02 23:21

xxhimanshu

3-Dec-02 23:21

i want to enter my edit box text into a list box. how it can be done? can anyone help..

himanshu

Re: text from edit to list box

Michael P Butler3-Dec-02 23:48

Michael P Butler

3-Dec-02 23:48

Are you using MFC?

CString sString = "";<br />
<br />
// Get edit box value<br />
m_edit.GetWindowText(sString);<br />
<br />
// Add edit box value to list control<br />
m_listbox.AddString(sString);

Michael

Fat bottomed girls
You make the rockin' world go round -- Queen

Re: text from edit to list box

Joan M3-Dec-02 23:54

Joan M

3-Dec-02 23:54

Try this:

<br />
CListBox a;<br />
CString b = "";<br />
<br />
yourEditBox.GetWindowText(&b);<br />
a.AddString(b);<br />

Of course you can change the CString and the GetWindowText(...) for a CString variable linked to your editbox... if you want to do it in this way you must call UpdateData();

hope this helps...

Re: text from edit to list box

xxhimanshu4-Dec-02 0:06

xxhimanshu

4-Dec-02 0:06

thanks a lot.. Smile | :)

Problems with data conversion

Gian3-Dec-02 22:57

Gian

3-Dec-02 22:57

Hi,
i've a problem converting data from a format to another. the function

VARIANT SaveToMemory(const VARIANT& Format, const VARIANT& CurSelection);

returns a byte array (text data) casted like a VARIANT. I need to put this array in a CString variable. So I've used this:

COleVariant varBuffer;
COleVariant mode, cur;
mode = (long)5;
cur = (short)TRUE;
varBuffer = m_txctrl.SaveToMemory(mode, cur);
CString m_text = ((CByteArray &)(varBuffer.pbVal)).GetData();

But this will return an empty string. using CString m_text = (varBuffer.pbVal); return me a single byte.

It's wrong my code?

Re: Problems with data conversion

Hans Ruck4-Dec-02 0:50

Hans Ruck

4-Dec-02 0:50

Gian wrote:
returns a byte array (text data) casted like a VARIANT

Where exactly is that byte array? It can't be pbVal because this one is about one single byte... (check MSDN)

rechi

Re: Problems with data conversion

Gian4-Dec-02 3:02

Gian

4-Dec-02 3:02

i've solved calculating the dimension of the OleVariant and using memcpy to copy data in a CByteArray. now works Smile | :)

ODBC, SQL and MFC

MFC is the Best3-Dec-02 22:48

3-Dec-02 22:48

hello,

i have an mfc program and an access database. i connected them with odbc.
how can i make the following sql statement in my mfc programm?

select distinct xy from mytable

i want to read out 'xy' from a table 'mytable' and put these CString into a ComboBox:

Now i tried this:

<br />
CMyDatabase db;<br />
db.Open( CRecordset::dynaset,<br />
_T( "Select distinct xy from mytable" ) );<br />
<br />
db.MoveFirst();<br />
while(!db.IsEOF())<br />
{<br />
m_ctrlCombo.AddString(db.m_xy);<br />
db.MoveNext();<br />
}<br />
db.Close();<br />
UpdateData(false);<br />

i get the error, when i want to use this funktion. the error:

error with the call of a data record

what´s wrong????? Unsure | :~

thanks
mfc

Alexandru Savescu3-Dec-02 23:03

3-Dec-02 23:03

You need to follow these steps:

1. Open the database (using most likely a DSN, or a connection string).

2. Create a CRecordset object that uses the above open datastring.

3. Open the CRecordset object with a SQL query ("SELECT disintct...")

4. Once the recordset is open, iterate through recordset via MoveNext, MoveFirst etc.

Also, is wise to include everything in a try/catch block and you will most likely catch a pointer to CDBException object.

Best regards,
Alexandru Savescu

P.S. Interested in art? Visit this!

MFC is the Best3-Dec-02 23:59

3-Dec-02 23:59

thanks for reply.

i tried your idea:

	<br />
CMyDatabase db;<br />
db.Open();<br />
CRecordset rs (&db);<br />

but i get an error. must i include something (i included

#include "afxdb.h"
)?

thanks
mfc

Alexandru Savescu4-Dec-02 1:12

4-Dec-02 1:12

afxdb is a standard header, so you should use angle brackets:

#include <afxdb.h>

Best regards,
Alexandru Savescu

P.S. Interested in art? Visit this!

MFC is the Best4-Dec-02 1:20

4-Dec-02 1:20

yes, i use angle brackets (< >).....but it does not work.

why? can you help me????

the error is here

<br />
CRecordset rs(&db);<br />

the program has problems with &db

why?
mfc

Alexandru Savescu4-Dec-02 1:26

4-Dec-02 1:26

Please tell us what your error is. Apparently afxdb is enough standard to include.

Best regards,
Alexandru Savescu

P.S. Interested in art? Visit this!

MFC is the Best4-Dec-02 1:34

4-Dec-02 1:34

okay...first the code:

<br />
CMyDatabase db;<br />
db.Open();<br />
CRecordset rs (&db);<br />

the error:

'CRecordset::CRecordset':Conversion parameter 1 from 'class CMyDatabase *' in 'class CDatabase *' not possible.

what´s wrong?

thanks
mfc

Alexandru Savescu4-Dec-02 2:03

4-Dec-02 2:03

Here's what's going on:

1. It has nothing to do with any header file.

2. Why do you use a CMyDatabase object? Are you overriding some functionality of the CDatabase class?

3. If you are using a custom database object (CMyDatabase) make sure it is derived from CDatabase.

Voila!

Best regards,
Alexandru Savescu

P.S. Interested in art? Visit this!

MFC is the Best4-Dec-02 2:14

4-Dec-02 2:14

i understand. my database object is derived from CRecordset.

isn´t there a possiblity to make the sql statement:

select distinct xy from mytable

with a database object from CRecordset?
Because i ever use CRecordset.... Unsure | :~

thank you very much Rose | [Rose]

mfc

Alexandru Savescu4-Dec-02 3:10

4-Dec-02 3:10

No.

You are making a fundamental confustion. A database consists of tables and when you retrieve a record you read data from one/or more table(s) from the database.

MFC ODBC classes are: CDatabase that wrapps around a database and CRecordset the wrapps around a table (or more tables).

If you want to make a SELECT DISTINCT xy FROM MyTable you have to create a database object that opens the database MyTable table is in, then you create a CRecordset object that takes a pointer to a CDatabase and you pass the SQL statement to that CRecordset (or CRecordset-derived) object. Then you can navigate via MoveNext, MoveLast etc. through the database.

You can, however, execut SQL commands to the database objects. These are generally DELETE or INSERT statements (but not SELECT):

CDatabase db;
db.Open (...);
CString MyDelStr = _T ("DELETE FROM MyTable");
db.ExecuteSQL (MyDelStr);

CString MyInsertStr = _T ("INSERT INTO MyTable Values.....");
db.ExecuteSQL (MyInsertStr);

I hope I've been helpful!

Best regards,
Alexandru Savescu

P.S. Interested in art? Visit this!

MFC is the Best4-Dec-02 8:32

4-Dec-02 8:32

thank you very very much..... Rose | [Rose]

i tried your idea....

<br />
CDatabase db;<br />
db.Open(_T( "Datenbank" ), FALSE,FALSE, _T( "ODBC"));<br />
CRecordset rs(&db);<br />
rs.Open(CRecordset::forwardOnly ,"Select distinct xy from Mytable");<br />

i connectet access and vc++ with ODBC. the ODBC driver from my database i namend: 'Datenbank'.
in my database i have different tables and one is called xy.

in my code (above) must be a mistake....it doesnt work...why? Unsure | :~

how can i get the strings which i read out of my database table?

thank you.
mfc