使用table.select过滤数据行

Question

我遵循[DataTable.Select Method1 ]对表进行排序和排序。然而，我得到了错误“语法错误:缺少'Number‘运算符之后的操作数”。我在网上搜索了一下，仍然找不到哪里出了问题。有人能告诉我怎么修吗？提前谢谢。

下面是我的代码：

    Dim Table As DataTable = New DataTable
    Table.Columns.Add("Week Number", GetType(Integer))
    Table.Columns.Add("Date", GetType(Date))

    Dim newRow1 As DataRow = Table.NewRow()
    newRow1("Week Number") = 52
    newRow1("Date") = "1979, 12, 31"
    Table.Rows.Add(newRow1)

    Dim newRow2 As DataRow = Table.NewRow()
    newRow2("Week Number") = 1
    newRow2("Date") = "1980, 1, 3"
    Table.Rows.Add(newRow2)

    Dim expression As String = "Week Number =1"
    Dim sortOrder As String = "Date ASC"
    Dim foundRows As DataRow()
    foundRows = Table.Select(expression, sortOrder)

2

Answer 1

如果列名包含空格，则需要将整个名称括在方括号中，以避免混淆解析器

Dim expression As String = "[Week Number] =1"
Dim sortOrder As String = "Date ASC"
Dim foundRows As DataRow()
foundRows = Table.Select(expression, sortOrder)