Database design:
Two tables (for brevity)
QuestionsTable
ID, QuestionToAsk
AnswersTable
ID, QuestionID, CustomerID, Answer
I have a webpage which has a Repeater, and two buttons (Load Questions and Save Questions). Im using Linq to SQL.
When the page loads the customer would load their questions by clicking Load Questions (Button 1). This loads the questions from the
questions table in a Repeater:
<asp:Repeater ID="rpt1" runat="server" OnItemDataBound="rpt1_ItemDataBound">
<ItemTemplate>
<asp:Label ID="QuestionTextBox" runat="server" Text=""></asp:Label>
<asp:TextBox ID="AnswerTextBox" runat="server"></asp:TextBox>
</ItemTemplate>
</asp:Repeater>
I bind the Repeater in the Load Questions button click Go to the complete details ...