主题：如何判断视图中的某列是否是日期列?

可以使用sqlcommand先获取一个空的临时表

        Dim sql,flt As String

        '---加载表结构进来方便判断日期列

        sql = "se lect * from uv_sc001 where _identify < 0"

        Dim cmd As New SQLCommand

        cmd.ConnectionName = Mydata

        cmd.CommandText = sql

        Dim dt As DataTable = cmd.ExecuteReader()

       

        Dim Cls() As String = dr("FindCols").split("\")

        For i As Integer = 0 To Cls.Length -1

            If flt > "" Then

                flt = flt & " or "

            End If

            If dt.dataCols(Cls(i)).IsDate Then  '将数值或日期转换为字符(日期列判断必须要先加入表结构否则出错)

                flt = flt & " Convert(" & Cls(i) & ",'System.String') like " & txt

            Else

                flt = flt & Cls(i) & " like " & txt

            End If

        Next

直接加载视图执行时如果有日期列就会显示错误:

"类型 交货日期 不是已定义的系统类型."

应该怎么办?

我改成

flt = flt & " Convert(Nvarchar," & Cls(i) & ",120) like " & txt

就可以了,原来那样不知道为何不对?