Click here to Skip to main content

Submit your article

Data

data

Great Reads

Understanding Merkle Trees - Why Use Them, Who Uses Them, and How to Use Them

by Marc Clifton

An interactive demo of how audit and consistency proofs work

Highstock + Data-Forge + Yahoo

by Ashley Davis

A demo of Highstock using Data-Forge with financial data loaded from Yahoo

Fast Fourier Transform Caterpillar Method

by Alexander Semjonov

Developing fastest FFT implementation based on precompile tool using data driven approach

Simple Way to Convert HTML Table Data into PHP Array

by Garbel Nervadof

Convert HTML table data from a website into PHP array

Latest Articles

Fededim.Extensions.Configurati...

by Federico Di Marco

Fededim.Extensions.Configuration.Protected is an improved ConfigurationBuilder which allows partial or full encryption of configuration values stored inside any possible ConfigurationSource and fully integrated in the ASP.NET Core architecture using Data Protection API.

SQL Table Dependency Diagram Generator (SSMS 18,19 & 20)

by Bert O Neill

This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.

How Much Can Sqlite Handle? Multiple Threads Concurrently Inserting Into Sqlite

by raddevus

An informal study of the Sqlite database and how many concurrent inserts it can handle. Will help you decide if you want to use Sqlite in your projects.

Templated Data container with Razor

by Pete O'Hanlon

Rather than littering a razor component with @if (a == b) logic to show items, use render fragments to make a declarative component

All Articles

Data

DataTable Merge Performance

1 Jul 2013 by Alexandros Pappas

This project measures performance of the DataTable.Merge method.

Convert XML File to Excel File

27 Nov 2017 by Altaf Ansari

Converting XML Data into DataTable and Exporting DataTable into Excel File

Tuples in C# 7.0

9 May 2017 by Ammar Shaukat

C# 7.0 has been introduced with many new useful features. One of them is new datatype "ValueTuple". In this article, I'll be writing about Tuples in C# 7 briefly.

Retreive and update meta property of a table in MSSQL

14 Jun 2013 by barry fat

develop a web based data dictionary

Convert filesize (bytes) according to highest possible size scale (KB, MB, GB, TB, PB)

5 Apr 2013 by bEGI23

Convert filesize (bytes) according to highest possible size scale (KB, MB, GB, TB, PB).

Ensure Your Code First DB is Always Initialized

27 Jun 2012 by Brady Kelly

A quick and easy way to ensure that your Code First DB Initializer is always run when your app starts, not just on the first data access operation

Postgres Foreign Table Example

9 May 2020 by Carlos Luis Rojas Aragonés

Snippet to get started with foreign tables

Unified Dimensional Model (UDM)

23 Sep 2013 by coded007

A word about Unified Dimensional Model we use in analysis services.

Attunity Connectors to Transfer Data from Oracle to SQL Server using SSIS

7 Dec 2015 by Divyant Kulshrestha

This tip is useful when we have to move data from Oracle database to SQL Server database or vice-versa using SSIS.

Framework for Performing Aggregation and Plain MongoDB Queries in myBatis Style

12 Sep 2013 by dmgcodevil

Framework for performing aggregation and plain MongoDB queries in myBatis style

SQL one to one relations

6 Nov 2011 by FDW

How to define a one to one relation

Simple Way to Convert HTML Table Data into PHP Array

25 Jan 2016 by Garbel Nervadof

Convert HTML table data from a website into PHP array

Random Date/Time Test Data Generation

25 Aug 2016 by Gene R. Browning

Generate random dates (and times if you like) for your test data environment.

SQL-Server-2005

SQL-server-2000

A Small Vector and Hash Table Implementation w/ No STL Dependencies

16 Mar 2022 by honey the codewitch

Get your data on, even on platforms without a reliable STL implementation using these simple but critical classes.

Enumerate entries in TNSNames.ora using Oracle data provider class and DataSourceEnumerator

12 Jul 2011 by Jana Sattainathan

There is an easier way to get the Oracle data source than custom-code a TNSNames.ora parser.

CSV File Processor - Manage Comma Separated Value Files

31 May 2022 by Jochen Haar

Class to manage the content of Comma Separated Value Files or to deal with Structured Tables in memory

Object Relational Mapping via Reflection

15 Jul 2011 by Kelqualyn

Same thing 10-100 times faster.Additionally, IndexMap can be built only once per DataTable.using System;using System.Collections.Generic;using System.Data;using System.Linq;using System.Linq.Expressions;using System.Reflection;namespace ReflectiveReader{ public static...

Generate Excel Chart from Data in .NET Applications

3 Dec 2013 by LazyCoder0

This tip describes how to generate Excel charts from data in .NET applications using Office Automation.

Pagination conversion in C#

10 Jun 2022 by ludosoep

Easily convert a request for a page between pagination designs (page sizes)

How to update a row with another row if column values are null in SQL

17 Aug 2012 by ManojKumar19

Update row column with another row column in same table SQL only if it is null.

SQL-Server-2005

SQL-server-2000

Comparing Two Files Line by Line

22 Nov 2020 by Marijan Nikic

Windows batch utility in VBscript to read and compare two text files line by line

Default Dimension Members Generator (T-SQL)

22 Aug 2016 by Miljan Radovic

T-SQL script which generates and executes INSERT statements for missing default dimension members (Unknown, Not Available, Not Applicable)

Legacy Data Migration – let data know enough about itself

13 Aug 2014 by MinhajMohammed

Export & Import Data+Attach Database of Higher Version to Lower Version

29 May 2014 by NIKS SHINE

Uploading database of higher version of DBMS to the lower version one.

Tutorial: Compare JSON Documents and Apply Patches in TerminusDB and MongoDB

2 Mar 2022 by Oliver Smith 2022

Save time comparing JSON docs and build collaboration features into your applications

Templated Data container with Razor

26 Jun 2023 by Pete O'Hanlon

Rather than littering a razor component with @if (a == b) logic to show items, use render fragments to make a declarative component

Good Universal Paramerter and Stored Procedure Execution

16 Oct 2013 by Robert Bettinelli

Check this for a good universal way of running stored procedures..

web_development

How to generate test data?

24 Nov 2011 by Shivprasad koirala

During testing phase you would like to generate range of test data so that you can test your application properly. Most of the times testers end up doing monkey testing or exploratory testing.

Object Relational Mapping via Reflection

14 Jun 2011 by Simon Bridge

Illustrates how to quickly and dynamically populate an object from a data-row

ASP.NET MVC Custom Compare Data Annotation with Client Validation

11 Jun 2014 by Sreenivas Chinni

This is a tip to add custom data annotation with client validation in ASP.NET MVC 5

Transferring Large Data With WCF

23 Nov 2014 by Suniil Kumar Pal

Configuration settings need to be made to transfer large data with WCF

Expanding / Collapsing Data Grid View

5 Jan 2016 by The ANZAC

A simple and modifiable approach to collapsing and expanding grouped data within a datagridview custom control

How to Create and Use Custom Control in UWP

1 Dec 2015 by Umer Qureshi

How to create a Custom Control so it can be used later and how to give access to some of it properties

Simple Data Binding UWP

1 Dec 2015 by Umer Qureshi

How to bind data in a simple way without writing any code

Using Data Classes in ASP.NET - A Beginner's Guide

16 Aug 2015 by Wombaticus

A beginner's introduction to using data classes in ASP.NET.