Asp.net Accordion Control With Sql Server Connectivity

The Accordion is a web control that you bid on multiple disks and displays them one at a time allows. It's like several CollapsiblePanel where only one can be expanded at a time.

How to populate a database from the SQL Server data, combined with the accordion control

?

I tried the internet but only found something good that is so friendly.

I decided to make a code for this.
?

First create tables in the database?

CREATE TABLE [dbo].[Category](

[CategoryID] [int] IDENTITY (1,1) NOT NULL,

????? [CatName] [nvarchar](50) NULL,

????? [CatDesc] [nvarchar](255) NULL

)

?

CREATE TABLE [dbo].[SubCategory](

[SubCategoryID] [int] IDENTITY (1,1) NOT NULL,

????? [CategoryID] [int] NOT NULL,

????? [SubCategoryName] [varchar](30) NULL

)

Inserting values for Main Category Table

?

Introduction to class (CatName, CatDesc) Values ( "Hospital", "Hospital")

Go

Insert Into Category (CatName,CatDesc) Values (‘School’,‘School’)

Go

Insert Into Category (CatName,CatDesc) Values (‘Hotel’,‘Hotel’)

?

Select * from Category

?

Result:?

?

?

For complete article Please visit http://blog.joggee.com/?p=162 Posted in: asp.net| Tags: Control time web sql asp server connectivity accordion