cdatabaseops.cs

实现简单个人数据库系统

using System;
using System.Text;
using System.Data;
using System.Resources;
using System.Data.SqlClient;
using System.Collections;
using System.Collections.Generic;


namespace QueryTool_V1
{
    public class CDataBaseOps
    {
        string connString;
        string selectCommand;
        string queryCommand;
        string updateCommand;
        SqlConnection conn;
        SqlDataAdapter da;

        public CDataBaseOps()
        {
            connString = Properties.Settings.Default.MyCompanyConnectionString;
            selectCommand = string.Empty;
            queryCommand = string.Empty;
            updateCommand = string.Empty;
            da = null;
            conn = null;
        }
        public Dictionary<string, Type> GetColumnNamesTypes(DataTable dt)
        {
            Dictionary<string, Type> columnNameTypes = new Dictionary<string, Type>();
            foreach (DataColumn c in dt.Columns)
            {
                columnNameTypes.Add(c.ColumnName, c.DataType);
            }
            return columnNameTypes;
        }

        public ArrayList GetValuesforColumn(string columnNameString, DataTable dt)
        {
            // DataRow[] SortedRows = dt.Select(columnNameString);
            ArrayList columnValues = new ArrayList();
            foreach (DataRow selectedRow in dt.Rows)
            {
                columnValues.Add(selectedRow[columnNameString]);
            }
            return columnValues;
        }
        public DataTable ExecuteQuery(string queryCommand)
        {
            DataTable resultDataTable = new DataTable();
            da = new SqlDataAdapter(queryCommand, connString);
            SqlCommandBuilder cmdBldr = new SqlCommandBuilder(da);
            da.Fill(resultDataTable);
            return resultDataTable;
        }
    }
}