实现Access/Sql/Oracle数据类型切换三步曲(三)

操作Sqlserver数据类型类

代码如下：

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


namespace  ELsqlconn
... {
    /**//// 

    /// ELSQLSERVER 的摘要说明。
    /// 
    public class ELSQLSERVER
    ...{
        public SqlConnection ELSqlserverconn; 
        public String strconn= ConfigurationSettings.AppSettings["ELSqlserver"];
        
        public void SqlserverOpen()
        ...{
            ELSqlserverconn=new SqlConnection(strconn);
            ELSqlserverconn.Open();
        
        }
        public void SqlserverClose()
        ...{
            ELSqlserverconn.Close();
        }
        
        public DataSet ELDataSet(string StrSql,string StrName)
        ...{
            SqlserverOpen();
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(StrSql,ELSqlserverconn);
            da.Fill(ds,StrName);
            SqlserverClose();
            return ds;
        }
        
        public void ELExecuteNonQuery(string StrSql)
        ...{
            SqlCommand Cmd = new SqlCommand(StrSql,ELSqlserverconn);
            SqlserverOpen();
            Cmd.ExecuteNonQuery();
            SqlserverClose();
            
        }
        
        public void ELExecuteScalar(string StrSql)
        ...{
            SqlCommand Cmd = new SqlCommand(StrSql,ELSqlserverconn);
            SqlserverOpen();
            Cmd.ExecuteScalar();
            SqlserverClose();
        }
            
        
        

    }
}