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

A JavaScript Form Generator

by Member 4206974

FormGen, a JavaScript Form Generator

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

Latest Articles

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.

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.

A JavaScript Form Generator

by Member 4206974

FormGen, a JavaScript Form Generator

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

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

13 Mar 2017 by Marc Clifton

An interactive demo of how audit and consistency proofs work

A JavaScript Form Generator

15 Jan 2024 by Member 4206974

FormGen, a JavaScript Form Generator

Highstock + Data-Forge + Yahoo

16 Feb 2017 by Ashley Davis

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

Fast Fourier Transform Caterpillar Method

3 Jul 2017 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

25 Jan 2016 by Garbel Nervadof

Convert HTML table data from a website into PHP array

Demo Data

30 Oct 2017 by Kornfeld Eliyahu Peter

“Beware the Jabberwock, my son! The jaws that bite, the claws that catch! Beware the Jubjub bird, and shun The frumious Bandersnatch!” - LEWIS CARROLL

A Generic and Advanced PDF Data List Reporting Tool

10 Feb 2020 by Shenwei Liu

Creating PDF reports for grouped or non-grouped data lists in C# with many custom options and configurations (providing source code with .NET Framework 4.6.1 and .NET Core 3.1)

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

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

Resolving an Unreferenced Partial Type Name using Fusion

16 Sep 2020 by John B Oliver

Resolve unreferenced type in .NET app using partial type name from GAC

Indexed Views and How It Can Help in Improving Query Performance

23 Mar 2019 by Minh Tuan Do

A considerable method to speed up query running time

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

CSV/Excel File Parser - A Revisit

7 Apr 2018 by #realJSOP

An example of evolving code to fit new demands

Implement Virtual List with Paged Data

3 Jan 2013 by Young Ye

This article solve the performance issue while loading and displaying large amounts of data by using a virtual list with paged data technique.

Creating a Redis Client using the .NET System.IO.Pipelines and Kestrel Sockets Libraries

29 Apr 2021 by Matthew Dennis

A Redis Client written from the ground up using System.IO.Pipelines, Span, etc

ViewState

28 Feb 2014 by ASP.NET Community

ViewState is the mechanism that allows state values to be preserved across page postbacks.Because of the stateless nature of web pages, regular

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

10 Feb 2016 by Jesus Carroll

SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.

SQL-Server-2016

The Stored Procedure Framework Now Supports Dynamic Fields within Multiple Recordsets

1 Aug 2016 by dibley1973

The stored procedure framework now supports dynamic fields within multiple recordsets

From Stationarity to Randomness through Chaos

22 Nov 2016 by Miguel Diaz Kusztrich

Using R to explore complexity of time series generated by simple process

signal-processing

Help in storing data of treeview using arraylist

6 Apr 2011 by Espen Harlinn

Assuming you have a class for your tree nodes similar to:[Serializable]public class NodeBase : Base { NodeBase parent; string name; [Bindable(true)] [Browsable(true)] public NodeBase Parent { get { ...

indexing a collection

14 Jul 2011 by Sergey Alexandrovich Kryukov

The point of hashing and Dictionary is using the unique keys bur also fast search by the key, which you can call indexing. The speed of search is of O(1), see http://en.wikipedia.org/wiki/Big_O_notation[^]. If you think about it, you will understand that a non-unique key cannot be used with...

union and structure

4 Dec 2011 by Sergey Alexandrovich Kryukov

Why 24 bytes? This is the size of 3 8-bytes (64-bit) words. You probably use 64-bit system. The size of int is system-dependent. And no, the structure size does not have to be the sum of the member sizes. It depends on structure memory alignment which can be different. Is is usual to use...

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

ASP.NET Web Component for editing SQL tables

29 Nov 2012 by RovenetBill

ASP.NET c# component for editing SQL tables with plug-in column format adapter architecture.

Query on Table containing 10,000,000 records and size more than 4GB

21 May 2014 by Kornfeld Eliyahu Peter

There are a few things you can do (and I deal with historical data with over 560.000.000 records so far).1. Make your table partitioned, probably over some column of date. That can help SQL to scan index pages only for a specific time frame.2. Choose carefully your clustered index. The...

Want to return huge data from WCF services

10 Jun 2016 by Patrice T

Wrong way.You have to change the way your app is organized.30000 rows takes huge time to retreive from database, and it takes huge time to build the grid. There is also very little chances that someone ever have real usage of the 30000 rows in a single grid.You have to change how your...

C# comparing and extracting data from 2 list<>

14 Jul 2016 by OriginalGriff

If I do a dummy setup and test on your code:public class MachineAD { public string Name; public int ID; }public class Machine { public string BarCode; }public class MachineUnified { public int IDad; public string NameFromAD; public...

Write a recursive function sumrecursive() to find the sum of first n natural numbers.

17 Jan 2019 by CPallini

The logic of the recursive (say) sum function is already given in the exercise text. Just the implementation is missing. Now what is exactly your problem with such implementation? If you are not able to write a recursive function, then have a look at this page: C++ Recursion - Recursive...

How to Solve Word Ladder Problem?

22 Nov 2020 by Sandeep Mewara

A look into graph based algorithm

Paging and Sorting using ASP .NET Core Razor Page, Web API, and Entity Framework

15 Jan 2021 by DotNetLead.com

How to implement paging and sorting to yield good performance

entity-framework

Fededim.Extensions.Configuration.Protected: The Ultimate Integration between ASP.NET Configuration and Data Protection API

7 Feb 2024 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.

Import data from XML on Grid

30 Aug 2011 by sachin10d

______________...

Server - Client Application?

2 Sep 2011 by Abhinav S

StepsStep 1) You need to host the database in central server / location and allow client programs to access it.Step 2) You will need to make sure all clients have network access to this location.Step 3) To do this, you will need to setup a database connection, say an ODBC setup, on every...

Jquery Cross-Domain ajax call using JSONP

11 Oct 2013 by ASP.NET Community

Hi everyone. We all know the role of ajax and its implementation. We can use ajax in asp.net as well as in javascript/jquery. But there is a

Comparing ListView with GridView,DataList and Repeater

11 Oct 2013 by ASP.NET Community

The ListView control is a new data presentation control that was added to .Net 3.5 , you may wonder why its added to the framework , and what it

Caching in ASP.net

11 Oct 2013 by ASP.NET Community

CachingAuthor: Prakash Singh MehraIntroduction: It is a way to store the frequently used data into the server memory which can be retrieved very

Query on Table containing 10,000,000 records and size more than 4GB

21 May 2014 by Maciej Los

Amol_B wrote:My Question is, is there any by which we can load large data(greater the 3 GB ) within a minute ?(...)A select * for table query takes 27 Minutes Retrieve dataNo, there is no method to load 10 millions records within one minute even if you add indexes, make partitioned your...

Query on Table containing 10,000,000 records and size more than 4GB

21 May 2014 by Jörgen Andersson

I'm seeing two errors here.Firstly average usage and consumption per item is aggregation of data.Filtering and aggregation is what the database excels at. So why on earth do you want to move the whole bunch of data off the database. Do your aggregation in the query.Were having a database...

Legacy Data Migration – let data know enough about itself

13 Aug 2014 by MinhajMohammed

Testing Discrete Fourier Transform Program

18 Oct 2015 by Andreas Gieriet

Each meaningful test consists of stimulus, expected result, actual result an a comparator that compares the expected and the actual result.If you compare the actual versus the expected result here, you see that you have a precision issue.The expected result seems to be on three figures only....

Testing Discrete Fourier Transform Program

19 Oct 2015 by nv3

To me it looks like your results are correct to 15 significant digits, which is what was to be expected calculating in type double. So there is nothing to complain about. I assume your reference results were taken from a book and only the first three digits after the decimal were printed. So...

Passing data between forms

26 May 2016 by Karthik_Mahalingam

Create a property in Form2 public partial class Form2 : Form { public int[] MyArray { get; set; } public Form2() { InitializeComponent(); }Assign the value to the property of Form2 before calling show() int[] data = new int[1000]; ...

Want to return huge data from WCF services

10 Jun 2016 by Dave Kreskowiak

Wrong, wrong, WRONG! Users NEVER want to look at 30,000 rows. Hell, I don't even like looking at 20 rows.Setup your grid for paging. You only need to show a small number of rows. Each page the grid shows should generate a request to the WCF service that will return just that number of...

Acquiring Stock Market Data from Alpha Vantage

7 Jan 2018 by Ashley Davis

How to download stock market data from Alpha Vantage

A data structure(tree) with multiple classes

24 Feb 2018 by BillWoodruff

Knowing your tree's item nodes are always leaf nodes of a specific type makes your task a bit simpler. I'm going to post a sketch of a structure that will implement a tree of this type which I know works. I say "sketch" because my goal is to assist you in developing your programming skills ......

Data Encryption in Azure

8 Nov 2018 by DataBytzAI

Overview of encryption at rest, in motion and in use with Azure Encryption

Write a recursive function sumrecursive() to find the sum of first n natural numbers.

17 Jan 2019 by OriginalGriff

First let's deal with the "compilation errors": You can't just copy your homework question into a .C source file and compile it - that will never, ever work! The question is am English description of what your teacher requires the code to do, it is up to you to read the instructions and write...

How do I combine two JSON strings so it can later be parse?

22 Sep 2020 by Richard Deeming

Try something like this: var rows = dtbl.Rows.Cast().Select(r => Convert.ToString(r[0])) JArray token = new JArray(rows.Select(r => JToken.Parse(r)));

Help in storing data of treeview using arraylist

5 Apr 2011 by Sergey Alexandrovich Kryukov

There is not need to use ArrayList, ever. Instead, use generic System.Collection.Generic.List. Non-generic containers are rendered obsolete with introduction of generics in the .NET Framework 2.0.—SA

Help in storing data of treeview using arraylist

5 Apr 2011 by Abhinav S

I would consider using a Dictionary object.

Help in storing data of treeview using arraylist

5 Apr 2011 by dan!sh

You do not need ArrayList or anything to do a "save" of the treeview. You can have all the details in the TreeView object. For the actual save of the treeview structure (assuming you are saving that), you will need to have a database set up (depending on the application size) to map all the...

Configuring WCF Data Services Using Lambda Expressions

25 Apr 2011 by Gil Fink

A simple solution for using lambda extensions instead of strings while configuring a WCF Data Service

SQL Server database query Delete and Insert question

7 Jul 2011 by Wonde Tadesse

Bigint size is -2^63 through 2^63-1. You are quite far away to reach here. There is no worry about it.

Server - Client Application?

2 Sep 2011 by Wendelius

To add to Abhinav's answer, since this is an Access project, the client needs to have direct access to the database files. This means that you most likely have to share the folder where the files are located.For the future. If you plan to have more clients and you want to achieve more secure...

DOUBT ON IMPLEMENTATION OF STACK

14 Oct 2011 by Sergey Alexandrovich Kryukov

Look at the very first line of main. Where top comes from? You never allocated memory for this pointer.—SA

SSIS package: SSIS debug hot has stopped working.

10 Dec 2011 by thatraja

Fix linkMSDN - SSIS Debug Host has stopped working[^]

i want a Query for selecting of Table

6 Jun 2012 by Stephen Hewison

Here you go:SELECT TOP 3 NewsId, NewsTitle, NewsDate FROM NEWS ORDER BY NewsDate DESCThe following orders the results so the newest are at the top:ORDER BY NewsDate DESCThe following instructs the SELECT to get just the first 3 rows:SELECT TOP 3

SQL-Server-2008

Show Data in a Tooltip

31 Jul 2012 by enhzflep

Here you go - I hope it's what you're interested in. If not, let me know and I'll do the best I can. :)Get data from excel sheetvar excelApp=null, excelFile=null, excelSheet=null;var filename =...

Excel VBA loads data to Excel sheet in wrong location

29 Aug 2012 by Maciej Los

First of all, read about MS Excel's objects[^], because Sheet object and Worksheet object is not the same.The best programming practice is to use code with context. To explain what i mean, do it:1) Open or create few MS Excel Workbooks,2) Activate first workbook and run this code:For i...

hex to dec with 1.15 fractional format in C++

22 Oct 2012 by parths

A couple of changes I would suggest are,The largest positive number is 0x7fff / 0x8000. So instead of dividing by 32767, we need to divide by 32768.Also, change the 'unsigned int F' declaration to 'short'. What this will do is give you the 2's complement negative number which you're looking...

hex to dec with 1.15 fractional format in C++

22 Oct 2012 by Jochen Arndt

According to the documentation signed numbers are represented in the two's complement format. To convert them you may use this:// Get the absolute number masking out the sign bitint n = ((msg0 & 0x7F)

How can i restart from ID=1 ?

6 Nov 2012 by kankeyan

you need to reseed the identity column. check for the below example.Hope this may help you.If helps Vote it.USE AdventureWorksGO/* Create a table with one identity column */CREATE TABLE TableID (ID INT IDENTITY(1,1), Col VARCHAR(10))GO/* Insert 10 records with first value...

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

How can i restart from ID=1 ?

6 Nov 2012 by Eyakem

Here is a quick example, i'll walk you through..1 Lets create a table called UserTable2 insert four rows3 delete the first row (so we are where you are now, a table that starts from ID=2My solution: copy the contents of the table to a temporary table, truncate the origional table and...

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

How to read multiple worksheets within single excel in C#?

2 Dec 2012 by CHill60

Firstly your comment "which read first worksheet (by default)" isn't quite accurate - it's simply that the first sheet was active the last time you saved the spreadsheet ... if you had left the 2nd sheet visible before saving and closing the spreadsheet then the second sheet would have been read...

Data transport between apps without saving buffered file, in real time, how it is possible? "about:"(and others) pages in browser is generated, how it is possible?

19 Dec 2012 by Christian Graus

You mean 'about internet explorer' ? It's just generated by code in the exe. If you mean an about page that a site has, it's HTML on the site.You can keep data in memory without writing it to the file system, but you don't want to do that for too long. If the data is being moved in real...

DataTable Merge Performance

1 Jul 2013 by Alexandros Pappas

This project measures performance of the DataTable.Merge method.

Unified Dimensional Model (UDM)

23 Sep 2013 by coded007

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

DataSet Vs SqlDataReader

11 Oct 2013 by ASP.NET Community

Confused how to use DataSet and How to use DataReader?I am trying to give some of basic understanding about and differences between DataReader

Books and Help Resources on Entity Framework

11 Oct 2013 by ASP.NET Community

Programming theMicrosoft® ADO.NET Entity Framework by David SceppaPublisher : MicrosoftProgramming EntityFrameworkBuilding Data Centric

entity-framework

Conversion failed when converting the varchar value 'Jan ' to data type int.

7 Feb 2014 by Richard C Bishop

I believe the declaration of "@Period" as a DATETIME is skewing the data you think you are getting. If "@Period" is not going to be dynamic and will always be '2013/01/01' then I would make it a VARCHAR(15) data type. If it is a dynamic date, then try converting that date into the varchar format...

Floppy disk issue I need to fix this "help"

14 Feb 2018 by OriginalGriff

There are a couple of possible reasons - but none of them are good news. First, it could be an alignment problem - the tracks are narrow, and it doesn't take much to get real problems. Try a different drive and see if that does it. Second, your drive is faulty - they get banged, bounced, shaken...

Function Extensions Techniques 2: Tuples

9 May 2018 by JIANGWilliam

This is the second of three episodes to introduce considerations and techniques applied in Tuple classes in my open-sourced library functionExtensions.

A Business Intelligence Approach to Bowling

8 Mar 2018 by Mike Ellison

On data, context, class-like architecture in Javascript, and ten-pin bowling.

How to write a query in SQL to display max number of column's

20 Mar 2018 by Richard Deeming

Something like this: SELECT DH.DHid, DH.A, DH.B, DH.C, IsNull( ( SELECT TOP 1 DD.Remarks FROM DataDetail As DD WHERE DD.DHid = DH.DHid And DD.Remarks Is Not Null ORDER BY DD.DDid DESC ), ...

Program received signal SIGSEGV, segmentation fault ! ! what does this mean and how do I solve this?

19 Aug 2018 by OriginalGriff

Well... look at your code. printf("else it's working!!!!!!!!!!!!!!!!'\n"); while(t->link!=NULL) { t=t->link; (/*

I tried to make this algorithm to work in C++ but I'm not getting any proper solution.

15 Sep 2018 by OriginalGriff

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action. Try it yourself, you may find it is...

Why is arduino not transfering whole data through HC-06 bluetooth module like this and is there a "fix" ?

26 Sep 2018 by Dave Kreskowiak

Your code is written to expect an entire message in one "receive packet" but that's not how communication, over ANY network, works. Your receive code has to buffer whatever is gets and keeps on adding to the buffered content on subsequent receive events until a complete message has been...

How to get data from web api in c#windows application

15 Jan 2020 by phil.o

You should type "c# get web api data" in your favourite search engine, and follow the links and examples which it will provide to you. This is a quick answers forum, it is not meant to provide full tutorials on such large topics.

How can I sort 100 GB in 1 GB memory ?

29 Jan 2020 by phil.o

The concept you need to do your task is called External sorting[^].

How can I sort 100 GB in 1 GB memory ?

29 Jan 2020 by OriginalGriff

The first thing to do is to start by looking at what you have to sort: what does the file contain that needs sorting? What does it need sorting by? Think about it: if you have a stack of mixed banknotes on your desk, there are many ways to sort them: by denomination, by colour, by size, by...

MEAN Stack Development Technologies Supporting a Web Tool for Arcade Game Players Collaboration

10 Dec 2020 by André Marcos (Advisor), LaercioMBR

An overview of the development process of an online platform to facilitate community driven data cataloging and management.

Creating a Smart Hydrophone Processing System- Hardware

22 Feb 2021 by grilialex

In scientific projects, it is often needed to sample sounds from remote locations, for classification or other purposes. As data link rates may be low or unreliable, transmitting raw samples to inland processing centers may not be an option. An alternative is to do off-line processing in batches.

Connect ask and disconnect vs keep the connection permanently against the database server, this is the question?

31 Aug 2021 by OriginalGriff

Create the connection, open it, use it, close it. In C#, create the connection object in a using statement, and the system will close and dispose it when the object goes out of scope: using (SqlConnection con = new SqlConnection(strConnect)) ...

C language program for quick sort

13 Feb 2011 by OriginalGriff

Google is your friend: using "iteration for quick sort in C" pasted from your question gave > 100,000 hits. The top one washttp://khatri-krishna.tripod.com/cgans.htm[^]Learn to use Google: it is quicker than asking a question...

Socket programming between vb.net & linux

11 Mar 2011 by Sergey Alexandrovich Kryukov

This is quite possible, but to make it really easy I would suggest you use Mono on Linux (http://en.wikipedia.org/wiki/Mono_(software)[^]).You can do it without Mono, of course, but will spend considerable amount of time for mapping all data types, set aside possibility to do remoting. With...

Dynamic Data Master Page Filtering

31 Mar 2011 by cjb110

To get the filter to apply, I added the following to the LinqDataSource:Where the ControlID is the id of the control on the master page.This filters after a post back...which is a bit ugly, so...

Working with Table Adapter

9 Jun 2011 by CDP1802

You are probably working with typed datasets. If that is the case, the table adapters for your datasets will be generated by Visual Studio. The type of the table adapter is not known in your code, resulting in the error.That means that you did not define the typed dataset (and the...

WCF Service Application retain it's information

6 Jul 2011 by Mark Salsbery

Web services does not equal (!=) WCF. There's a variety of web services available besides WCF.WCF deals with communication between endpoints and doesn't deal with data and what you do with it once it gets to an endpoint. Data is often stored in databases like SQL server. You could...

Find and GET data from SQL Server Database

7 Jul 2011 by Espen Harlinn

This is a great place to start: ASP.NET Data Access Tutorials[^]You might take a look at the other material too:ASP.NET Web Forms[^][Update]Doing it like RaviRanjankr suggests works fine, but it will not allow you to take advantage of the databinding features of the platform. Going...

SQL Server database query Delete and Insert question

7 Jul 2011 by Espen Harlinn

"I am worried about if I insert and delete things 1000s of times, that it would eventually have the id number go off Bigint boundaries. Is this possible?"It certainly is - it'll take a while though - I'll be quite surprised if any of us is still around :)Best regardsEspen Harlinn

SQL Server database query Delete and Insert question

7 Jul 2011 by fjdiewornncalwe

A bigint is 8 bytes in size which means you will have a max value of 9,223,372,036,854,775,807. I think you'll be ok.

Data Entry page only in VB.Net /.ASP

25 Aug 2011 by TomSeemore

I have good skills and background with Visual Basic and writing SQL calls to an Access Database. I use Visual Studio 2010 and prefer to stick to VB as much as I can, unless I can find some code snippet to get me started if I need to use a different language.I have been asked by my employer...

Data Entry page only in VB.Net /.ASP

25 Aug 2011 by Simon_Whale

I would look here to start with if you want to learn about creating data entry pages MSDN Web Developer Samples[^]

Data Entry page only in VB.Net /.ASP

25 Aug 2011 by TheyCallMeMrJames

What you're talking about is very doable on many stacks. You should be able to find many samples around this.ASP.NET is certainly a quick route. FrontPage form parsing will be harder to write than a simple scaffolded MVC site.If you're looking at ASP.NET MVC and wondering if it seems...

Solution for water pot problem?

25 Aug 2011 by Simon Bang Terkildsen

Fill up the pots with water and wait for enough time to pass so there is only 2 liters of water left in the pots.We don't do your homework

Data Entry page only in VB.Net /.ASP

25 Aug 2011 by TomSeemore

So, I've spent most of the day reading the linked articles above and watching and working along with the video posted by Microsoft on MSDN Web Developer Samples. In the end, the project leads to data being entered in a Gridview and managed on the server side by that. This is all well and good,...

Can we able create stored procedure in Ms-access

24 Nov 2011 by Not Active

http://msaccessmemento.hubpages.com/hub/Stored_Procedure_in_MS_Access[^]

practises for database creating

28 Nov 2011 by Anuj Banka

For Normaliztion you should create seprate table for this.In future it will help you.Whn you have to use these types in multiple table.But again its depends upon your requirement also !!!

Extracting text (title, author, etc) from PDF to window form in C# (not metadat)

6 Dec 2011 by S V Saichandra

you can get samples from here:itextpdf.com/book/examples.phporTry this article:Creating PDF Tables using C# (.NET 2.0) and iTextSharp[^]

union and structure

8 Dec 2011 by Sergey Chepurin

It is called: Data structure padding.If you change the order of structure members this way:struct structure1{ int i;//4 char ch;//1+3 (padding) double d;//8};-you will get 16 instead of 24.Here structure padding is explained good enough: Structure padding in C