Tuesday, March 26, 2013

W7 No se puede tener acceso ( recurso compartido )

Ademas de compartir el recurso y agregar los permisos se requiere lo sgte:
 
1) Centro de Redes y recursos compartidos 
  1.1) Cambiar configuración de uso compartido avanzado,       
    1.1.1) Casa o trabajo (perfil actual)
           Dentro en la opción Uso compartido con protección de contraseña
           Activar la opción Desactivar el uso compartido con protección con contraseña.
 
 
 

Friday, March 22, 2013

ApexPage - Button Edit and Delete with Refresh



Reference
[1] http://salesforcesource.blogspot.com/2009/09/edit-and-delete-command-for-your.html

ApexPage dataTable



 
<apex:dataTable value="{!myCollection}" var="item">
  <apex:column >  <apex:outputField value="{!item.field1__c}"/>  </apex:column>
  <apex:column >  <apex:outputField value="{!item.field2__c}"/>  </apex:column>
  <apex:column >  <apex:outputField value="{!item.field3__c}"/>  </apex:column> 
</apex:dataTable>      
      
      


References:
[1] http://blog.jeffdouglas.com/2010/04/02/visualforce-row-counter-for-iteration-components/

Wednesday, March 13, 2013

Visual Studio 6.0 Over W7

 - Copy setup/vs98ent.stf  /acmsetup.stf- Copy setup/* to /- Execute /acmsetup.exe 
Note: The file vs98ent.stf or vs98pro.stf


Install Service Pack 6 de VS6.0

Change vb98pro.stf or vs98ent.stf  to acmsetup.stf
Execute acmsetup.exe for start installation
 Other tip (Aboout Java)  Install the Sun Java VM (Well Oracle now)
Edit the file Setupwiz.ini, and change the line

VmPath=ie4\msjavx86.exe
to (in my case)
VmPath="C:\Program Files\Java\jre6\bin\java.exe"
 
 

VS2008 over W7 Error: gencomp320

Method 1:

That problem is because InfoPath Component of Office 2007. Then you need remove that.


over   Start/Run type:

msiexec /x {30120000-0044-0C0A-0000-0000000FF1CE}


Method 2:
1. Go to the Add/Remove Programs control panel by clicking on the Start menu, choosing Run, typing appwiz.cpl and clicking OK
2. Locate the item named Microsoft Visual Studio Web Authoring Component and choose to uninstall it
3. Try to run VS 2008 setup again

Thursday, March 07, 2013

C# Read/Write INI Files

[DllImport("kernel32")]
private static extern long WritePrivateProfileString(string section,string key,string val,string filePath); 
 
[DllImport("kernel32")]
private static extern int GetPrivateProfileString(string section,string key,string def, StringBuilder retVal, int size,string filePath);
 
References
[1] http://www.codeproject.com/Articles/1966/An-INI-file-handling-class-using-C
[2] http://jachman.wordpress.com/2006/09/11/how-to-access-ini-files-in-c-net/
[3] http://code.google.com/p/ini-parser/

C# Export to Excel



References:
[1] EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx). http://epplus.codeplex.com/
[2] C# Class for Export DataTable To Excel with Interop http://alandjackson.wordpress.com/2011/01/07/c-export-to-excel-with-interop/
[3] Version of POI Java project at http://poi.apache.org/. POI is an open source project which can help you read/write xls, doc, ppt files. http://npoi.codeplex.com/releases
[4] Sample of NPOI http://www.leniel.net/2009/07/creating-excel-spreadsheets-xls-xlsx-c.html#sthash.5qgu3AiY.dpbs
[5] Good sample for export to excel file http://www.codeproject.com/Articles/20228/Using-C-to-Create-an-Excel-Document

mySQL Store procedures


CREATE DEFINER = 'root'@'%' PROCEDURE `queryf2`(
        IN id varchar(8)
    )
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN 
   START TRANSACTION; 
   SELECT * FROM PRODUCTOS_STOCK ps where ps.IdSucursal=id; 
   COMMIT; 
END;

references:


[1] Stored Procedure that returns random rows from a table
      http://www.it-iss.com/mysql/mysql-stored-procedure-that-returns-random-rows-from-a-table/

Firefox open multiple private window

    /opt/firefox/firefox-bin --profile $(mktemp -d) --private-window www.google.com www.bing.com