title: I'm creating a survey using ASP.NET...but how to I create the database to store it?
body: <p>I've created the survey form but I don't know how to continue doing the database...
  Can someone each me?
  Anyway, Here's my code:</p>
  
  <pre><code>&lt;tr&gt;
                  &lt;td class="auto-style2"&gt;5) Would you share our website to your friends?&lt;/td&gt;
                  &lt;td&gt;
                      &lt;asp:RadioButtonList ID="rbl5" runat="server" AutoPostBack="True" RepeatDirection="Horizontal" RepeatLayout="Flow"&gt;
                          &lt;asp:ListItem&gt;Yes&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;No&lt;/asp:ListItem&gt;
                      &lt;/asp:RadioButtonList&gt;
                  &lt;/td&gt;
              &lt;/tr&gt;
              &lt;tr&gt;
                  &lt;td class="auto-style2"&gt;6) Any comments or suggestions?&lt;/td&gt;
                  &lt;td&gt;
                      &lt;asp:TextBox ID="tbComment" runat="server" Height="182px" TextMode="MultiLine" Width="271px"&gt;&lt;/asp:TextBox&gt;
                      &lt;br /&gt;
                      &lt;br /&gt;
                      &lt;br /&gt;
                      &lt;input type="button" onclick="btnSubmit_Click()" value="Submit" /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
                      &lt;asp:Button ID="btnReset" runat="server" OnClick="btnReset_Click" Text="Reset" /&gt;
                  &lt;/td&gt;
              &lt;/tr&gt;
          &lt;/table&gt;
  
      &lt;/div&gt;
      &lt;/form&gt;
  </code></pre>
  
  <p>As you noticed, I used radiobuttonlist and comment box. These are the reasons why I'm having problem to create the database... Please teach me...I only know how to create tables for database...</p>
  
  <p>And the database might be something like this...</p>
  
  <p>This is the QUESTION Table:</p>
  
  <pre><code>CREATE TABLE [dbo].[Question]
  (
      [Id] INT NOT NULL PRIMARY KEY, 
      [Question] NCHAR(10) NULL, 
      [Options] NCHAR(10) NULL
  )
  </code></pre>
  
  <p>This is the ANSWERS Table:</p>
  
  <pre><code>CREATE TABLE [dbo].[Answers]
  (
      [Id] INT NOT NULL PRIMARY KEY, 
      [QuestionId] NCHAR(10) NULL, 
      [Answers] NCHAR(10) NULL
  )
  </code></pre>
  
  <p>And I'm also not sure about the NCHAR(10) ... 
  So this is how bad I am in programming.
  Please teach me.</p>