Last post Oct 18, 2019 08:11 PM by MBhat
Oct 17, 2019 08:06 AM|MBhat|LINK
I have 5 MS Word forms which we are printing and giving to the users to fill hard copy. I want to digitalize it so the user can do it on tablet. i need suggestion of a best and easy practice i can do in ASP.net. Some challenges needs to be addressed
Can anyone suggest the best way to tackle such using the latest Asp.net techniques?
Oct 18, 2019 02:49 AM|Yongqing Yu|LINK
According to your description, I need to confirm some requirements with you.
When a user enters, does he need to fill in all five forms? And the premise is the same identity?
If the information of these five tables corresponds to the user's ID, then I suggest that you do not need to use five tables to store it in the database.
You can create a table that contains all the fields of the five tables. If there will be a new form, just add the corresponding fields to the table in the database.
For this kind of design, I suggest that you first build the tables in the database, and then design your webform page.
Here is a common case of form filling associated with database in webform project. You can refer to this link:
Creating a Simple Registration Form in ASP.NET
Oct 18, 2019 05:08 AM|MBhat|LINK
Oct 18, 2019 08:08 AM|Yongqing Yu|LINK
According to your description, I want to ask you if the fields that need to be filled in for these activities are the same, or not very different, or very different?
If they are the same or roughly the same, I suggest you follow these steps to design.
First, we only need to create three tables.
The first table named ActivityInfo is a table that records all activity types. Its primary key is the ID of the activity. The following fields can be some basic properties of these activities, such as the venue,
The second table named PersonInfo records the basic personal information of the person who filled in the form. The primary key is the ID of the person.
The third table named ActRegistRecord records the activities participated by which personnel. The primary key here is the serial number, which includes the different activities participated by different users
and the basic information filled in.
Here is an example of these three tables:
Oct 18, 2019 08:11 PM|MBhat|LINK
Thanks for the reply. I think this would be good ides too. By the was also thinking to have fields in XML data type column.