|
Imports System
Imports System.Data
Imports System.Data.SqlClient
Partial Class DataBind
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
'Opens a connection to Database
Dim oConn As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ToString())
oConn.Open()
'Create Adapter and Fill Dataset
Dim oAdapter As New SqlDataAdapter("SELECT * FROM SelfReferenceTable", oConn)
Dim oDs As New DataSet
oAdapter.Fill(oDs)
'Close Connection
oConn.Dispose()
oConn = Nothing
'Close Adapter
oAdapter.Dispose()
oAdapter = Nothing
TestCtrl.DataFieldID = "ID"
TestCtrl.DataFieldParentID = "ParentID"
TestCtrl.DataTextField = "Text"
TestCtrl.DataSource = oDs
TestCtrl.DataBind()
End If
End Sub
End Class
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
Bassam Saoud is a software developer with more then 6+ years of experience. He has masters in Computer Science from American University of Technology and is currently doing Masters in Business Administration at Colorado Heights University. He started Programming with C++ and VB and now working with ASP.NET VB.NET/C#, SQL Server 2000/2005.
His interests are mainly politics, Basketball and Traveling.