This is a guide to use git Bash with Azure dev ops,
first we need to login at azure dev ops : https://azure.microsoft.com/en-us/services/devops/?nav=min
you can login from office 365 account, or sign in.
Category Archives: Utils
Transact SQL useful functions to mass database change
- Friday, 10 November 2017 17:06
- admin
- 0 Comments
a list of useful functions to rename or massively create tables in a Microsoft SQL sever database (Transact-SQL)
–-Create scripts for All Procs SELECT SM.definition FROM sys.sql_modules SM INNER JOIN sys.Objects SO ON SM.Object_id = SO.Object_id WHERE SO.type = ‘p’ -–Create scripts for All Views SELECT SM.definition FROM sys.sql_modules SM INNER JOIN sys.Objects SO ON SM.Object_id = SO.Object_id WHERE SO.type = ‘v’ -–Create scripts for All Functions SELECT SM.definition FROM sys.sql_modules SM INNER JOIN sys.Objects SO ON SM.Object_id = SO.Object_id WHERE SO.type = ‘FN’
Hi guys!
I have developed this simple dll for the barcode printing / representation, the use is very simple :
this is the code of the sample form:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using BarcodeFree;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
Code128 text = new Code128();
this.textBox2.Text = text.Encode( textBox1.Text);
ImageBarcode barcode, barcode2, barcode3, barcode4;
//parameters to call ImageBarcode:
//public ImageBarcode(int width, int height, string value, bool Landscape = false, Color? color = null,Color? colorFore=null )
barcode = new ImageBarcode(pictureBox1.Width, pictureBox1.Height, textBox2.Text);
barcode2 = new ImageBarcode(pictureBox2.Width, pictureBox2.Height, textBox2.Text, false, Color.Red, Color.Yellow );
barcode3 = new ImageBarcode(pictureBox3.Width, pictureBox3.Height, textBox2.Text, true);
barcode4 = new ImageBarcode(pictureBox4.Width, pictureBox4.Height, textBox2.Text, false, Color.Turquoise , Color.LightGray);
// barcode = new ImageBarcode(250, 112, textBox2.Text);
this.pictureBox1.Image = barcode.GenerateImage();
this.pictureBox2.Image = barcode2.GenerateImage();
this.pictureBox3.Image = barcode3.GenerateImage();
this.pictureBox4.Image = barcode4.GenerateImage();
// this.pictureBox1.Refresh();
}
}
}
And Finally the DLL( for demo test):
Some documentation about barcodes:
http://www.keyence.com/ss/products/auto_id/barcode_lecture/basic/code128/
http://www.jtbarton.com/Barcodes/BarcodeStringBuilderExample.aspx
http://www.jtbarton.com/Barcodes/BarcodeOverview.aspx
http://www.gs1.org/docs/barcodes/GS1_General_Specifications.pdf
especially thanks to:
http://grandzebu.net/informatique/codbar-en/code128.htm
How to make an ajax call inside a WordPress site
- Wednesday, 12 October 2016 20:19
- admin
- 0 Comments
After several days, finally I found how to make ajax call from my wordpress site, I hope that it will help those who have had this problem:
first, I was created a post inside a wordpress whit this html code:
<section id="main">
<table id="tng" class="datagrid">
<thead><tr><th colspan="3">
Sample ping App
</th>
</thead>
<tbody>
</tr><tr>
<td width="50%" align="right"><b>Host or IP:</b></td>
<td><input id="ip" size="20" value="" ></td>
<td><button type="button" onclick="PING()">Ping</button></td>
</tr>
</tbody>
</table>
<img id="image" src="spinner.gif" alt="wait..." style="display: none;">
<br>
</section>
<section id=food>
<h3 id="notification"></h3>
</section>
As you can see the only important thing is the onclick event for the button that calls de functionPING()
A usefull command to copy only rights or permissions from one source to another is:
robocopy \\server\sharedfolder f:\folder /E /Copy:S /IS /IT