|
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);
}
}
protected void SubmitButton_Click1(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(scon);
con.Open();
cmd = new SqlCommand("insert into Table_1 values(' " + "@Question" + " ',' " + "@Option1" + " ',' " + "@Option2" + " ',' " + "@Option3" + " ',' " + "@Option4" + " ') ", con);
//cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Question", SqlDbType.VarChar).Value = "Question".ToString();
cmd.Parameters.Add("@Option1", SqlDbType.VarChar).Value = "Option1";
cmd.Parameters.Add("@Option2", SqlDbType.VarChar).Value = "Option2";
cmd.Parameters.Add("@Option3", SqlDbType.VarChar).Value = "Option3";
cmd.Parameters.Add("@Option4", SqlDbType.VarChar).Value = "Option4";
cmd.ExecuteNonQuery();
Response.Write("<script>alert('Your record is insert successfuly')</script>");
con.Close();
}
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">
</td>
<td>
<asp:CheckBox ID="CheckBox13" runat="server" />
<%# Eval("Option1") %>
</td>
</tr>
<tr>
<td class="style5">
</td>
<td>
<asp:CheckBox ID="CheckBox14" runat="server" />
<%# Eval("Option2") %>
</td>
</tr>
<tr>
<td class="style5">
</td>
<td>
<asp:CheckBox ID="CheckBox15" runat="server" />
<%# Eval("Option3") %>
</td>
</tr>
<tr>
<td class="style5">
</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>
</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">
</td>
<td>
<asp:CheckBox ID="CheckBox13" runat="server" Checked='<%# Bind("Option1") %>' />
</td>
</tr>
<tr>
<td class="style5">
</td>
<td>
<asp:CheckBox ID="CheckBox14" runat="server" Checked='<%# Bind("Option2") %>' />
</td>
</tr>
<tr>
<td class="style5">
</td>
<td>
<asp:CheckBox ID="CheckBox15" runat="server" Checked='<%# Bind("Option3") %>'/>
</td>
</tr>
<tr>
<td class="style5">
</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>
</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
|