关于repeater控件绑定数据的问题,高分在线等!!!
Sub databaseopen()
Dim connstr As String = System.Configuration.ConfigurationManager.ConnectionStrings("MyConn").ConnectionString
Conn = New OleDbConnection(connstr)
Conn.Open()
End Sub
Dim sql1 As String = "select top 6 * from tree_info where classid='" & 1 & "' and url is not null order by shijian desc"
Dim ds1 As DataSet = New DataSet
Dim adaptershow As OleDbDataAdapter = New OleDbDataAdapter(sql1, Conn)
adaptershow.Fill(ds1, "tree_info")
Repeater1.DataSource = ds1.Tables("tree_info")
Repeater1.DataBind()
上面是从单个表里获取数据然后绑定到repeater里，如果现在想从两个连接的表里获取数据，然后帮定到repeater里，那该怎么办？
tree_info表的字段是：nodename,url,classid,shijian
ziyuan表的字段是：filename,url,imgfile,shijian,who
两个表是通过url来连接的，url字段在两个表都是唯一的，代码用红色显示的部分怎么写？
[解决办法]
加载到dataset中然后进行数据关联:
Dim sR As DataRelation
dSet = GetDataSet("Select Id,Id+':'+Ms As Ms From Pricever0;No1,No1+':'+Mc ;Select Id,No1 As 门店编号,Ms As 描述,No1Key As 所属类 From Pricever1", New String() {"Pv0", "Pv1"})
sR = New DataRelation("Pv", dSet.Tables("pv0").Columns("id"), dSet.Tables("pv1").Columns("id"), False)
dSet.Relations.Clear()
dSet.Relations.Add(sR)
