sql.cs

在线考试系统

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


namespace Test.GlobalLibrary
{
    public class sql
    {
        string m_stSqlConnectString = null;
        SqlCommand comm;
        SqlConnection conn;
        SqlDataAdapter adapter;
        DataSet ds = new DataSet();
        SqlParameter param = new SqlParameter();
         public  sql() 
         {
             this.m_stSqlConnectString = ConfigurationSettings.AppSettings["SqlConnectString"].ToString();
             conn = new SqlConnection(m_stSqlConnectString);
         }

        public DataSet Select(string sel, string table)
        {
            adapter = new SqlDataAdapter(sel, conn);
            adapter.Fill(ds, table);
            return ds;
        }

         public void InDeMo(string Str) 
         {

             conn.Open();
             comm = conn.CreateCommand();
             comm.Connection = conn;
             comm.CommandText = Str;
             comm.ExecuteNonQuery();
             conn.Close();
         }

        public bool Validate(string Str, string Table)
        {
            ds = Select(Str, Table);
            if (ds.Tables[0].Rows.Count == 0)
                return true;
            else
                return false;
        }


    }
}