1.想用DataList帮定数据,有张表
ID TYPE name
1 1 ad
2 2 db
3 3 asd
4 1 ad
....................
类似这样的数据,然后想绑到datalist上去,每行5条记录,分别记录相同类型的,不知select语句这么写
2.这个dropdownlist的onchange事件我哪写错了,怎么不执行跳转
Dim webLink As New BLL.WebLink.WebLink
Dim webArray As DataTable
webArray = webLink.GetWebLink.Tables(0)
Dim i As Int32
For i = 0 To webArray.Rows.Count - 1
Dim item As ListItem = New ListItem(webArray.Rows(i)(1), webArray.Rows(i)(2))
Me.yqlj.Items.Add(item)
Next
Me.yqlj.Attributes.Add("onchange()", "javascript:window.open(this.value,'_blank')")
...
我查看原文件看到value的值是我要的URL 怎么跳转不了,请各位给些参考思路之类的 谢谢了
ID TYPE name
1 1 ad
2 2 db
3 3 asd
4 1 ad
....................
类似这样的数据,然后想绑到datalist上去,每行5条记录,分别记录相同类型的,不知select语句这么写
2.这个dropdownlist的onchange事件我哪写错了,怎么不执行跳转
Dim webLink As New BLL.WebLink.WebLink
Dim webArray As DataTable
webArray = webLink.GetWebLink.Tables(0)
Dim i As Int32
For i = 0 To webArray.Rows.Count - 1
Dim item As ListItem = New ListItem(webArray.Rows(i)(1), webArray.Rows(i)(2))
Me.yqlj.Items.Add(item)
Next
Me.yqlj.Attributes.Add("onchange()", "javascript:window.open(this.value,'_blank')")
...
我查看原文件看到value的值是我要的URL 怎么跳转不了,请各位给些参考思路之类的 谢谢了
去掉括号
2,
Dim webLink As New BLL.WebLink.WebLink
Dim webArray As DataTable
webArray = webLink.GetWebLink.Tables(0)
Dim i As Int32
For i = 0 To webArray.Rows.Count - 1
Dim item As ListItem = New ListItem(webArray.Rows(i)(1), webArray.Rows(i)(2))
Me.yqlj.Items.Add(item)
Next
Me.yqlj.Attributes.Add("onchange", "javascript:window.open(this.value,'_blank')")
改为
Me.yqlj.Attributes.Add("onchange", "javascript:window.open(this.value,'_blank')")
去掉括号呀!
Me.yqlj.Attributes.Add("onchange", "javascript:window.open(this.value,'_blank');")
SELECT name FROM TABLE WHERE TYPE=1
UNION ALL
SELECT ''FROM TABLE
UNION ALL
SELECT ''FROM TABLE
UNION ALL
SELECT ''FROM TABLE
UNION ALL
SELECT ''FROM TABLE
UNION ALL
SELECT ''FROM TABLE
SELECT name FROM TABLE WHERE TYPE=2
UNION ALL
SELECT ''FROM TABLE
UNION ALL
SELECT ''FROM TABLE
UNION ALL
SELECT ''FROM TABLE
UNION ALL
SELECT ''FROM TABLE
UNION ALL
SELECT ''FROM TABLE
SELECT name FROM TABLE WHERE TYPE=3
UNION ALL
SELECT ''FROM TABLE
UNION ALL
SELECT ''FROM TABLE
UNION ALL
SELECT ''FROM TABLE
UNION ALL
SELECT ''FROM TABLE
UNION ALL
SELECT ''FROM TABLE
datalist的columns=5
2 Me.yqlj.Attributes.Add("onchange()", "javascript:window.open("+this.value"+",'_blank')")