Dal/SQLHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Data.SqlClient;

/// <summary>
/// 文件名:SQLHelper.cs数据库帮助操作类
/// 文件功能描述:数据库帮助操作类
/// 版权所有:Copyright (C) liangjw
/// 创建标识:2013.08.02
/// 修改描述:
/// </summary>
namespace SqlInsert
{
    public class SQLHelper
    {

        public void SetCon(string connectionString)
        {
            _con = new SqlConnection(connectionString);
        }

        public SqlConnection _con;
        private SqlConnection Con
        {
            get { return _con; }
        }

        public bool TestCon(string connectionString)
        {
            SqlConnection tempcon = new SqlConnection(connectionString);
            try
            {
                tempcon.Open();
            }
            catch (Exception)
            {
                return false;
            }
            tempcon.Close();
            return true;
        }

        public DataTable GetDBSchema()
        {
            return GetDataList("sp_tables");
        }

        public DataTable GetDataList(string cmdStr)
        {
            DataTable tb = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter(cmdStr, Con);
            adapter.Fill(tb);
            return tb;
        }


        public DataTable GetDataSchema(string cmdStr)
        {
            DataTable tb = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter(cmdStr, Con);