Unity编写Sql语句

最新推荐文章于 2020-02-15 17:37:06 发布

Unity刘文凯

最新推荐文章于 2020-02-15 17:37:06 发布

阅读量490

点赞数

分类专栏：记录自己碰到的问题文章标签： c# unity unity3d

本文链接：https://blog.csdn.net/LWKlwk11/article/details/90210412

版权

记录自己碰到的问题专栏收录该内容

22 篇文章 1 订阅

订阅专栏

C#编写Sql

using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using MySql.Data.MySqlClient;
using System.Configuration;
using System.Data.Common;
using System.Collections.Generic;
/// <summary>
/// 执行查询语句，返回DataSet
/// </summary>
/// <param name="SQLString">查询语句</param>
/// <returns>DataSet</returns>
public static DataSet Query(string SQLString)
{
  string connectionString = "server=localhost 代表本机;database=数据库的名字;uid=root;pwd=;Charset=utf8";
  using (MySqlConnection connection = new MySqlConnection(connectionString))
  {
	DataSet ds = new DataSet();
	try
	{
                connection.Open();
                MySqlDataAdapter command = new MySqlDataAdapter(SQLString, connection);
                //command .Tables.Add("ds");
                command.Fill(ds, "ds");
        }
        catch (MySql.Data.MySqlClient.MySqlException ex)
        {
		throw new Exception(ex.Message);
	}
	return ds;
  }
}