public String getAnswer()
{
String strAnswer = "<table border='1'>";
DataSetTableAdapters.tb_answerTableAdapter tb_answer = new DataSetTableAdapters.tb_answerTableAdapter();
DataTable dt_answer = tb_answer.GetData();
strAnswer += "<tr><td>Id</td><td>Answer</td><td>Question</td></tr>";
foreach (DataRow dr_answer in dt_answer.Rows)
{
Int32 answer_id = (Int32)dr_answer["id"];
String question = getQuestion(answer_id);
strAnswer += "<tr>";
strAnswer += "<td>" + dr_answer["id"] + "</td>";
strAnswer += "<td>" + dr_answer["answer"] + "</td>";
strAnswer += "<td>" + question + "</td>";
strAnswer += "</tr>";
}
strAnswer += "</table>";
return(strAnswer);
}
protected void Page_Load(object sender, EventArgs e)
{
DataSetTableAdapters.tb_answerTableAdapter tb_answer = new DataSetTableAdapters.tb_answerTableAdapter();
GridView1.DataSource = tb_answer.GetData();
GridView1.DataBind();
}