Programming Homework Help
Programming Homework Help. vb.net, access database
i have a database table containing:
SEG,AMK,101427Y,EG3902,EG3902-G1
SEG,AMK,101427Y,EGS650,EGS650-G1
SEG,AMK,103852S,EG3901,EG3901-G1
SEG,AMK,103852S,EG3904,EG3904-G1
SEG,AMK,103852S,EGS104,EGS104-G1
SEG,AMK,103852S,EGS650,EGS650-G1
SEG,AMK,106581C,EG3901,EG3901-G1
SEG,AMK,106581C,EG3902,EG3902-G1
SEG,AMK,111713M,EG3901,EG3901-G1
SEG,AMK,111713M,EG3902,EG3902-G1
SEG,AMK,101427Y,EGS650,EGS650-G1
SEG,AMK,103852S,EG3901,EG3901-G1
SEG,AMK,103852S,EG3904,EG3904-G1
SEG,AMK,103852S,EGS104,EGS104-G1
SEG,AMK,103852S,EGS650,EGS650-G1
SEG,AMK,106581C,EG3901,EG3901-G1
SEG,AMK,106581C,EG3902,EG3902-G1
SEG,AMK,111713M,EG3901,EG3901-G1
SEG,AMK,111713M,EG3902,EG3902-G1
column names are: SCHOOL, CAMPUS, ADMINNO, MODULECODE, MODULEGROUP
another table, paperslist containing:
1 SEG-AMK EG1832 abc 286 1.5 EG1832
2 SEG-AMK EG1833 def 375 1.5 EG1833 EG1952 EG1903
3 SEG-AMK EG1835.1 ghi (1) 456 1.5 EG1835 EG1001
4 SEG-AMK EG1835.2 ghi (2) 363 1.5 EG1907 EG1681 EG1951
column name: s/n(paperNo), school, paperID, papertitle, no.ofstudents, duration, modulecodes, modulecode2, modulecode3
2 SEG-AMK EG1833 def 375 1.5 EG1833 EG1952 EG1903
3 SEG-AMK EG1835.1 ghi (1) 456 1.5 EG1835 EG1001
4 SEG-AMK EG1835.2 ghi (2) 363 1.5 EG1907 EG1681 EG1951
column name: s/n(paperNo), school, paperID, papertitle, no.ofstudents, duration, modulecodes, modulecode2, modulecode3
Student modulecodes
111411H eG1001 eg1002
s/n papertitle modulecodes
3 abc eG1001 eg1009
4 xyz eg1002
then there is common student between paper 3 & 4 such that later the exam time table scheduler knows that he can’t schedule these 2 papers on the same time, as it will clash.
I need to get the output of:
3 abc eG1001 eg1009
4 xyz eg1002
then there is common student between paper 3 & 4 such that later the exam time table scheduler knows that he can’t schedule these 2 papers on the same time, as it will clash.
I need to get the output of:
Conflictivepaper no.ofstudents adminno
Paper1 : paper2 2 111411H, 11380y
Paper1 : paper2 2 111411H, 11380y
displaying in multi line textbox or dgv