AJAX_Accordion数据动态绑定

private void AccordionDataBind()
     {
         AccordionPane pan = new AccordionPane();
         LinkButton lbtn = new LinkButton();
         HyperLink hlink = new HyperLink();
         string sKey = "";
         string sSql = "SELECT CategoryID, CategoryName, Description FROM Categories";
         string sConnstr = "Server=.;Database=northwind;uid=sa;pwd=";

         SqlConnection conn = new SqlConnection(sConnstr);
         conn.Open();
     
         SqlCommand cmd=new SqlCommand(sSql,conn);

         SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
         SortedList slarr = new SortedList();
         while (sdr.Read())
         {
             slarr.Add(sdr.GetInt32(0), sdr.GetString(1));
         }
         sdr.Close();

         for (int i = 1; i < slarr.Count; i++)
         {
             pan = new AccordionPane();
             lbtn = new LinkButton();
             lbtn.Text = slarr[i].ToString();
             pan.HeaderContainer.Controls.Add(lbtn);

             sKey = slarr.GetKey(i - 1).ToString();

             sSql = string.Format("SELECT [ProductID], [ProductName], [SupplierID], [CategoryID] FROM [Products] WHERE ([CategoryID] = {0})", sKey);
             SqlDataAdapter sda = new SqlDataAdapter(sSql, sConnstr);

             DataSet ds = new DataSet();
             sda.Fill(ds);

             foreach (DataRow dr in   ds.Tables[0].Rows)
             {
                 hlink = new HyperLink();
                 hlink.Text = dr["ProductName"].ToString() + "<br />";
                 hlink.NavigateUrl = string.Format("default.aspx?id={0}",dr["ProductID"].ToString());
                 //hlink.Target = "_Bank";
                 //lbtn = new LinkButton();
                 //lbtn.Text = dr["ProductName"].ToString() + "<br />";
                 //lbtn.CommandName = "link";
                 //lbtn.CommandArgument = dr["ProductID"].ToString();
                 pan.ContentContainer.Controls.Add(hlink);
             }

             this.Accordion1.Panes.Add(pan);

         }      
     }

 

转载于:https://www.cnblogs.com/bool/archive/2010/12/16/1907615.html