asdfdgdfghjkjkjhhfgg
DataTable ^dt = gcnew DataTable();
dt->Columns->Add("OID");
dt->Columns->Add("CheckDate");
MYSQL mysql; //数据库连接句柄
mysql_init (&mysql);
if(!mysql_real_connect(&mysql,HostName,UserName,Password,DataBase,Port,NULL,0))
{
throw gcnew Exception("数据库连接失败");
//Windows::Forms::MessageBox::Show("数据库连接失败");
}
mysql_query(&mysql, "SET NAMES 'gb2312'");//加上这句就好了
if(mysql_real_query(&mysql,strQuery,(UINT)strlen(strQuery))!=0)
{
throw gcnew Exception("数据库表格出错");
}
MYSQL_RES *result;
MYSQL_ROW row;
if(!(result=mysql_store_result(&mysql)))
{
throw gcnew Exception("读取数据集失败");
}
unsigned int num_fields;
unsigned int i;
MYSQL_FIELD *fields;
num_fields = mysql_num_fields(result);
fields = mysql_fetch_fields(result);
for(i = 0; i < num_fields; i++)
{
fields[i].name;
}
while(row=mysql_fetch_row(result))
{
dt->Rows->Add(dt->NewRow());
dt->Rows[0][0] = gcnew String(row[0]);
dt->Rows[0][1] = gcnew String(row[1]);
}
mysql_free_result(result);//释放结果集
mysql_close(&mysql);//释放数据库连接
return dt;