正则排列后写入数据库的问题

Question

                       web2 = htmlDoc.body.outerHTML.Substring(0);                        string result = Regex.Match(web2, @"(?is)(?<=<pre[^>]*?>).*?(?=</pre>)").Value;
                        var list = from x in Regex.Split(result, @"\n")
                                   let temp = Regex.Split(x, "\\s+")
                                   where temp.Count() > 1
                                   group x by new { a = temp[0], b = temp[1] } into g
                                   select new
                                  {                                       a = g.Key.a,
                                       b = g.Key.b,
                                       c = g.Sum(n => Convert.ToInt32(Regex.Split(n, "\\s+")[2])),
                                       d = g.Sum(n => Convert.ToInt32(Regex.Split(n, "\\s+")[3]))
                                   };
                        dataGridView1.Rows.Clear();
                        list.ToList().ForEach(l => dataGridView1.Rows.Add(l.a, l.b, l.c, l.d));这一段怎么改成把l.a, l.b, l.c, l.d这四个参数写入数据库

Answer 1

这个只需要修改最后一句：foreach(va l in list)
{
  string  sql =string.Formate(" insert into tb values('{0}','{1}','{2}','{3}')",l.a, l.b, l.c, l.d);
}

Answer 2

foreach(va l in list)
{
  string sql =string.Formate(" insert into tb values('{0}','{1}','{2}','{3}')",l.a, l.b, l.c, l.d);
}va未找到类型或命名空间Formate tring不包含formate定义

Answer 3

是不是应写成
foreach (var l in list)
                        {
                            string sql = string.Format(" insert into tb values('{0}','{1}','{2}','{3}')", l.a, l.b, l.c, l.d);
                        }