• Dynamics AX Read OLEDB


    static System.Data.DataTable getOLEDB_Record(str _dbPath,str _query)
    {
        System.Data.OleDb.OleDbConnection   oleDbConnection;
        System.Data.OleDb.OleDbCommand      oleDbCommand;
        System.Data.OleDb.OleDbDataAdapter  oleDbAdapter;
        System.Data.DataSet                 dataSet;
        System.Data.DataTableCollection     dc;
        System.Data.DataTable               dt;
    
        str                                 connetionString;
        str         dbPath          = _dbPath;//= @"\192.168.0.41STARWATCH iTDC PRO IiTDC-ACS.mdb";
        str         strAccessSelect = _query;// "SELECT top 10 * FROM qryCardEventList" ;
        str         strFilter       = "";
        NoYes                               flag;
        container                           c;
        int         x,y;
        str         s;
        ;
        strAccessSelect += strFilter;
        connetionString = strfmt("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%1;",dbPath);
    
        try
        {
            oleDBconnection = new System.Data.OleDb.OleDbConnection(connetionString);
            oleDBcommand    = new System.Data.OleDb.OleDbCommand(strAccessSelect,oleDBconnection);
            dataSet         = new System.Data.DataSet();
            oleDbAdapter    = new System.Data.OleDb.OleDbDataAdapter(oleDbCommand);
    
            oleDBconnection.Open();
    //        info("Connection Open ! -OK");
            oleDbAdapter.Fill(dataSet,"dutyRecord");
            oleDBconnection.Close();
            oleDBconnection.Dispose();
            flag = true;
    //        info("Connection Closed ! -OK");
        }
        catch
        {
            if(!flag)
            {
                oleDBconnection.Close();
                oleDBconnection.Dispose();
            }
            throw error("Can not open connection ! ");
        }
        dc = dataSet.get_Tables();
        dt = dc.get_Item(0);
        return dt;
    }
    Flag Counter
  • 相关阅读:
    ado.net(增删改)
    窗体基础WINFORM
    SQL函数类的操作,增加,查询
    SQL数据库,增加查询修改以及防sql写入攻击
    SQL数据库--数据访问
    单列模式
    SQL数据库基础————委托
    SQL数据库基础知识——抽象类
    SQL数据库——静态成员
    面向对象
  • 原文地址:https://www.cnblogs.com/sunsoftware/p/4288005.html
Copyright © 2020-2023  润新知