C# insert data into sql server database

i have a list → 1:A,2:A,4:A,7:A,3:C,5:C,6:C,8:C,9:C,10:B,
i want to insert them into my database.

below is my database structure

my database after i insert the list into my database

i have no idea how to do this,i need help and guides ,thank you.

strongly urge you to change your table, so that there is only one question/answer per row

CREATE TABLE answers ( question_no INTEGER NOT NULL PRIMARY KEY , answer CHAR(9) NOT NULL ); INSERT INTO answers VALUES ( 1 , 'A' ) ,( 2 , 'A' ) ,( 3 , 'C' ) ,( 4 , 'A' ) ,( 5 , 'C' ) ,( 6 , 'C' ) ,( 7 , 'A' ) ,( 8 , 'C' ) ,( 9 , 'C' ) ,(10 , 'B' ) ;

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.