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
vb.net code
0
cgeier 187 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?
0
Subhashini.V 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.
0
Begginnerdev 256 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""
This topic has been dead for over six months. Start a new discussion instead.
Recommended Topics
