How to store template in database?

Question

1.00/5 (1 vote)

See more:

I am building a demo project on Learning Management System. I have a table to store all questions,those questions will be used while creating tests. Now I want to build a template for question paper. e.g

--------------- Template to be stored in database -------------
(m=marks,n=no of questions)

Name of the Template = Template1

1. Five short questions (m=1xn=5)   Total = 5
2. Three descriptive type questions (m=2xn=3) Total = 6
.
.
---------------- End Template----------------------------------

Now in future when user select that template i.e Template1 then 1. five questions will be fetched from table and marks will be fetched from template. 2. Three descriptive questions will be fetched and marks will be fetched from template.

I am building this project using asp.net Web forms. Help needed to create this kind of scenario.

What I have tried:

I don't have any clue , how to design table for this scenario?

Posted 25-Jun-17 23:11pm

Suvankar Das

Updated 25-Jun-17 23:56pm

Add a Solution

Comments

Thomas Nielsen - getCore 26-Jun-17 5:55am

You REALLY need to have a clue about designing relational database systems. I'd very much recommend you to look at some material on this subject you will have to be pretty adept in this if you're planning on a future in Software development.
https://www.pluralsight.com/courses/relational-database-design
https://channel9.msdn.com/Blogs/ASP-NET-Site-Videos/designing-relational-database-tables

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sachin.vishwa90 · Answer 1 · 2017-06-25T23:56:00

You can have a column of nvarchar(max) datatype and you can store the HTML form of the template.
These template will have placeholders in it, which will be replaced with actual value either in code or in stored procedure.

template example

{firstName}

later on in code

tmeplate.Replace("{firstName}","your value");