how to bind questions and answers from different tables

Question

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.

Piyush Pansuriya · Answer

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 Hawaldar · Answer

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

Bidyasagar Mishra · Answer

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 Kumar · Answer

Hi Balwant, Please find below link where you can find some useful help, https://archive.codeplex.com/?p=onlinequiz

Jignesh Kumar · Answer

Hi, You can use datalist control to achieve this functionality.

Balwant Singh · Answer

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?

how to bind questions and answers from different tables

Answers (6)