Creating .XLS and .XLSX with C#

Code samples:
Visual Studio 2008 C# ASP.NET MVC Web Application
http://sites.google.com/site/leniel/blog/ExcelWriterMvcProject.zip

References:
ExcelPackage: Office Open XML Format file creation
http://excelpackage.codeplex.com/

ExcelPackage binaries download
http://excelpackage.codeplex.com/Release/ProjectReleases.aspx

NPOI
http://npoi.codeplex.com/

Manual del Conductor

http://www.drtcsanmartin.gob.pe/documentos/manual_conductor/

http://www.mtc.gob.pe/portal/normas_transito/BALOTARIO.pdf

http://www.touringperu.com.pe/info/codigo_transito/balotario.pdf


Accidente Rey latino Bateas Caylloma
https://www.hbanoticias.com/arequipa-volcadura-de-bus-rey-latino-deja-un-fallecido-y-29-heridos-en-caylloma-relacion-de-heridos/

Windows::Problemas con 4 GB o más de memoria

http://multingles.net/docs/jmt/4gbmem.htm

CSS:: Best logins

http://www.smashingmagazine.com/2006/12/19/50-beautiful-css-based-web-designs-in-2006/

ASP.NET::Error de la validación del estado de vista MAC.

Agregar en el archivo web.config lo siguiente:

<pages enableviewstatemac="false">

Funny Videos #2

http://video.latam.msn.com/watch/video/duelo-entre-gato-y-perro/1jbalfh8x

http://video.latam.msn.com/watch/video/increible-bailarin-callejero-en-paris/1jboh78n4

Bakup SQL Server 2008 to SQL Server 2005

http://www.hyper-v-mart.com/HowTo/Convert_SQL_Server_2008_to_SQL_Server_2005.aspx

Resources:
[1]Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB)
http://go.microsoft.com/fwlink/?LinkId=65111

Music using Spotify

http://www.spotify.com/download/?autodl

Power Builder::Tips

DropDown ListBox
http://kell-developer.blogspot.com/2009/09/cargar-una-tabla-un-dropdownlistbox-de.html


Clear datawindow
long ll_i, ll_rc

ll_rc = dw_1.RowCount()

for ll_i = 1 to ll_rc
dw_1.deleterow(1)
next

dw_1.AcceptText()
dw_1.Update(True, True)

--or--

dw_1.Reset() //will never delete the rows from DB, It will just clear the datawindow buffers.


Work with dates
========================================================
dt_today = today()
li_maand = month(dt_today )
li_jaar = year(dt_today )
li_dag = day(dt_today )


apply filter
========================================================
ls_filtro = "columna1 > 100 and columna2 > 30"

dw_1.SetFilter(ls_filtro)

dw_1.Filter( )




references
[0] http://powerbuilder-undiaalavez.blogspot.com/

[1] Tutorial Power Builder 9.0 http://edyovando.galeon.com/INICIO.HTML
[2] Trucos datawin
http://infolenguajes.galeon.com/datawin.htm
[3] http://kell-developer.blogspot.com/2009/09/cargar-una-tabla-un-dropdownlistbox-de.html

[4] List of Functions Available in Datawindow Expressions
http://pbbraindump.wordpress.com/2008/05/15/list-of-functions-available-in-datawindow-expressions/
[5] http://solocodigofuente.com/ejemplos-de-codigo-fuente-en-visual-basic-net/uso-del-control-dropdownlistbox-listbox-listview-de-power-builder/
[6] http://powerbuilder-undiaalavez.blogspot.com/2011_02_01_archive.html

http://ingpcastillo.com/personal/Manual/MANUAL_DE_POWER_BUILDER.pdf
http://sergioor.blogspot.com/2008/02/funciones-principales-de-un-datawindows.html
http://www.todoexpertos.com/categorias/tecnologia-e-internet/programacion/power-builder/respuestas/2317534/datawindows-avanzado



http://sergioor.blogspot.com/2008/02/funciones-principales-de-un-datawindows.html

http://es.scribd.com/doc/6878574/Powerbuilderuso-de-Cursores
http://groups.google.com/group/sybase.public.powerbuilder.database/browse_thread/thread/159c2bf7ef4f114e?pli=1

SQL Server::Collation

referencias:
http://www.portalfox.com/index.php?name=News&file=article&sid=477&mode=nested&order=0&thold=0

http://www.guillesql.es/Articulos/SQLServerFAQ_Intercalacion_Cambiar_Collation.aspx

http://blog.sqlauthority.com/2007/06/11/sql-server-cannot-resolve-collation-conflict-for-equal-to-operation/

SQL Server::Identificar versión y edición

Cómo determinar la versión de SQL Server
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

SELECT @@VERSION

LINQ Samples

http://msdn.microsoft.com/en-us/vcsharp/aa336746

Obtener operador al cual pertenece el número telefónico (fijo)

Obtener operador al cual pertenece el número telefónico (fijo)

Lima
http://www.mtc.gob.pe/portal/comunicacion/concesion/registros/numeracion/fija/lima.pdf

Provincias
http://www.mtc.gob.pe/portal/comunicacion/concesion/registros/numeracion/fija/prov.pdf

Obtener cantidad de numeros por DNI (Claro moviles)
http://www.claro.com.pe/wps/portal/pe/pc/hogar/movil/prepago

TV Satelital codecs

http://www.jomaxtel.com/descargas.php

php photo gallery::without database

http://phpgraphy.sourceforge.net/
http://www.sgal.org/
http://sourceforge.net/projects/ifoto/
http://yapig.sourceforge.net/
http://qdig.sourceforge.net/

Distancia de Arequipa a otros lugares

http://www.lacasademargott.com/es/arequipa-distancias.htm

Remove Administrator Password on Windows (Remover contraseña de Administrador)

References:

[1] Use Linux to remove https://opensource.com/article/18/3/how-reset-windows-password-linux

[2] Others

http://www.yoreparo.com/nav/?url=http://www.juque.cl/weblog/2005/10/23/win-xp-cambiarborrar-contraseaa-del-administrador.html 

http://www.howtogeek.com/howto/windows-vista/reset-your-forgotten-password-the-easy-way-using-the-ultimate-boot-cd-for-windows/ 

http://www.techrena.net/computers/reset-windows-xp-vista-7-password-usb-pen-drive-cd/  

http://techrena.blogspot.com/2009/03/windows-password-recoverycrack-windows.html

Html Resources

Menues, Slides

http://www.htmldrive.net/categorys/show/2/Slideshow-Scroller

C.C. Catch::You Shot A Hole In My Soul

He's a midnight dream romancer
He's the only lonely dancer
Oh, only love breaks my heart
He's the nearest thing to heaven
Stole my heart and tried to say then
Oh, only love breaks my heart

You shot a hole in my soul
It's the kind out of love I know
You shot a hole in my soul
Hold on tight, don't let go
You get always what you want from me
You can make it easy, can't you see
You shot a hole, hole, hole
Hole in my soul

Dreams go on forever and ever
Good things do not last forever
Heaven can wait but I can't
But I'd do it once again, babe
I think tomorrow it's too late, babe
Oh, only love breaks my heart

Sketches

http://www.desipainters.com/paintings/pencil-sketches/

http://www.papamstudios.com/ig/