How to Create Dynamic Questionnaire using ASP.Net, C#.

I want to Create Questionnaire.In my Questionnaire there are many categories. Each categories has questions. First i will display the Category of Questions then Questions inside the Category.Number of questions is not fixed in any category. Questions may have options or not. Suppose If there is a question. what is your age? then it has no option. i will have to add textbox for input data for user. Some questions may have to select one option. For this i will have to add RadionButtionList.Some Questions may have many options. For this i will have to add CheckBox. Number of options is also not fixed for Questions. Question's option type (TextBox, CheckBox, RadioButtionList) is determined by Admin and it is saved in the Database. Now i want to create dynamically Controls (TextBox, CheckBox, RadioButtionList) on the basis of Option Type entered by Admin for option. How i will create it using ASP.Net,C#,SQL Server. Please suggest me. Thanks in advance.

I have designed my database. Now, I am displaying the questions on the page from database according to my requirement. I am dynamically creating table and showing Questions in it. Now i have problem that i want to store the Question and answers of the question given by users in the database. Because these are HTML controls generated dynamically in code. So i am getting problem in accessing these html controls value and saving them into the database. How i will do it using asp.net,c#,javascript,SQL Server. Please suggest me. My code is given below.

my .aspx Page code:

my .aspx.cs Page Code

SqlConnection strConnect = new SqlConnection(ConfigurationManager.AppSettings["SqlConn"].ToString());

protected void Page_Load(object sender, EventArgs e)

{

Show_Questions();

}

protected void Show_Questions()

{

try

{

SqlDataAdapter da;

SqlCommand cmd;

string query = @"select distinct c.categoryID,c.CategoryName from Questionnaire_Question_Category c inner join Questionnaire_Questions q

on c.categoryID=q.categoryID where q.IsActive=1 and c.IsActive=1 ";

DataTable dtcat = new DataTable();

cmd = new SqlCommand(query, strConnect);

da = new SqlDataAdapter(cmd);

da.Fill(dtcat);

StringBuilder sb = new StringBuilder();

sb.Append("");

foreach (DataRow dr in dtcat.Rows)

{

sb.Append(@"

");

string query1 = @"select distinct questionid,question,typeid from Questionnaire_Questions

where IsPublished=1 and categoryID=" + dr[0].ToString() + "";

DataTable dtqn = new DataTable();

cmd = new SqlCommand(query1, strConnect);

da = new SqlDataAdapter(cmd);

da.Fill(dtqn);

foreach (DataRow dr1 in dtqn.Rows)

{

sb.Append(@"

");

if (dr1[2].ToString() == "1")

{

sb.Append("

");

}

else if (dr1[2].ToString() == "2")

{

string query2 = @"select optionid,options from Questionnaire_Question_Options

where questionid=" + dr1[0].ToString() + "";

DataTable dtRop = new DataTable();

cmd = new SqlCommand(query2, strConnect);

da = new SqlDataAdapter(cmd);

da.Fill(dtRop);

foreach (DataRow dr2 in dtRop.Rows)

{

sb.Append("

");

}

sb.Append("

");

}

else if (dr1[2].ToString() == "3")

{

string query3 = @"select optionid,options from Questionnaire_Question_Options

where questionid=" + dr1[0].ToString() + "";

DataTable dtCop = new DataTable();

cmd = new SqlCommand(query3, strConnect);

da = new SqlDataAdapter(cmd);

da.Fill(dtCop);

foreach (DataRow dr2 in dtCop.Rows)

{

sb.Append("

");

}

sb.Append("

");

}

sb.Append("

" + dr[1].ToString() + "
" + dr1[1].ToString() + "
" + dr2[1].ToString() + "
" + dr2[1].ToString() + "

");

testdiv.InnerHtml = sb.ToString();

}

catch (Exception ex)

{

}

2 Replies

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

Ikram Shams11y ago
I have designed my database. Now, I am displaying the questions on the page from database according to my requirement. I am dynamically creating table and showing Questions in it. Now i have problem that i want to store the Question and answers of the question given by users in the database. Because these are HTML controls generated dynamically in code. So i am getting problem in accessing these html controls value and saving them into the database. How i will do it using asp.net,c#,javascript,SQL Server. Please suggest me. My code is given below.
my .aspx Page code:

my .aspx.cs Page Code
SqlConnection strConnect = new SqlConnection(ConfigurationManager.AppSettings["SqlConn"].ToString());
protected void Page_Load(object sender, EventArgs e)
{
Show_Questions();
}
protected void Show_Questions()
{
try
{
SqlDataAdapter da;
SqlCommand cmd;
string query = @"select distinct c.categoryID,c.CategoryName from Questionnaire_Question_Category c inner join Questionnaire_Questions q
on c.categoryID=q.categoryID where q.IsActive=1 and c.IsActive=1 ";
DataTable dtcat = new DataTable();
cmd = new SqlCommand(query, strConnect);
da = new SqlDataAdapter(cmd);
da.Fill(dtcat);
StringBuilder sb = new StringBuilder();
sb.Append("");
foreach (DataRow dr in dtcat.Rows)
{
sb.Append(@"
");
string query1 = @"select distinct questionid,question,typeid from Questionnaire_Questions
where IsPublished=1 and categoryID=" + dr[0].ToString() + "";
DataTable dtqn = new DataTable();
cmd = new SqlCommand(query1, strConnect);
da = new SqlDataAdapter(cmd);
da.Fill(dtqn);
foreach (DataRow dr1 in dtqn.Rows)
{
sb.Append(@"
");
if (dr1[2].ToString() == "1")
{
sb.Append("
");
}
else if (dr1[2].ToString() == "2")
{
string query2 = @"select optionid,options from Questionnaire_Question_Options
where questionid=" + dr1[0].ToString() + "";
DataTable dtRop = new DataTable();
cmd = new SqlCommand(query2, strConnect);
da = new SqlDataAdapter(cmd);
da.Fill(dtRop);
foreach (DataRow dr2 in dtRop.Rows)
{
sb.Append("
");
}
sb.Append("
");
}
else if (dr1[2].ToString() == "3")
{
string query3 = @"select optionid,options from Questionnaire_Question_Options
where questionid=" + dr1[0].ToString() + "";
DataTable dtCop = new DataTable();
cmd = new SqlCommand(query3, strConnect);
da = new SqlDataAdapter(cmd);
da.Fill(dtCop);
foreach (DataRow dr2 in dtCop.Rows)
{
sb.Append("
");
}
sb.Append("
");
}
}
}
sb.Append("
" + dr[1].ToString() + "
" + dr1[1].ToString() + "
" + dr2[1].ToString() + "
" + dr2[1].ToString() + "
");
testdiv.InnerHtml = sb.ToString();
}
catch (Exception ex)
{

}
}

0
Dorababu Meka11y ago
You should design your database or you need to have a table with a scenario you explained. Then it is easy to create controls dynamically as expected
0