Skip to content

Instantly share code, notes, and snippets.

Kiquenet kiquenet

Block or report user

Report or block kiquenet

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@kiquenet
kiquenet / HelperFicheroCSV.vb
Created Dec 31, 2018
Proceso Transaccional CSV - 1
View HelperFicheroCSV.vb
Public Shared Sub DoProcesoLeerCSV(ByVal encoding As System.Text.Encoding, ByVal fechaCargaYYYYMMDD As String, ByVal nombreFichero As String, ByVal nombreFicheroCarga As String)
'''''''Log("Leer CSV " & nombreFichero & " *** OJO ENCODING *** ")
Dim objReader As New StreamReader(nombreFichero, encoding, True)
Dim sLine As String = ""
Dim arrText As New ArrayList()
Do
sLine = objReader.ReadLine()
If Not sLine Is Nothing Then
@kiquenet
kiquenet / GeneraInforme.vb
Last active Jun 19, 2018
Generar Informe
View GeneraInforme.vb
Public Class WebForm1
Inherits System.Web.UI.Page
Dim Usuario As String
Dim ConexionSqlServer As String = "Data Source=xxxxx"
Dim Conexion As String = ConexionSqlServer & "Provider=SQLOLEDB;"
'Dim Fecha As Date
Dim FechaDesde As Date
Dim FechaHasta As Date
'Dim FechaString As String
@kiquenet
kiquenet / DCL.xsd
Last active Dec 7, 2018
XML Validation using XSD
View DCL.xsd
<?xml version="1.0" encoding="ISO-8859-1"?>
<xs:schema xmlns="http://www.seg-social.es/creta/esquemas/V100/DCL" xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.seg-social.es/creta/esquemas/V100/DCL" elementFormDefault="qualified" attributeFormDefault="unqualified">
<xs:element name="DCL">
<xs:complexType>
<xs:sequence>
<xs:element ref="Autorizado"/>
<xs:element ref="Liquidacion"/>
</xs:sequence>
</xs:complexType>
</xs:element>
@kiquenet
kiquenet / SQL
Created Feb 18, 2016 — forked from huguogang/SQL
SQL Server Performance DMV Sample Queries
View SQL
-----------------------------------------------------------------------
-- Collection of queries that helps in performance tuning
--grant permission to user
GRANT VIEW SERVER STATE TO [user_name]
------------ based on http://msdn.microsoft.com/en-us/magazine/cc135978.aspx
---------- Uncover hidden data to optimize application performance -----------------------
-- * Number of missing indexes
View gist:4964f650fe70c3180ea6
Use ReportServer
go
/* Performance Tips
1. High TimeDataRetriveal
* Removed unused datasets
* Analyze the dataset query in SQL Profiler
* Combine Datasets where possible
2. High TimeProcessing
* Use less report parts (tables, charts...)
* Do Grouping and Sorting on the SQL Side
@kiquenet
kiquenet / codesnippet.Email1.cs
Created Dec 2, 2014
Send Email Test AlternateView
View codesnippet.Email1.cs
private void EnviarTest(string body, MBC_ADJUNTOSList listaAdjuntos)
{
// Montamos la estructura básica del mensaje...
MailMessage mail = new MailMessage();
mail.From = new MailAddress("xxxx@kiquenet.com");
mail.To.Add("xxxx@gmail.com");
mail.Subject = "Test";
// Creamos la vista para clientes que // sólo pueden acceder a texto plano...
You can’t perform that action at this time.