Vc++ 2005 With Mysql..............please Help

using namespace System;
using namespace System::ComponentModel;
using namespace System::Collections;
using namespace System::Windows::Forms;
using namespace System::Data;
using namespace System::Drawing;
using namespace MySql::Data::MySqlClient;
using namespace SDT100ATest;



String ^strConnection ="server=localhost; user id=root; password=mysql; database= test;";
MySqlConnection ^conSQL = gcnew MySqlConnection(strConnection);
conSQL->Open();

String ^SQL = "";

//Build SQL querry
SQL = "Insert into User " +
" (name, surname, password, userName, " +
" ID, userStatus,userType) "+
"Values (?name, ?surname, ?password, ?userName, " +
" ?idNumber, ?userStatus, ?userType); "+
"Select @@Identity";

MySqlCommand ^cmd = gcnew MySqlCommand(SQL,conSQL);

cmd->CommandText = SQL;
//Add and Assign parameters declared in SQL string above to MySqlCommand (cmd)
cmd->Parameters->Add("?name",name);
cmd->Parameters->Add("?surname",surName);
cmd->Parameters->Add("?userName", userName);
cmd->Parameters->Add("?password", password);
cmd->Parameters->Add("?idNumber", ID);
cmd->Parameters->Add("?userStatus", userStatus);
cmd->Parameters->Add("?userType", userType);

cmd->ExecuteNonQuery();
conSQL->Close();