主题：动态Datalist的新问题

此主题相关图片如下：未命名.jpg


左边的目录树, 后面是动态的Datalist

实现目标: 双击左边的省市, 右边的Datalist动态显示相关省市的客户

我设置了NodeMouseDoubleClick的代码如下:

Dim 省市  As String = e.Form.Controls("TreeView1").Value
Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.CommandText = "Select * From {客户} Where [省市] = '" & 省市 & "'"
dt = cmd.ExecuteReader() '生成统计表
Dim dst As WinForm.DataList = e.Form.Controls("DataList1")
dst.DataTable = dt
dst.Build()

代码出错,麻烦狐老爸看一下,谢谢!

现在我设置成这样,可是双击节点以后,Datalist中未出现任何数据,帮忙再看一下,谢谢!

Dim 省市 As String = e.Form.Controls("TreeView1").SelectedNode.Text
Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.CommandText = "Select * From {客户} Where [省市] = '" & 省市 & "'"
dt = cmd.ExecuteReader() '生成统计表
Dim dst As WinForm.DataList = e.Form.Controls("DataList1")
dst.DataTable = dt
dst.Build()



此主题相关图片如下：未标题-2.jpg

这个跟外部数据有关吗?我在本地表上是可以的,但是在SQL外部数据表上就不行,为什么啊

经过测试,这个跟外部SQL数据表有关. 请求帮助,谢谢!

能提示一下吗?

Dim 省市 As String = e.Form.Controls("TreeView1").SelectedNode.Text
Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.CommandText = "Select * From {客户} Where [省市] = '" & 省市 & "'"
dt = cmd.ExecuteReader() '生成统计表
Dim dst As WinForm.DataList = e.Form.Controls("DataList1")
dst.DataTable = dt
dst.Build()

是这样吗？系统提示

此主题相关图片如下：未标题-2.jpg



Dim 省市 As String = e.Form.Controls("TreeView1").SelectedNode.Text
Dim cmd As New SQLCommand
Dim dt As DataTable
Cmd.Connectio nName = "SystemData"
cmd.CommandText = "Select * From {客户} Where [省市] = '" & 省市 & "'"
dt = cmd.ExecuteReader() '生成统计表
Dim dst As WinForm.DataList = e.Form.Controls("DataList1")
dst.DataTable = dt
dst.Build()