Skip to content

Instantly share code, notes, and snippets.

View pedroinfo's full-sized avatar

Pedro Xavier pedroinfo

9 followers · 43 following
  • São Paulo - BR - Solar System | Milky Way
View GitHub Profile
@pedroinfo
pedroinfo / DsToXML.cs
Last active November 4, 2016 17:41
DataSet To Xml (Convert Multiple Tables to XML file)
string connectionString = "Server=192.168.2.56;Database=NEWDB;User Id=SA;Password=123456;";
var conn = new SqlConnection(connectionString);
conn.Open();
var tables = new[] { "Categories", "CustomerCustomerDemo", "Employees", "Territories" };
var sb = new StringBuilder();
foreach (var table in tables)
{
var ds = new DataSet();
var query = "SELECT * FROM " + table + " ";
@pedroinfo
pedroinfo / Properties.sql
Last active November 4, 2016 17:40
c# Properties - Sql Server.sql
SELECT 'public ' +
CASE data_type
WHEN 'bigint' THEN 'int'
-- WHEN 'binary' THEN 'raw'
WHEN 'bit' THEN 'int'
WHEN 'char' THEN 'char'
WHEN 'datetime' THEN 'DateTime'
WHEN 'decimal' THEN 'decimal'
WHEN 'float' THEN 'float'
-- WHEN 'image' THEN 'long raw'
@pedroinfo
pedroinfo / SQL Server SHRINK.sql
Last active February 14, 2017 19:01
SHRINK - SQL Server
USE SEUDB
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE SEUDB
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (SEUDB_Log, 1);
GO
-- Reset the database recovery model.
@pedroinfo
pedroinfo / Backup.bat
Created November 22, 2016 19:15
Backup SQL Server Express (Script BAT)
@ECHO OFF
SET DT=%DATE:~6,4%-%DATE:~3,2%-%DATE:~0,2%
SET TM=%TIME:~0,2%-%TIME:~3,2%-%TIME:~6,2%
sqlcmd -U sa -P 123456 -S DSK02\SQLEXPRESS -d CAPP2 -Q "backup database CAPP2 to disk='C:\Backup\%DT% %TM%.bak' "
@pedroinfo
pedroinfo / Split.cs
Created January 9, 2017 16:22
split tiff multipage c# - Example
public class Program
{
public static void Main(string[] args)
{
SplitTiff(@"c:\temp\0001.tif");
Console.Read();
}
public static void SplitTiff(string filepath)
{
@pedroinfo
pedroinfo / Program.cs
Created February 10, 2017 13:16
Copy Structure - Files and Folders
using System.IO;
namespace CopiaEstrutura
{
public class Program
{
public static void Main(string[] args)
{
string entrada = @"C:\ENTRADA";
string saida = @"C:\SAIDA";
@pedroinfo
pedroinfo / HtmlDinamico.html
Created February 13, 2017 18:58
Campos dinâmicos - HTML
<!DOCTYPE html>
<html lang="pt-br">
<head>
<title></title>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css" />
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap-theme.min.css" />
@pedroinfo
pedroinfo / ToUTF8.cs
Created February 14, 2017 18:55
Convert txt files to UTF8
var files = Directory.EnumerateFiles(txtDiretorio.Text, "*.txt", option);
foreach (var file in files)
{
var content = File.ReadAllLines(file);
File.WriteAllLines(file, content, Encoding.UTF8);
}
@pedroinfo
pedroinfo / collate.sql
Created April 10, 2017 12:46
Alterar o Collate - SQL Server
ALTER DATABASE teste COLLATE SQL_Latin1_General_CP850_CI_AS
@pedroinfo
pedroinfo / MergeImageFilesPdf.cs
Created July 13, 2017 20:18
Merge image files with itextsharp
public static void MergeFilesPdf(string destinationFile, List<string> fileNames)
{
Document document = new Document();
using (var stream = new FileStream(destinationFile, FileMode.Create, FileAccess.Write, FileShare.None))
{
PdfWriter.GetInstance(document, stream);
document.Open();
foreach (string strFileName in fileNames)