C# datatable

13y1.9kVisual Basic .NET

Hello

I want create datatable where need to add two lines of columns.

Example :

First Column : Name Surname

rows Jon Trav

Jake Xcs

Second column : BirthDay age

rows xxxxxx yyy

xxxxxx vvv

thanks a lot

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Although it's not something I'd recommend one thing you could do is to create 2 'combined' columns.

The reason I wouldn't recommend it is that you might need to split the column values for display purposes if the spacing wasn't quite right and you'd need to use the string type for the second column as dates and integers are not compatible with each other. This might make life difficult if you wanted to manipulate the individual values.

Anyway, the code for this approach would be as follows. The output would be the same as before:

using System;
using System.Data;

class Test
{
static void Main()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Name_Surname"));
dt.Columns.Add(new DataColumn("Birthday_Age"));
dt.Rows.Add(new object[]{"Jon Trav", "01/01/1990 23"});
dt.Rows.Add(new object[]{"Jake Xcs", "01/01/1991 22"});

Console.WriteLine("Name Surname");
Console.WriteLine("---- -------");
foreach(DataRow dr in dt.Rows)
Console.WriteLine("{0}", dr["Name_Surname"]);
Console.WriteLine();

Console.WriteLine("Birthday Age");
Console.WriteLine("---------- ---");
foreach(DataRow dr in dt.Rows)
Console.WriteLine("{0}", dr["Birthday_Age"]);
Console.ReadKey();
}
}
Vulpes13y ago
Your DataTable still needs to include 4 columns as there are four separate data items.

However, you then use or display those columns in any way you like.

For example (using a console app for simplicity) you could do this:

using System;
using System.Data;

class Test
{
static void Main()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Name"));
dt.Columns.Add(new DataColumn("Surname"));
dt.Columns.Add(new DataColumn("Birthday", typeof(DateTime)));
dt.Columns.Add(new DataColumn("Age", typeof(int)));
dt.Rows.Add(new object[]{"Jon", "Trav", new DateTime(1990, 1, 1), 23});
dt.Rows.Add(new object[]{"Jake", "Xcs", new DateTime(1991, 1, 1), 22});

Console.WriteLine("Name\tSurname");
Console.WriteLine("----\t-------");
foreach(DataRow dr in dt.Rows)
Console.WriteLine("{0}\t{1}", dr["Name"], dr["Surname"]);
Console.WriteLine();

Console.WriteLine("Birthday\tAge");
Console.WriteLine("--------\t---");
foreach(DataRow dr in dt.Rows)
Console.WriteLine("{0}\t{1}", ((DateTime)dr["Birthday"]).ToString("dd/MM/yyyy"), dr["Age"]);
Console.ReadKey();

}
}

The output should be:

Name Surname
---- -------
Jon Trav
Jake Xcs

Birthday Age
-------- ---
01/01/1990 23
01/01/1991 22
13y ago
Hello Vulpes

in Your answer there are 4 columns.But I need to add tow lines of columns.
first line Name,surname - and its rows.
thens second line birthday,age - and its rows.
as shown below

First Column : Name Surname
rows Jon Trav
Jake Xcs

Second column : BirthDay age
rows xxxxxx yyy
xxxxxx vvv
Vulpes13y ago
Try:

DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Name"));
dt.Columns.Add(new DataColumn("Surname"));
dt.Columns.Add(new DataColumn("Birthday", typeof(DateTime)));
dt.Columns.Add(new DataColumn("Age", typeof(int)));
dt.Rows.Add(new object[]{"Jon", "Trav", new DateTime(1990, 1, 1), 23});
dt.Rows.Add(new object[]{"Jake", "Xcs", new DateTime(1991, 1, 1), 22});