datautilities.cs

来自「K-Means C++实现 带演示程序 K-Means C++实现 带演示程序」· CS 代码 · 共 64 行

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.OleDb;
using System.Data;
using System.Configuration;

namespace SimpleKMeans
{
    class DataUtilities
    {
        public static DataTable GetDataTable()
        {
            OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["KMeansSampleData"].ConnectionString);
            OleDbDataAdapter adapter = new OleDbDataAdapter(ConfigurationManager.ConnectionStrings["RetrieveData"].ConnectionString, conn);

            DataTable dt = new DataTable("Data");
            adapter.Fill(dt);

            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }

            return dt;
        }

        public static double FindMaxValue(DataTable dt, string fieldName)
        {
            double result = double.NegativeInfinity;
                        
            foreach (DataRow item in dt.Rows)
            {
                double tmp = Convert.ToDouble(item[fieldName]);
                if (tmp > result)
                {
                    result = tmp;
                }
            }

            return result;
        }

        public static double FindMinValue(DataTable dt, string fieldName)
        {
            double result = double.PositiveInfinity;

            foreach (DataRow item in dt.Rows)
            {
                double tmp = Convert.ToDouble(item[fieldName]);
                if (tmp < result)
                {
                    result = tmp;
                }
            }

            return result;
        }

        
    }
}