主题：老大,帮我看个SQL语句的问题

Dim Val As String
If InputValue(Val, "保存设置", "请输入要保存设置的名字:") Then
    Dim tr As WinForm.TreeView
    Dim nd As WinForm.TreeNode
    tr = e.Form.Controls("TreeView1")
    nd = Tr.Nodes.Add(Val,Val)
    Dim dt As DataTable = DataTables(e.Form.Name & "_Table1")
    Dim Str As String
    For Each dr As DataRow In dt.DataRows
        Str = Str & "|" & dr("公式")
    Next
    Dim cmd As New SQLCommand
    cmd.C
    cmd.CommandText = "Update {保存设置] Set [保存设置] = '" & nd.Name & "',[保存字符串] ='" & Str & "'"
    cmd.ExecuteNonQuery
End If

     保存字符串提示说,缺少:

此主题相关图片如下：pqjflodem()wj(wrbtep3m.jpg

  是什么原因?

这样试试

Str = Str & " " & dr("公式")

此主题相关图片如下：pqjflodem()wj(wrbtep3m.jpg

   值就是这样的呀,不允许写入这种的吗?

   老大,我用  ,   空格都试过,不行!

MessageBox.show("Update {保存设置] Set [保存设置] = '" & nd.Name & "',[保存字符串] ='" & Str & "'")

至少这个：{保存设置]

应该改为：{保存设置}

Dim Val As String
If InputValue(Val, "保存设置", "请输入要保存设置的名字:") Then
Dim tr As WinForm.TreeView
Dim nd As WinForm.TreeNode
tr = e.Form.Controls("TreeView1")
nd = Tr.Nodes.Add(Val,Val)
Dim dt As DataTable = DataTables(e.Form.Name & "_Table1")
Dim Str As String
For Each dr As DataRow In dt.DataRows
Str = Str & "|" & dr("公式")
Next

Str = （"*" & str).Replace("|And"," And ").Replace("*|","")
Dim cmd As New SQLCommand
cmd.C
cmd.CommandText = "Update {保存设置} Set [保存设置] = '" & nd.Name & "',[保存字符串] ='" & Str & "'"
cmd.ExecuteNonQuery
End If

一早,lxl老大帮我搞定了,意思跟程老大的差不多.

呵呵，昨晚在群里面都写好了，没发出去，正好看到您在论坛发帖子了，后来考虑到您的控件里面的值需要看看，否则可能无法一次性解决到位！