c++ mysql++ WinMain windows programming

here's a snippet of the code I'm having trouble with:

Code:

---

        case IDC_GET:
                                        MYSQL *pConnection;
                                        MYSQL_RES *pResult;  //pointer to the result set structure
                                        MYSQL_ROW Row;
                                        pConnection = mysql_init(NULL);
                                        SendDlgItemMessage(hwnd, IDC_LIST, LB_ADDSTRING, 0, (LPARAM)TEXT("Attempting to Connect to"));
                                        SendDlgItemMessage(hwnd, IDC_LIST, LB_ADDSTRING, 0, (LPARAM)TEXT("Database......."));
                                        mysql_real_connect(pConnection, "localhost","alakazam","tripletkingsburg","tripletadmin",0,NULL,0);
                                    SendDlgItemMessage(hwnd, IDC_LIST, LB_ADDSTRING, 0, (LPARAM)TEXT("Connected!"));
                                        mysql_query(pConnection,"SELECT * FROM products"); //query the database
                                        pResult = mysql_store_result(pConnection);
                                        printf("\n\nThe Number Of products in the database: %d\n\n",mysql_num_rows(pResult));
                                        SendDlgItemMessage(hwnd, IDC_LIST, LB_ADDSTRING, 0, (LPARAM)printf("%d",mysql_num_rows(pResult)));
                                        mysql_free_result(pResult);
                                break;

---

This line is my real problem:

SendDlgItemMessage(hwnd, IDC_LIST, LB_ADDSTRING, 0, (LPARAM)printf("%d",mysql_num_rows(pResult)));


how do I print my results out to the IDC_LIST??

Anybody who has done this please help.


and remember that this is for gui interface not a dos console. I know how to do it in a dos console.

Make a text buffer, use wsprintf instead of printf and use it outside SendDlgItemMessage function, and then pass the address of this buffer. Isn't it easy?

I'm pretty new at this stuff, would it be possible to give me an example?


:(

TCHAR szBuffer[50];

wsprintf (szBuffer, TEXT ("%d"), mysql_num_rows (pResult));

SendDlgItemMessage (hwnd, IDC_LIST, LB_ADDSTRING, 0, (LPARAM) szBuffer);

This would work perhaps.

I love you guys!!!

Thanks alot

golem, is your name supposed to be the character in lord of the rings? I could be wrong but isn't it spelled "gollum" or something like that?

No, it's an historical monster made from clay by a jew rabbi which name I haven't remembered. I haven't seen that film.

LOL!

I don't know if that was a joke or not but it was funny as hell. Haven't seen lord of the rings? It's pretty good. Worth your time. I was kinda referring to the books though.

Among many films I've seen lately was Matrix and I thought
I understood it. But what this topic has to do with general C++ ?
;)

the original post belongs in the windows forum, our discussion belongs in General Discussion forum. I don't care if you don't