Capturing data from a grid in a bulky mode

Question

User-326746839 posted

I have a table in which I have a serie of questions. Not all question must be shown at once. It will depnend on user's profile which ones are elegible to display

I have a second table in which I store the data belonging to each one of the questions coming from the first table (one answer for each question answered)

I can't have both things in the same entity because the questions can be answred many different times by many different people

To make it simple to follow let's assume a very reduced data model like this:

I have an entyity "Questions" with 2 main columns : cod_questionID and question (plus many other additional columns that is not worth to mention here)

I have a second entity "QuestionAnswers"
with : cod_QuestionAnswerID, cod_questionID (coming a s FK from Questions) and answer_value 
(plus other obvious additional fields: date, logingID, timestamp, access_aut, etc) 

So if I have 50 questions (the questions contained in the "Questions" table) that I'd like to show to my user at once so he can capture all 50 answers and save them in bulk mode in the "QuestionAnswers" table

E.g.: (these are the questions)

So I'd like to save all the data at once 

Question	Answers
Lenght	20 cm
Date Purchase	December 14th, 2022
Lenguage	Rails
Increase	10.45435
Ratio	0.56667%
Income	$4,456.77
Trip	Departure
Tax	Income Tax
Accounting	Expenditure
E$xpenses	No data
Norm	ISO9009
Power Outlet	34.45 Volts
Motor	45 HP
Capacity	45.55 cm3
Movie	Trailer
Calculation	Percentage

This can be easily done of course on a one by one answer basis which is absolutelly horrendous for data capturing efficiency

Carlos N. Porras 
(El Slavador) 
.
.
. 

P.S.: PLEASE DON'T SAY THIS IS SOMETHING YOU DON'T UNDERSTAND OR TO PROVIDE SOURCE CODE (If I had any I wouldn't be asking) THIS IS RATHER TRIVIAL THAN COMPLEX .... just need to know how to do the iteration from all the data shown in the gridview</div>

Answer 1

User-326746839 posted

Ok. Ask me for code (but I don't have any. Mr. Dong, don't be mad but it is that you always ask for code and sometimes that request is not fit at all with the policies that we might have in disclosing information from our bosses.

Why is so hard sometimes just getting to have your posts read by someone else?

Not even Steve Naughton seems to care about this? 

Carlos N. Porras
(El Salvador) 

Answer 2

User-330204900 posted

Hi Carlos, I;ve been both very busy and had Christmas to deal with but I am back now :) I will have good old read of your first post and get back shortly probably in the morning.

Answer 3

User-326746839 posted

Steve,

God bless you .... 

I'll be waiting to hear from you very soon

Carlos N. Porras
(El Salvador) 

Answer 4

User-326746839 posted

Hi Steve,

I'm waiting for you my friend ....

Carlos N. Porras
(El Salvador) 

Answer 5

User-326746839 posted

NAUGHTON ..... WERE ARE YOU ... ?????


Carlos N. Porras
(El Salvador) 

Answer 6

User-330204900 posted

Hi Carlos, I can't think of a way in ASP.Net DD that would do it, other than maybe having a view that has both tables joined together and then make the view and updatable view using Rick Anderson technique.

Answer 7

User-326746839 posted

Hi Steve,

Any good wysiwyg program for building views ... I mean, with visual interactivity so you can drag and drop fields to build the view? Is there any of that kind?


Carlos N. Porras
(El Salvador) 

Answer 8

User-330204900 posted

I use SQL Server Management studio, you can get a basic version with SQL Express/Local DB nowadays.