kkabbara
Posts: 14
|
Posted: 05/14/2006, 7:24 PM |
|
Greetings,
Not sure if anyone can help, I am testing a third party control and I'm having difficulty finding out how to bind data to the control, the code is below can anyone give pointers, TIA ?
Dim NewDao As DataAccessObject = Settings.Connection1DataAccessObject
Dim Sql As String = "SELECT * FROM tblPanelMenu"
Dim adpPanelBar As New SqlCommand(Sql, NewDao)
Dim dsPanelBar As New DataSet
adpPanelBar.Execute()
PanelBarLeftNav.DataFieldID = "ID"
PanelBarLeftNav.DataFieldParentID = "ParentID"
PanelBarLeftNav.DataSource = dsPanelBar
PanelBarLeftNav.DataBind()
|
|
|
kkabbara
Posts: 14
|
Posted: 05/14/2006, 7:46 PM |
|
FYI:
This was the original example, but I'm connecting to a SQL database instead of MSACCES
Dim OldDbCon As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Request.MapPath("Panelbar.mdb") + ";User ID=;Password=;")
Dim adpPanelBar As New OleDbDataAdapter("SELECT * FROM Panelbar", OldDbCon)
Dim dsPanelBar As New DataSet()
adpPanelBar.Fill(dsPanelBar)
RadPanelbar1.DataFieldID = "ID"
RadPanelbar1.DataFieldParentID = "ParentID"
RadPanelbar1.DataSource = dsPanelBar
RadPanelbar1.DataBind()
|
|
|
|