vb.net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load
Dim cn As String = "Data Source=mysqlserver;Initial
Catalog=mydatabase;User ID=myuser;PWD=password"
Using conn As New SqlConnection(cn)
Dim cmd As New SqlCommand("sp_paislocal", conn)
cmd.CommandType = CommandType.StoredProcedure
Dim ad As New SqlDataAdapter(cmd)
Dim ds As New DataSet()
ad.Fill(ds)
ds.Relations.Add(New DataRelation("pais", ds.Tables
(0).Columns("pais"), ds.Tables(1).Columns("pais")))
MasterRep.DataSource = ds.Tables(0)
MasterRep.DataBind()
End Using
End Sub
Protected Sub MasterRep_ItemDataBound(ByVal sender As Object,
ByVal e As RepeaterItemEventArgs)
If e.Item.ItemType = ListItemType.Item OrElse e.Item.ItemType
= ListItemType.AlternatingItem Then
Dim drv As DataRowView = TryCast(e.Item.DataItem,
DataRowView)
Dim ChildRep As Repeater = TryCast(e.Item.FindControl
("ChildRep"), Repeater)
ChildRep.DataSource = drv.CreateChildView("pais")
ChildRep.DataBind()
End If
End Sub
On 23 Nov, 11:12, CreativeMind <aftab.pu...@gmail.com> wrote:
> hi all!
> i m using treeview of jquery..
> if i provide the formatted html like ul,li,ul,li,/li,/ul,/li,/ul,
> the plugin works perfect.
>
> now i don't have ul,li rather, i've a datatable or collection
> which contains fields Id,name,parentId,depthlevel
>
> how can i generate ul,li list from these fields or
> is there any way to direct bind data with jquery plugin.
> u can find pluginhttp://docs.jquery.com/Plugins/Treeview
> thanx
