C# datatable

Question

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

Vulpes · Answer

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(); } }

Vulpes · Answer

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	Surname); Console.WriteLine(----	-------); foreach(DataRow dr in dt.Rows) Console.WriteLine({0}	{1} dr[Name] dr[Surname]); Console.WriteLine(); Console.WriteLine(Birthday	Age); Console.WriteLine(--------	---); foreach(DataRow dr in dt.Rows) Console.WriteLine({0}	{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

Ilkin Turk · Answer

Hello Vulpes in Your answer there are 4 columns.But I need to add tow lines of columns. first line Namesurname - and its rows. thens second line birthdayage - and its rows. as shown below First Column : Name Surname rows Jon Trav Jake Xcs Second column : BirthDay age rows xxxxxx yyy xxxxxx vvv

Vulpes · Answer

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});