vb.net code

using vb.net and sql query i need to join multiple tables to view in one datagridview control .In each table i need to take only one field and want to dislpay all in the datagridview control...can anyone provide me the apat code for this

Edited 4 Years Ago by Subhashini.V

Contributors

Replies

Views

4 Years

Discussion Span

4 Years Ago

Last Post by Begginnerdev

What tables? Join your tables in your select statement. Need more information about the table structures. You haven't shown that you've made any attempt. Where's your code?

For the prediction of the student performance i have created tables for personal details,attendance,class test,Assignment,lab work,semester marks,seminar,general proficiency,prediction result. in each table except personal details and prediction result table i have the overall status field.in the perdection result table i have to join all the overall status result.In the prediction form i want to dislay the overall status result for all the students by using datagridview control.

As cgeir has said, we can't see any code thusfar. As for the SQL I will give you a little bit of a hint.

"SELECT tb1.Column1,tb2.Column1,tb3.Column1 FROM Table1 tb1, Table2 tb2, Table3 tbl3 WHERE tb1.Column1=MyValue,tb2.Column1=MyValue,tb3.Column1=MyValue""

query sql vb.net

import java.io.BufferedReader; import java.io.File; import java.io.FileReader; import java.io.IOException; public class DataStreamExample { public static void main(String[] args) throws IOException { File f = new File("seminar.txt"); if (f.exists()) { BufferedReader br ...