Skip to content

Instantly share code, notes, and snippets.

View meziantou's full-sized avatar

Gérald Barré meziantou

661 followers · 1 following
View GitHub Profile
@meziantou
meziantou / main.cs
Created January 29, 2018 03:20
Paste images
private void OnPaste(object sender, DataObjectPastingEventArgs e)
{
HandleDataObject(e.DataObject);
e.Handled = true;
}
private void HandleDataObject(IDataObject data)
{
if (data == null) throw new ArgumentNullException(nameof(data));
@meziantou
meziantou / RemoteDataCache.cs
Created January 2, 2018 13:46
RemoteDataCache
using System;
using System.Threading;
using System.Threading.Tasks;
namespace ClassLibrary1
{
public abstract class RemoteDataCache<T> : IDisposable
{
private readonly SemaphoreSlim _semaphoreSlim = new SemaphoreSlim(1, 1);
private CacheValue<T> _value;
@meziantou
meziantou / program.cs
Last active December 18, 2017 02:05
Benchmark string concat
class Program
{
static void Main(string[] args)
{
BenchmarkRunner.Run<StringBenchmark>();
}
}
[OrderProvider(SummaryOrderPolicy.FastestToSlowest)]
[CoreJob]
@meziantou
meziantou / OneDriveFilePicker.ts
Created April 23, 2017 09:05
OneDriveFilePicker.ts
document.getElementById("OpenOneDrive").addEventListener("click", e => {
e.preventDefault();
launchOneDrivePicker().then(result => {
if (result) {
for (const file of result.value) {
const name = file.name;
const url = file["@microsoft.graph.downloadUrl"];
console.log({ name: name, url: url });
fetch(url)
@meziantou
meziantou / fileupload.ts
Created February 26, 2017 22:03
FileUpload (drag and drop files and directories, paste)
improveFileUpload();
function improveFileUpload() {
const input = document.getElementById("FileUpload");
if (!input) {
console.warn("input not found.");
return;
}
if (!(input instanceof HTMLInputElement)) {
@meziantou
meziantou / ObjectDataReader.cs
Created February 1, 2017 00:28
ObjectDataReader (BulkInsert)
public class ObjectDataReader<T> : DbDataReader
{
private IEnumerator<T> _iterator;
private IDictionary<string, int> _propertyNameToOrdinal = new Dictionary<string, int>();
private IDictionary<int, string> _ordinalToPropertyName = new Dictionary<int, string>();
private Func<T, object>[] _getPropertyValueFuncs;
public ObjectDataReader(IEnumerator<T> items)
{
_iterator = items ?? throw new ArgumentNullException(nameof(items));
@meziantou
meziantou / LazyLoad.ts
Created December 19, 2015 18:20
Lazy load images
module LazyLoader {
const attributeName = "data-src";
function throttle(wait: number, func: () => any, immediate = false) {
var context: any;
var args: any;
var timeoutHandle: number;
var result: any;
var previous: Date;
@meziantou
meziantou / Index.html
Last active April 7, 2024 14:02
Javascript - Record audio
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title></title>
</head>
<body>
<h1>Audio</h1>
@meziantou
meziantou / SearchUniqueIdentifier
Last active August 29, 2015 14:13
Search uniqueidentifier (guid) in SQL Server database
DECLARE @searchValue uniqueidentifier = 'a2843a1e-6ed4-4045-a179-51f0743943b8'
DECLARE @sql NVARCHAR(MAX);
WITH cte_sql_queries(sql_query) AS (
-- SELECT '[dbo].[Customer]' FROM [dbo].[Customer] WHERE [Customer_Id]=@searchValue
SELECT 'SELECT ''' + QUOTENAME(t.TABLE_SCHEMA) + ''' schema_name '
+ ' , ''' + QUOTENAME(t.TABLE_NAME) + ''' table_name '
+ ' , ''' + QUOTENAME(c.COLUMN_NAME) + ''' column_name '
+ ' , ''SELECT ' + QUOTENAME(c.COLUMN_NAME) + ', * FROM ' + QUOTENAME(t.TABLE_SCHEMA) + '.' + QUOTENAME(t.TABLE_NAME) + ' WHERE ' + QUOTENAME(c.COLUMN_NAME) + '='''''+ CAST(@searchValue AS NVARCHAR(36)) +''''''' query '
+ ' FROM ' + QUOTENAME(t.TABLE_SCHEMA) + '.' + QUOTENAME(t.TABLE_NAME)
@meziantou
meziantou / WebFormsBootstrapValidation.aspx
Last active May 27, 2023 11:29
ASP.NET WebForms Validators & Bootstrap
<%@ Page Language="C#" AutoEventWireup="true" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>ASP.NET WebForms Validators & Bootstrap</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.1/css/bootstrap.min.css" />
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.1/css/bootstrap-theme.min.css" />