Building a Questionnaire with the DevExpress ASPxGridView control

A number of people have requested the source code that was used in the recent webinar "DevExpress ASP.NET GridView: Build a Questionnaire for Your Website". A zip file containing the project can be downloaded from here, however, there are a few things to point out. The solution contains references to the 14.1.8 version of the DevExpress component libraries, if you are running an earlier version then you will need to update the web.config and designer files accordingly. The SQL database that was used for the setup of 'Questions' was named "MyWeb" and features a table called "cQuestions", you will need to create this on your own instance of SQL Express (or similar)

CREATE TABLE [dbo].[cQuestions](
	[Id] [INT] IDENTITY(1,1) NOT NULL,
	[QNo] [FLOAT] NULL,
	[Question] [VARCHAR](1024) NULL,
	[IsSection] [BIT] NULL,
 CONSTRAINT [PK_cQuestions] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

When creating items in the Question Setup GridView, remember that the "Header" should be an integer or whole number, and the question should be a part, for example:

1  Your Experience (Heading)

1.1 Have you done development work prior to this webinar (Question)

Free DevExpress Products - Get Your Copy Today