how to construct a html table in console aaplication C#

Question

Hi, i want to construct a html table using console application C#

Vulpes · Answer

Well, you'll need a list of urls which are in the same order as the values themselves. For illustration purpose, I've used the same url (google) for all 17 values: using System; using System.Collections.Generic; using System.IO; using System.Xml.Linq; using System.Diagnostics; class Table { static void Main() { XElement table = new XElement("table"); table.Add(new XAttribute("border", "1")); table.Add(new XAttribute("style", "width:600px")); // in practice values would be loaded from database var values = new List { "Software Development", "IT Enabled Services(20)", "IT - Training Institute(10)", "IT - Hardware(20)", "Call Center(14)", "BPO", "ISP", "IT-HR Consultancy", "Bio Technology", "Web Hosting", "Web Services", "Telecom", "Software Re-seller", "Dot Com", "Networking", "Animation", "STPI" }; var urls = new List (); for(int i = 0; i { urls.Add("http://www.google.com"); } AddRows(table, values, urls); File.WriteAllText("mytable.html", table.ToString()); Process.Start("mytable.html"); // display in browser } static void AddRows(XElement table, List values, List urls) { int numRows = values.Count/3; int remCols = values.Count % 3; if (remCols > 0) numRows++; for(int i = 0; i { XElement tr = new XElement("tr"); if (i { tr.Add(new XElement("td", A(values[i * 3], urls[i * 3])), new XElement("td", A(values[i * 3 + 1], urls[i * 3 + 1])), new XElement("td", A(values[i * 3 + 2], urls[i * 3 + 2]))); } else if (remCols == 1) { tr.Add(new XElement("td", A(values[i * 3], urls[i * 3])), new XElement("td", ""), new XElement("td", "")); } else if (remCols == 2) { tr.Add(new XElement("td", A(values[i * 3], urls[i * 3])), new XElement("td", A(values[i * 3 + 1], urls[i * 3 + 1])), new XElement("td", "")); } table.Add(tr); } } static XElement A(string value, string url) { XElement a = new XElement("a", value); a.Add(new XAttribute("href", url)); return a; } }

Vulpes · Answer

OK, suppose you've loaded your column names (or whatever they are) from the database into a List . Here's how you can then generate and display the HTML table: using System; using System.Collections.Generic; using System.IO; using System.Xml.Linq; using System.Diagnostics; class Table { static void Main() { XElement table = new XElement("table"); table.Add(new XAttribute("border", "1")); table.Add(new XAttribute("style", "width:600px")); // in practice values would be loaded from database var values = new List { "Software Development", "IT Enabled Services(20)", "IT - Training Institute(10)", "IT - Hardware(20)", "Call Center(14)", "BPO", "ISP", "IT-HR Consultancy", "Bio Technology", "Web Hosting", "Web Services", "Telecom", "Software Re-seller", "Dot Com", "Networking", "Animation", "STPI" }; AddRows(table, values); File.WriteAllText("mytable.html", table.ToString()); Process.Start("mytable.html"); // display in browser } static void AddRows(XElement table, List values) { int numRows = values.Count/3; int remCols = values.Count % 3; if (remCols > 0) numRows++; for(int i = 0; i { XElement tr = new XElement("tr"); if (i { tr.Add(new XElement("td", values[i * 3]), new XElement("td", values[i * 3 + 1]), new XElement("td", values[i * 3 + 2])); } else if (remCols == 1) { tr.Add(new XElement("td", values[i * 3]), new XElement("td", ""), new XElement("td", "")); } else if (remCols == 2) { tr.Add(new XElement("td", values[i * 3]), new XElement("td", values[i * 3 + 1]), new XElement("td", "")); } table.Add(tr); } } }

Vulpes · Answer

Well, I'll show you how you can A to Z paging to the previous table (for simplicity all letters link to Amazon). To add a navigation button requires javascript and you should really then be using proper web development tools rather than trying to do this with a console application and LINQ to XML: using System; using System.Collections.Generic; using System.IO; using System.Xml.Linq; using System.Diagnostics; class Table { static void Main() { XElement html = new XElement("html"); XElement body = new XElement("body"); html.Add(body); XElement azTable = new XElement("table"); body.Add(azTable); azTable.Add(new XAttribute("border", "0")); azTable.Add(new XAttribute("style", "width:600px")); var azUrls = new List (); for(int i = 0; i { azUrls.Add("http://www.amazon.com/"); } XElement azTr = new XElement("tr"); for(int i = 0; i { string letter = "" + (char)(i + 65); azTr.Add(new XElement("td", A(letter, azUrls[i]))); } azTable.Add(azTr); XElement table = new XElement("table"); body.Add(table); table.Add(new XAttribute("border", "1")); table.Add(new XAttribute("style", "width:600px")); // in practice values would be loaded from database var values = new List { "Software Development", "IT Enabled Services(20)", "IT - Training Institute(10)", "IT - Hardware(20)", "Call Center(14)", "BPO", "ISP", "IT-HR Consultancy", "Bio Technology", "Web Hosting", "Web Services", "Telecom", "Software Re-seller", "Dot Com", "Networking", "Animation", "STPI" }; var urls = new List (); for(int i = 0; i { urls.Add("http://www.google.com/"); } AddRows(table, values, urls); File.WriteAllText("mytable.html", html.ToString()); Process.Start("mytable.html"); // display in browser } static void AddRows(XElement table, List values, List urls) { int numRows = values.Count/3; int remCols = values.Count % 3; if (remCols > 0) numRows++; for(int i = 0; i { XElement tr = new XElement("tr"); if (i { tr.Add(new XElement("td", A(values[i * 3], urls[i * 3])), new XElement("td", A(values[i * 3 + 1], urls[i * 3 + 1])), new XElement("td", A(values[i * 3 + 2], urls[i * 3 + 2]))); } else if (remCols == 1) { tr.Add(new XElement("td", A(values[i * 3], urls[i * 3])), new XElement("td", ""), new XElement("td", "")); } else if (remCols == 2) { tr.Add(new XElement("td", A(values[i * 3], urls[i * 3])), new XElement("td", A(values[i * 3 + 1], urls[i * 3 + 1])), new XElement("td", "")); } table.Add(tr); } } static XElement A(string value, string url) { XElement a = new XElement("a", value); a.Add(new XAttribute("href", url)); return a; } }

Raghavendra Joshi · Answer

Thanks for the above help.... I have another doubt. How do i create pagination dynamically at the bottom? For example: "first previous 1 2 3 4 5 next last"

Raghavendra Joshi · Answer

Thank you so much.... got the solution for the previous problem. I have another question where in i have to create a html grid in console application. for ex : just go through the below URL http://itdatahouse.com/A-Z/Bengaluru/Bengaluru_Software_Companies_A_1.htm

Vulpes · Answer

But, if you've generated these pages already, won't the appropriate table already appear when the page is displayed? If the url for a specific page always has a query string containing the same id, I don't really see the point of parsing it out unless you're somehow going to generate dynamic content from it or redirect to a further url.

Raghavendra Joshi · Answer

okay.... Suppose i have 2 cities related to one category i.e for example: "Bangalore" & "Hydrabadh" which are related to " software development" and "chennai" & "Delhi" related to "BPO" I should be able to generate pages for softwaredevelopment and BPO which should have table of related cities. For table reference: This table related to "software development" City Count Bengaluru 529 Hyderabad 1

Vulpes · Answer

Do you mean how can you access the page url from within the page you've redirected to itself? If you do, then you'd need to embed Javascript within the page to obtain the url and then parse out the id from the query string.

Raghavendra Joshi · Answer

Thank you soo much.... :) Now i have a table like as shown below Software Development IT Enabled Services(20) IT - Training Institute(10) IT - Hardware(20) Call Center(14) BPO ISP IT-HR Consultancy Bio Technology Web Hosting Web Services Telecom Software Re-seller Dot Com Networking Animation STPI If i click on software development it should redirect to its specific page by passing the ID Example: 1 Software Development 2 IT - Training Institute 3 IT - Hardware 4 Call Center 5 BPO 6 ISP 7 IT-HR Consultancy 8 Bio Technology 9 Web Hosting 10 Web Services 11 Telecom 12 Software Re-seller 13 Dot Com 14 Networking 15 IT Enabled Services 16 Animation 17 STPI now i have generated specific html pages like "software development.html", "bpo.html" etc i have passed its ID's in the URL ex: "software development.html?id=1", bpo.html?id=5" etc... MY question is How to access the id that has been passed while creating the page so tat i can display the related cities to the specific ID?? EX: i need to display a table as shown below City Count Bengaluru 529 Chennai 1 Hyderabad 1 the table is related to the ID which is passed from the URL

Raghavendra Joshi · Answer

Thank you so much for the help, it helped me a lot. I have another question. How do i give a link(anchor tag) to each items in the created table?? In the below shown example i should be able to click on "software development" which should redirects to "xyz.html" page. ex : Software Development IT Enabled Services(20) IT - Training Institute(10) IT - Hardware(20) Call Center(14) BPO ISP IT-HR Consultancy Bio Technology Web Hosting Web Services Telecom Software Re-seller Dot Com Networking Animation STPI Please help me this.

Raghavendra Joshi · Answer

I have a table as shown below in SQL database Software Development IT - Training Institute IT - Hardware Call Center BPO ISP IT-HR Consultancy Bio Technology Web Hosting Web Services Telecom Software Re-seller Dot Com Networking IT Enabled Services Animation STPI I want to write it in a table format i.e each row consits of 3 columns ex : Software Development IT Enabled Services(20) IT - Training Institute(10) IT - Hardware(20) Call Center(14) BPO ISP IT-HR Consultancy Bio Technology Web Hosting Web Services Telecom Software Re-seller Dot Com Networking Animation STPI

Vulpes · Answer

Although it's not really intended for the purpose, you can create an HTML table using LINQ to XML. For example, ignoring the CSS enhancements, we can create the simple table shown in this link: http://www.w3schools.com/html/html_tables.asp and display it in the default browser using the following C# console application: using System; using System.IO; using System.Xml.Linq; using System.Diagnostics; class Table { static void Main() { XElement table = new XElement("table"); table.Add(new XAttribute("border", "1")); table.Add(new XAttribute("style", "width:300px")); XElement tr = new XElement("tr"); tr.Add(new XElement("th", "Firstname"), new XElement("th", "Lastname"), new XElement("th", "Points")); XElement tr2 = new XElement("tr"); tr2.Add(new XElement("td", "Jill"), new XElement("td", "Smith"), new XElement("td", "50")); XElement tr3 = new XElement("tr"); tr3.Add(new XElement("td", "Eve"), new XElement("td", "Jackson"), new XElement("td", "94")); XElement tr4 = new XElement("tr"); tr4.Add(new XElement("td", "John"), new XElement("td", "Doe"), new XElement("td", "80")); XElement tr5 = new XElement("tr"); tr5.Add(new XElement("td", "Adam"), new XElement("td", "Johnson"), new XElement("td", "67")); table.Add(tr, tr2, tr3, tr4, tr5); File.WriteAllText("mytable.html", table.ToString()); Process.Start("mytable.html"); // display in browser } }