private static bool FindLasestVersionForTable(string sPartNumber, string sTableName, ref string sVersion) { string sConn = @"Data Source=\\BOA\Production\Prodman.vfp\DATABASE\" + sTableName + ".dbf;" + @"Provider=VFPOLEDB.1;"; string sFormattedPartNum = AmcDataConnection.QUOTE + sPartNumber + AmcDataConnection.QUOTE; AmcDataConnection vfpTempConn = new AmcDataConnection() { DataBaseType = (int)dbType.vfp, TableName = sTableName, ConnectionString = sConn }; if (vfpTempConn.ConnectToDatabase()) { string sSelectSql = "select top 1 partnumber, version from " + vfpTempConn.TableName + " where Partnumber" + " = " + sFormattedPartNum + " ORDER BY version descending"; OleDbCommand cmdSelect = new OleDbCommand(sSelectSql, vfpTempConn.GetOleConn()); OleDbDataReader rdr = cmdSelect.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); sVersion = rdr["version"].ToString(); return(true); } } return(false); }
public bool InitializeDatabase() { if (String.IsNullOrWhiteSpace(KeyIdentifier)) { return(false); } _dbConn = new AmcDataConnection() { ConnectionString = ConnectionString, TableName = TableName, DataBaseType = DataBaseType, KeyIdentifier = KeyIdentifier, KeyValue = KeyValue, WhereClause = GetWhereSQL() }; //_dbConn.WhereClause = GetWhereSQL() + AddVersionToWhere(); // ja - connect to a table if (!_dbConn.ConnectToDatabase()) { return(false); } AddColumns(); if (_ColumnNames.Count > 0) { Found = _dbConn.FillTable(_ColumnNames); } else { Found = _dbConn.FillTable(); } return(true); }