/// <summary>
/// 得到Access列的描述
/// </summary>
/// <param name="TableName">表名</param>
/// <param name="ColumnName">列名</param>
public static string GetColumnDescription(string TableName, string ColumnName)
{
//Caption
//ColumnHidden
//ColumnOrder
//ColumnWidth
//DecimalPlaces
//Description
//Format
//InputMask
const int dbUseJet = 2;
String dbName = System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["DbPath"].ToString());
DAO.Workspace DAOWorkspace;
DAO.Database DAODatabase;
DAO.DBEngine DAODBEngine = new DAO.DBEngine();
// 创建一个工作区
DAOWorkspace = DAODBEngine.CreateWorkspace(" WorkSpace ", "admin", null, dbUseJet);
// 打开数据库
DAODatabase = DAOWorkspace.OpenDatabase(dbName, false, false, null);
DAO.TableDef DAOTable;
DAO.Field DAOField;
// 表对象
DAOTable = DAODatabase.TableDefs[TableName];
DAOField = DAOTable.Fields[ColumnName];
return(DAOField.Properties["Description"].Value.ToString());
}
static void Main(string[] args)
{
DAO.DBEngine dbEng = new DAO.DBEngine();
DAO.Workspace ws = dbEng.CreateWorkspace("", "admin", "", DAO.WorkspaceTypeEnum.dbUseJet);
DAO.Database db = ws.OpenDatabase("z:\\docs\\dbfrom.mdb", false, false, "");
DAO.TableDef tdf = db.TableDefs["Test"];
DAO.Field fld = tdf.Fields["AYesNo"];
//dbInteger 3
//accheckbox 106
DAO.Property prp = fld.CreateProperty("DisplayControl", 3, 106);
fld.Properties.Append(prp);
}
