.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> VB.Net >> Post New QuestionBookmark and Share Subscribe to Forum

Looping through access datatables and compare values to get conflicting data

Posted By: 12345_abcde     Posted Date: July 16, 2013    Points:5   Category :VB.Net
i have a table in access containing data like:

PaperID--School--PaperID---PaperTitle--Noofstudents---Duration---ListofModules
paper 1---SEG----EG1832---Mechanics---- 286----1.5(hrs)---EG1832
paper 2---SEG----EG1833---ElectricalPrinc--375--1.5 -------EG1833 EG1952 EG1903
another table with:

module students
EG1832 ----- 111411H
-blank ----- 111380Y
-blank ---- 151621H
EG1952 ----- 198653H
-blank ----- 545411Q
- blank ---- 111411H
if let say student;111411h is taking EG1832 and EG1952, then output:

Conflict modules No.ofstudents student(adminNo)
paper1:paper2 1 111411H
anyone tell me how to go about doing this?

how do i loop through the 2 tables in access database, not displaying in my program yet. only the output will be displayed in my program's multi line text box.
thanks in advance!

Responses

No response found. Be the first to respond this post
Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend