Programming
vb.net, access database

Question Description

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
 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 

 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: 
 Conflictivepaper    no.ofstudents     adminno
Paper1 : paper2       2                       111411H, 11380y
displaying in multi line textbox or dgv

Final Answer

Thank you for the opportunity to help you with your question!

In most cases, the discipline is self-governed by the entities which require the programming, and sometimes very strict environments are defined

Please let me know if you need any clarification. I'm always happy to answer your questions.

fitting k (56)
UT Austin

Anonymous
Return customer, been using sp for a good two years now.

Anonymous
Thanks as always for the good work!

Anonymous
Excellent job

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors