1
Answer

Using sql query show data in grid view

select a.Course_ID,a.Subj_ID,b.Sub_Name from SemSubject_Mapping_Master a join Subject_Master b on a.Subj_ID=b.Sub_ID join Student_Master c on a.Course_ID=c.Course_ID where c.Stud_PRN =" ";
 
this is my query i want data from respctive database into grid view
 
in grid view there is 6 columns
 
sub code sub name min max marks result
 
and i want to show when user enter resp. prn then it can show all subject which are given by student 
Answers (1)