Browse by Tags
All Tags »
VSTO »
Access 2007 (
RSS)
Nesta série de vamos compreender como criar, gerir e implementar um Biblioteca (Class Library) para o Microsoft Access. Vamos utilizar o Visual Studio 2008, C#, Visual Basic e o Microsoft Access 2007. Estes exemplos provêm da Class Library...
static ADOX.DataTypeEnum GetAccessFormats(DataColumn col) { switch (col.DataType.Name) { case "Boolean" : return ADOX.DataTypeEnum.adBoolean; case "Byte" : return ADOX.DataTypeEnum.adUnsignedTinyInt; case "Char" : return...
public string ConvertFieldToUpper( string MyTable, string MyField) { Access.Application oAccess = ((Access.Application) (Marshal.GetActiveObject( "Access.Application" ))); try { string strSQL; strSQL = String.Format( "UPDATE {0} SET {1...
/// <summary> /// /// </summary> /// <param name="hideNavigationPane"></param> /// <param name="myUIName"></param> /// <param name="myUIXML"></param> /// <returns>True...
public bool ConvertReportToXPS( string myReport, string XPSFileName) { Access.Application oAccess = ((Access.Application) (Marshal.GetActiveObject( "Access.Application" ))); try { oAccess.DoCmd.OutputTo(Access.AcOutputObjectType.acOutputReport...
public bool TablesAreEqual( string MyTableSource, string MyTableToCompare, string MyIndexField) { try { OleDbConnection cnn; using (DataSet ds = new DataSet()) { OleDbDataAdapter da; string cs = oAccess.CurrentProject.Connection.ToString(); string strSQL...
Access.Application oAccess = ((Access.Application) (Marshal.GetActiveObject("Access.Application"))); // ---------------------------------------------...
public bool ExecuteSqlFromFile(String MyConnectionString, String MyTextFilePath) { using (OleDbConnection sqlConnection = new OleDbConnection(MyConnectionString)) { OleDbCommand cmd = new OleDbCommand(); try { using (StreamReader fh = new StreamReader...
/// <summary> /// /// </summary> /// <param name="MyPath"></param> /// <returns>True/False</returns> public bool GenerateLogDatabase( string myPath) { CatalogClass cat = new CatalogClass(); string strSQL;...