StaticSystem.Data.DataTable Getoledb_record (str _dbpath,str _query) {System.Data.OleDb.OleDbConnection oledbconnectio N 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.41\STARWATCH itdc PRO i\itdc-acs.mdb";str straccessselect = _query;//"SELECT Top ten * from Qrycardeventlist";str strfilter =""; NoYes Flag; Container C; intx, y; STR s; ; Straccessselect+=strfilter; Connetionstring= Strfmt ("Provider=Microsoft.Jet.OLEDB.4.0;Data source=%1;", DbPath); Try{OleDbConnection=NewSystem.Data.OleDb.OleDbConnection (connetionstring); OleDbCommand=NewSystem.Data.OleDb.OleDbCommand (straccessselect,oledbconnection); DataSet=NewSystem.Data.DataSet (); OLEDBAdapter=NewSystem.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 (); } ThrowError"Can not open connection!"); } DC=Dataset.get_tables (); DT= Dc.get_item (0); returnDT;}
Dynamics AX Read OLE DB