RadPanelBar for ASP.NET
Contents
SQL database and SqlDataAdapter Send comments on this topic.
See Also
Data Binding > SQL database and SqlDataAdapter

Glossary Item Box

The idea behind this topic is similar to the Access database and OleDbDataAdapter and DataTable, DataSet or DataView topics. We create a DataSet from a table in an SQL database and bind it to Telerik RadPanelBar.

C# Copy Code
protected void Page_Load(object sender, EventArgs e)
{
   if (!Page.IsPostBack)
   {
       SqlDataAdapter adapter = new SqlDataAdapter("Select * from Table1", @"Data Source=.\SQLEXPRESS;
       AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;
       Connect Timeout=30;User Instance=True");
       DataSet links = new DataSet();
       adapter.Fill(links);
       RadPanelBar1.DataSource = links;
       RadPanelBar1.DataFieldID = "ID";
       RadPanelBar1.DataFieldParentID = "ParentID";
       RadPanelBar1.DataTextField = "Text";
       RadPanelBar1.DataNavigateUrlField = "URL";
       RadPanelBar1.DataBind();
   }
}
VB.NET Copy Code
Protected Sub Page_Load(sender As Object, e As EventArgs)
   If Not Page.IsPostBack Then
      Dim adapter As New SqlDataAdapter("Select * from Table1", "Data Source=.\SQLEXPRESS;
                                        AttachDbFilename=|DataDirectory|Database.mdf;
                                        Integrated Security=True;
                                        Connect Timeout=30;User Instance=True")
      Dim links As New DataSet()
      adapter.Fill(links)
      RadPanelBar1.DataSource = links
      RadPanelBar1.DataFieldID = "ID"
      RadPanelBar1.DataFieldParentID = "ParentID"
      RadPanelBar1.DataTextField = "Text"
      RadPanelBar1.DataNavigateUrlField = "URL"
      RadPanelBar1.DataBind()
   End If
End Sub 'Page_Load

See Also