title: Parse HTML table into Xamarin usable data format
body: <p>I'm writing a Xamarin app which has a function to grab some data from an HTML table. I want to then display this data somehow in my app; at the moment I'm thinking a ListView is the way to go but I'm open to alternatives.</p>
  
  <p>In my web-scraping prototype I simply grabbed the HTML table using HtmlAgility and then iterated over the rows and inserted them into a <code>DataTable</code>:</p>
  
  <pre class="lang-cs prettyprint-override"><code>                foreach (HtmlNode row in table.SelectNodes("tr"))
                  {
                      DataRow dr = dt.NewRow();
                      int counter = 1;
  
                      foreach (HtmlNode cell in row.SelectNodes("td"))
                      {
                          switch (counter)
                          {
                              case 1:
                                  dr["Column1"] = cell.InnerText;
                                  break;
                              case 2:
                                  dr["Column2"] = cell.InnerText;
                                  break;
                              case 3:
                                  dr["Column3"] = cell.InnerText;
                                  break;
                              case 4:
                                  dr["Column4"] = cell.InnerText;
                                  break;
                              case 5:
                                  dr["Column5"] = cell.InnerText;
                                  break;
                              case 6:
                                  dr["Column6"] = cell.InnerText;
                                  break;
                              case 7:
                                  dr["Column7"] = cell.InnerText;
                                  break;
                          }
                          counter++;
                      }
                      dt.Rows.Add(dr);
                  }
  </code></pre>
  
  <p>I don't think using a DataTable is very sensible for a mobile application (or even possible?).</p>
  
  <p>Currently I'm thinking I should use SQLite-Net to create a local database and insert records from my HTML table into my database table.</p>
  
  <p>Is this a sensible approach, and how would I go about doing that with SQLite?</p>