woshiliulidiyi 发表于 2013-2-5 02:14:26

C#操作SAS

using System;
http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System.Collections.Generic;
http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System.Linq;
http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System.Text;
http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing SASWorkspaceManager;
http://www.cnblogs.com/Images/OutliningIndicators/None.gif
http://www.cnblogs.com/Images/OutliningIndicators/None.gifnamespace SASShare
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif{
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif    public class Connection
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif    {
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        /// <summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// 默认创建本地连接
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        /// </summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public Connection()
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            : this(null, 0, "", "", Protocols.ProtocolBridge)
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {}
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public Connection(string serverIP, short serverPort, string userName, string userPass, Protocols protocols)
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            this._serverIP = serverIP;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            this._serverPort = serverPort;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            this._userName = userName;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            this._userPassword = userPass;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            this._protocals = protocols;
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        private string _serverIP = string.Empty, _userName = string.Empty, _userPassword = string.Empty;
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        /// <summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// 用户密码
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        /// </summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public string UserPassword
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            get { return _userPassword; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            set { _userPassword = value; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        /// <summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// 用户名
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        /// </summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public string UserName
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            get { return _userName; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            set { _userName = value; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        /// <summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// 服务器地址
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        /// </summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public string ServerIP
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            get { return _serverIP; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            set { _serverIP = value; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        private short _serverPort;
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        /// <summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// 连接端口号
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        /// </summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public short ServerPort
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            get { return _serverPort; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            set { _serverPort = value; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        private Protocols _protocals;
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        /// <summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// 连接协议
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        /// </summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public Protocols Protocals
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            get { return _protocals; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            set { _protocals = value; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public SASProvider CreateSASProvider()
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            return new SASProvider(this);
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif    }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif}
http://www.cnblogs.com/Images/OutliningIndicators/None.gif
 
 

http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System;
http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System.Collections.Generic;
http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System.Linq;
http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System.Text;
http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing SASWorkspaceManager;
http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing SAS;
http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System.IO;
http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System.Data.OleDb;
http://www.cnblogs.com/Images/OutliningIndicators/None.gif
http://www.cnblogs.com/Images/OutliningIndicators/None.gifnamespace SASShare
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif{
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif    public class SASProvider
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif    {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        private IWorkspace workSpace;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public IWorkspace WorkSpace
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            get { return workSpace; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            set { workSpace = value; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        private Connection _connection;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public Connection Connection
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            get { return _connection; }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        string message;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        WorkspaceManager _workspaceManager = new SASWorkspaceManager.WorkspaceManager();
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public delegate void SASErrorEventHandler(object sender, SASErrorEventArgs args);
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        /// <summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// 执行出错事件
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        /// </summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public event SASErrorEventHandler OnError;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        internal SASProvider(Connection connection)
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            _connection = connection;
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        /// <summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// 运行SAS程序
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// </summary>
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        /// <param name="sasCommand"></param>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public void Submit(string sasCommand)
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            IServerDef2 _serverDef = null;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            if (!string.IsNullOrEmpty(_connection.ServerIP))
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                _serverDef = new SASWorkspaceManager.ServerDefClass();
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                _serverDef.Port = Connection.ServerPort;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                _serverDef.Protocol = Connection.Protocals;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                _serverDef.MachineDNSName = Connection.ServerIP;
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            workSpace = _workspaceManager.Workspaces.CreateWorkspaceByServer("_LOCAL_", SASWorkspaceManager.Visibility.VisibilityProcess, _serverDef, _connection.UserName, _connection.UserPassword, out message);
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            try
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                workSpace.LanguageService.Submit(sasCommand);
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            catch (Exception e)
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                FireEvent(this, e);
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            finally
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                workSpace.Close();
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        /// <summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// 运行SAS文件
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// </summary>
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        /// <param name="path"></param>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public void RunSasFile(string path)
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            if (File.Exists(path))
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                string command = File.ReadAllText(path);
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                Submit(command);
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        /// <summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// 查询结果集
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// </summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// <param name="libname">分配逻辑库引用名</param>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// <param name="command"></param>
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        /// <returns></returns>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public System.Data.DataSet GetResults(string libname, string command)
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            System.Data.DataSet ds = new System.Data.DataSet();
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            OleDbConnection conn = getConnection();
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            OleDbCommand cmd = new OleDbCommand(libname, conn);
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            OleDbDataAdapter da = new OleDbDataAdapter(command, conn);
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            try
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                conn.Open();
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                cmd.ExecuteNonQuery();
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                da.Fill(ds);
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            catch (Exception e)
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                FireEvent(this, e);
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            finally
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                conn.Close();
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            return ds;
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        /// <summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// 查询单个结果
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// </summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// <param name="libname">分配逻辑库引用名</param>
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        /// <returns></returns>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public object GetResult(string libname, string selectCommand)
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            object result = null;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            OleDbConnection conn = getConnection();
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            OleDbCommand cmd = new OleDbCommand(libname, conn);
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            try
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                conn.Open();
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                cmd.ExecuteNonQuery();
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                cmd.CommandText = selectCommand;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                result = cmd.ExecuteScalar();
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            catch (Exception e)
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                FireEvent(this, e);
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            finally
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                conn.Close();
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            return result;
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        /// <summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// 执行增删改操作
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// </summary>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// <param name="libname">分配逻辑库引用名</param>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        /// <param name="command"></param>
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        /// <returns></returns>
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public int Execute(string libname, string command)
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            int result = 0;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            OleDbConnection conn = getConnection();
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            OleDbCommand cmd = new OleDbCommand(libname, conn);
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            try
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                conn.Open();
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                cmd.ExecuteNonQuery();
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                cmd.CommandText = command;
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                result = cmd.ExecuteNonQuery();
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            catch (Exception e)
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                FireEvent(this, e);
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            finally
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif            {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif                conn.Close();
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif            }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            return result;
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        private OleDbConnection getConnection()
http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif        {
http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            string<span style
页: [1]
查看完整版本: C#操作SAS