C++ with Visual C++ 2008

I went back to C + + with Visual C + + 2008 Express to develop a small program ... i have a concern about the display of a result of a mysql query:

Code:

---

if (! mysql_real_connect (mySQL, "localhost", "root ",""," stock, 0, NULL, 0))
(
textBox1-> Text = "error";
)
else
(
if (! mysql_query (mysql, "SELECT * FROM suppliers WHERE id = 2"))
(
result = mysql_store_result (mySQL);
textBox2-> Text = System:: Convert:: ToString (mysql_num_fields (result));
while (column = mysql_fetch_row (result))
(
textBox1-> Text = System:: Convert:: ToString (column [1]);
)
mysql_free_result (result);
)
else
(
textBox1-> Text = "no result";
)
)
mysql_close (mysql);

---

When I run the program, I can see "True" in the textBox1 instead of the value that is in my database ... Which appears in the textBox2 is correct. Thank you for your help!

It's not C + + is C + + / CLI And column [x] is a memory pointer, so it will be difficult to guess how to convert Otherwise you'd better to use mysql + +, it's much more convenient.

if we explain how to use mysql + + with Visual C + + 2008 Express because I can not ... I am on Win XP, I installed mysql 5.1 and I have mysql + + 3.0.9.

Code:

---

mysqlpp:: Connection connection (false);
if (connection.connect ( "stock", "localhost", "root", ""))
(
mysqlpp:: StoreQueryResult result;
mysqlpp:: Query query;
int id = 2;
query << "SELECT a, b, c FROM suppliers WHERE id =% 0q";
q.parse ();
result = q.store (id);
if (result)
(
for (mysqlpp:: StoreQueryResult:: iterator it = result.begin (); it! result.end = (); + + it)
(
mysqlpp:: Row & row = const * it;
std:: string a = row [0];
float b = row [1];
int c = row [2];
/ / ..
)
)
)

---