Export SQL query to CSV

1. Execute your Query with "Results to Grid" option selected (You can select this option with its icon or by menu "Query - Results To - Results to grid"). 2. Once your Query has finished, right-click on the results grid and select the option "Save results As...". 3. Save as Type: CSV.

Add WebService to my project (ASMX + CS) in Visual Studio

I've never found on my Visual Studio an option to directly add a new WebService file so I looked for a solution and I got this one, I hope it'll help you:1. From anywhere in your Solution Explorer (where you want to add the WebService), create a "New Item".2. In the "New Item" Window, select …

Sigue leyendo Add WebService to my project (ASMX + CS) in Visual Studio

Find Public Key Token of my Project in Visual Studio 2012

In order to find the public key token of your project you need to follow this: 1. Open the Developer Command Prompt fot VS2012. 2. Write this command (Use full path of your DLL file): sn -T C:MyDLLdirectoryMyDLLfile.dll 3. Automatically it shows you your token: Microsoft (R) .NET Framework Strong Name Utility Version 4.0.30319.17929 Copyright …

Sigue leyendo Find Public Key Token of my Project in Visual Studio 2012

SharePoint 2013 + Visual Studio 2012: File «.g.cs» dissapeared

Sometimes, when you're developing a visual web part, the designer file (with .g.cs extension) dissapears in front of your eyes. After finding nothing in the internet, we've just discovered why it is happening: You've to add the "Site URL" property in the Project properties. That's beacuse it is a web part for sharepoint, and Visual …

Sigue leyendo SharePoint 2013 + Visual Studio 2012: File «.g.cs» dissapeared

Añadir LOG en VBA (O Como Escribir en un Fichero TXT)

Tenemos nuestro código en VBA listo para ejecutarse, con variables, condiciones, bucles... Puede que depurando nos baste, pero en ocasiones podemos necesitar escribir en un fichero externo que al ejecutarse nos pueda dar en un solo lugar toda la información que queramos. En primer lugar, creamos una función que se encargue de comprobar si un …

Sigue leyendo Añadir LOG en VBA (O Como Escribir en un Fichero TXT)