主题：老大,帮我看个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

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

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