C++ with Visual C++ 2008

[avvia]

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:

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!

[Katty]

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.

[avvia]

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.

[Reegan]

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]; 
/ / .. 
) 
) 
)