ashab27 0 Newbie Poster

hi this is my code

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlConnection con = new SqlConnection(scon);
con.Open();
da = new SqlDataAdapter("select Question,Option1,Option2,Option3,Option4 from QuestionData", con);
ds = new DataSet();
da.Fill(ds);
}


}

and this is .aspx

<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1"
Width="870px" AllowPaging="True" BorderColor="#999999"
BorderStyle="Solid" CellPadding="3" ForeColor="Black"
GridLines="Vertical" HorizontalAlign="Center" BackColor="White"
BorderWidth="1px">
<FooterStyle BackColor="#CCCCCC" />
<ItemTemplate>
<table style="width:100%;">
<tr>
<td class="style14">
<asp:Image ID="Image1" runat="server" ImageUrl="~/images/question.jpg" />


</td>
<td>


<%# Eval("Question") %>
</td>
</tr>
<tr>
<td class="style5">
&nbsp;</td>
<td>
<asp:CheckBox ID="CheckBox13" runat="server" />
<%# Eval("Option1") %>


</td>
</tr>
<tr>
<td class="style5">
&nbsp;</td>
<td>
<asp:CheckBox ID="CheckBox14" runat="server" />
<%# Eval("Option2") %>


</td>
</tr>
<tr>
<td class="style5">
&nbsp;</td>
<td>
<asp:CheckBox ID="CheckBox15" runat="server" />
<%# Eval("Option3") %>


</td>
</tr>
<tr>
<td class="style5">
&nbsp;</td>
<td>
<asp:CheckBox ID="CheckBox16" runat="server" />
<%# Eval("Option4") %>


</td>
</tr>
<tr>
<td class="style5">
<asp:Button ID="Button1" runat="server" Text="  Submit  " onclick="SubmitButton_Click1"  />


</td>
<td>
&nbsp;</td>
</tr>
</table>
</ItemTemplate>
<InsertItemTemplate>
<table style="width:100%;">
<tr>
<td class="style14">
<asp:Image ID="Image3" runat="server" ImageUrl="~/images/question.jpg" />


</td>
<td>


<asp:Label ID="QuestionLabel" runat="server" Text='<%# Bind("Question") %>' />
</td>
</tr>
<tr>
<td class="style5">
&nbsp;</td>
<td>
<asp:CheckBox ID="CheckBox13" runat="server" Checked='<%# Bind("Option1") %>' />


</td>
</tr>
<tr>
<td class="style5">
&nbsp;</td>
<td>
<asp:CheckBox ID="CheckBox14" runat="server" Checked='<%# Bind("Option2") %>' />


</td>
</tr>
<tr>
<td class="style5">
&nbsp;</td>
<td>
<asp:CheckBox ID="CheckBox15" runat="server"  Checked='<%# Bind("Option3") %>'/>


</td>
</tr>
<tr>
<td class="style5">
&nbsp;</td>
<td>
<asp:CheckBox ID="CheckBox16" runat="server"  Checked='<%# Bind("Option4") %>'/>


</td>
</tr>
<tr>
<td class="style5">
<asp:Button ID="SubmitButton" runat="server" Text="  Submit  " onclick="SubmitButton_Click1"  />


</td>
<td>
&nbsp;</td>
</tr>
</table>
</InsertItemTemplate>


<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
</asp:FormView>
<br />


<br />
<br />
<br />
<br />


<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:onlineexamdbConnectionString %>"
SelectCommand="SELECT [Question], [Option1], [Option2], [Option3], [Option4] FROM [QuestionData]"


InsertCommand="INSERT Table_1 ([Question],[Option1], [Option2], [Option3], [Option4])  VALUES (@Question,@Option1,@Option2,@Option3,@Option4)"
oninserted="SqlDataSource1_Inserted" ProviderName="System.Data.SqlClient"
>
</asp:SqlDataSource>
<br />
<br />
<asp:TextBox ID="TextBox1" runat="server" Enabled="False" EnableTheming="False"
ReadOnly="True" Text='<%# Bind("Question") %>'
Height="38px" Width="845px" ></asp:TextBox>
<br />
<br />
<br />



</asp:Content>

I want to do that when i will click on the button then my record like lable value and checkbox value should be insert in my database table
Please give me some replay
Thank you

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.