vb.net, access database

User Generated

snatyvat_@ubgznvy.pb

Programming

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

Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Explanation & 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.

svggvat x (56)
UT Austin

Anonymous
Great content here. Definitely a returning customer.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4