连接数据库的方法

private static string constr = “连接字符串”
private static void DB()
{
//如果连接对象关闭，则打开连接
if (Conn.State == ConnectionState.Closed)
Conn.Open();
}

    public static DataTable GetDataTable(string sql)
    {
        DB();
        DataTable dt = new DataTable();
        MySqlDataAdapter mysqlsataAdapter = new MySqlDataAdapter(sql, Conn);
        mysqlsataAdapter .Fill(dt);
        return dt;
    }
    public static bool ExecuteNonQuery(string sql)
    {
        DB();
        MySqlCommand mysqlcommand = new MySqlCommand(sql, Conn);
        int result = mysqlcommand.ExecuteNonQuery();
        return result > 0;
    }



}