dizhi

来源：互联网发布：设计班服要用什么软件编辑：程序博客网时间：2024/05/01 12:05

231 http://www.google.com/cse?cx=partner-pub-4210569241504288%3Al5x48e2naex&ie=UTF-8&q=&sa=%E6%90%9C%E7%B4%A2&siteurl=www.cnblogs.com%2F

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;