I think you mean like this example. I'm not used to adding all methods behind eachother as you do with the nodes object. Maybe there is also a way to add the server to the list, but I would do it this way:
string Url = "http://" + TextBox1.Text + "/logs/Logfile.html";
HtmlAgilityPack.HtmlWeb WebPage = new HtmlAgilityPack.HtmlWeb();
HtmlAgilityPack.HtmlDocument document = WebPage.Load(Url);
var table = new DataTable("Sample Table");
table.Columns.Add("Entry", typeof(string));
table.Columns.Add("Date", typeof(string));
table.Columns.Add("Time", typeof(string));
table.Columns.Add("Description", typeof(string));
table.Columns.Add("Server", typeof(string));
var nodes = document.DocumentNode.SelectNodes("//table[7]/tr[position() > 1]");
nodes
.Skip(1)
.Select(tr => tr.Elements("td").Select(td => td.InnerText.Trim())
.ToArray())
.ToList()
.ForEach(row => table.Rows.Add(row));
for(DataRow row in table.Rows)
row["Server"] = TextBox1.Text;
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
conn.Open();
using (SqlBulkCopy copy = new SqlBulkCopy(conn))
{
copy.DestinationTableName = "LogEntries";
copy.WriteToServer(table);
conn.Close();
}
}