I have a table in which i have First table(recordid,insertionid,year,name)Values(1,21,2008,Danish)
Now I am binding these records to a gridview using store procedure , The issue is that I want to get the the value from another table where insertionid(as foriegn key) mean another table
secondtable(id,insertionid(f),Questionid) Now I want to get the QuestionId by passing the insertionid which i have in first table , and then pass this questionid as parameter and get the question text from another table Thirdtable(id,QuestionId,QuestionText) so cascaded nature of parameter how to get that using store procedure write full code any one can assist pls