how to bind questions and answers from different tables

Balwant Singh

i have two tables one is having questions and another is having answers how to bind the questions in asp.net web form with which control and how to achive functionality like

http://justtyari.com/

how to create db and how to bind this in web form i am totally confused.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bidyasagar Mishra7y ago
QUESTION TABLE STRUCTURE:
CREATE TABLE [dbo].[QuestionTable](
    [QuestionId] [int] IDENTITY(1,1) NOT NULL,
    [QuestionName] [nvarchar](max) NULL,
CONSTRAINT [PK_QuestionTable] PRIMARY KEY CLUSTERED
(
    [QuestionId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
ANSWER TABLE STRUCTURE:
CREATE TABLE [dbo].[AnswerTable](
    [AnswerId] [int] IDENTITY(1,1) NOT NULL,
    [QuestionId] [int] NULL,
    [Answer] [nvarchar](max) NULL,
CONSTRAINT [PK_AnswerTable] PRIMARY KEY CLUSTERED
(
    [AnswerId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Jignesh Kumar7y ago
Hi,

You can use datalist control to achieve this functionality.
Balwant Singh7y ago
Its ok i use Join in both table but i am asking how should it on asp.net web form using which control e.g. repeater,gridview etc?
Jignesh Kumar7y ago
Hi Balwant,

Please find below link where you can find some useful help,
https://archive.codeplex.com/?p=onlinequiz
Piyush Pansuriya7y ago
Question Table
Column 1 : QuestionId int primary key
Column 2 : Question nvarchar(max)

Answer Table
Column 1 : AnswerId int Primary key
Column 2 : QuestionId int foreign key
Column 3 : Answer nvarchar(max)

As per above table format you can join your answers with question using foreign key.
Rajanikant Hawaldar7y ago
Hi Dear, in second table you should have foreign key so you can join table1 with table2 using table1's primary key ID or serialnumber column and table2 foreign key ID or serialnumber column, bind it to Gridview , it's simple don't complicate yourself let me know if you still need help Thanks