Danish Habib

Danish Habib

  • NA
  • 694
  • 243.5k

How to show records when gridview edit is clicked

Apr 27 2015 8:24 AM
I have met with an issue the problem is that I have some values in one table and some other values in another table like i have question table and answer table , SO now i want to show my records into a gridview and i want to show main main records as gridview columns header like QuestionText,Submitted By person but the inner detail like what was the answer of that question this details i want  to show when the edit button is clicked I have already a form design which i am using for data submission the FORM HAS THIS KIND OF APPEARANCE


Q#01:TOTAL NUMBER OF  Communities were established. (Target Value) (Achieved Value)


This Target comes from one table and Achieved value comes from another table 


Now When executing the Query I get Multiple rows and on edit I just want to bind the FORM CONTROLS(textboxs) with these comming values from DB , but How to iterate through Rows I cannot use while for every question answer.