Pass HTML table to grid view C#

Question

0.00/5 (No votes)

See more:

hello everybody
i usea web browers control in my windows form i have html table in web page i lop in that table and get each cell value in need to pass each value to agridview till the first row finished then the second and so on this is my trial .

instead of message pass each string to each cell of grid till the first row finished and then the second row each row has four cells how it can be done ?

What I have tried:

HtmlElement table = webBrowser1.Document.GetElementById("Table1");
try
{
foreach (HtmlElement row in table.GetElementsByTagName("TR"))
{
HtmlElementCollection cells = row.GetElementsByTagName("td");
foreach (HtmlElement cell in cells)
{

String text = cell.InnerText;
if (!String.IsNullOrEmpty(text) && !String.IsNullOrWhiteSpace(text))
{
MessageBox.Show(text);

}
}
}
}
catch (ArgumentOutOfRangeException exc)
{

}

Posted 28-Aug-16 21:36pm

MR.alaa

Updated 6-Sep-16 0:38am

Add a Solution

Comments

Maciej Los 5-Sep-16 15:55pm

Sorry, what's your problem? You mentioned that you want to convert html table into grid view. What you mean?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pparya27 · Accepted Answer · 2016-09-06T00:38:00

As per your requirement I have written the following code snippet. It may help. Anyways why have you got such requirement?

I have used the following HTML file (testtable.html) :

HTML

<html>
<body>

<table border="1" id="mytable" width="300px">

<tr><td>16</td><td>17</td><td>18</td><td>19</td></tr>
<tr><td>32</td><td>34</td><td>36</td><td>38</td></tr>
<tr><td>48</td><td>51</td><td>54</td><td>57</td></tr>
<tr><td>64</td><td>68</td><td>72</td><td>76</td></tr>
<tr><td>80</td><td>85</td><td>90</td><td>95</td></tr>
</table>

</body>
</html>

PART 1 : Loading the HTML file in WebBrowser Control :

Method 1: by hosting it in any webserver :

C#

webBrowser1.Url = new Uri("http://10.10.10.10/testtable.html");

Method 2: by loading from a local html file :

C#

FileStream fs= File.Open(@"D:\Programming Bench\WindowsFormsApplication1\WindowsFormsApplication1\testtable.html",FileMode.Open);
webBrowser1.DocumentStream = fs;

PART 2 : Get data from WebBrowser Control and load to DataGridView

C#

private void btnGetDataFromWebBrowserCtrl_Click(object sender, EventArgs e)
       {
           HtmlElement mytable = webBrowser1.Document.GetElementById("mytable");

           DataTable dtData = new DataTable();
           dtData.Columns.Add("column1");
           dtData.Columns.Add("column2");
           dtData.Columns.Add("column3");
           dtData.Columns.Add("column4");
           dtData.AcceptChanges();

           DataRow dr = null;

           foreach (HtmlElement row in mytable.GetElementsByTagName("tr"))
           {
               dr = dtData.NewRow();
               HtmlElementCollection cells = row.GetElementsByTagName("td");
               for (int i = 0; i < cells.Count; i++)
               {
                   dr[i] = cells[i].InnerText;
               }
               dtData.Rows.Add(dr);
           }
           dtData.AcceptChanges();

           dataGridView1.DataSource = dtData;

       }

Hope this helps !!