I am trying to add data from three TextBoxes in one query but I failed to find a solution
My view
<div class="row no-gutters"> <div class="col-4"> <asp:TextBox ID="txtRaspuns1" class="form-control" runat="server" TextMode="MultiLine" Rows="5" style="resize:none; height:99px;" ClientIDMode="Static" /> <asp:DropDownList ID="ddlCorect1" class="form-control colorchg" runat="server" AutoPostBack="False" ClientIDMode="Static" style="color:white" > <asp:ListItem Text= "NU" Value="red"></asp:ListItem> <asp:ListItem Text= "DA" Value="green"></asp:ListItem> </asp:DropDownList> <asp:TextBox ID="txtCorect1" runat="server" Visible="false" ClientIDMode="Static"/> </div> <div class="col-4"> <asp:TextBox ID="txtRaspuns2" class="form-control" runat="server" TextMode="MultiLine" Rows="5" style="resize:none; height:99px;" ClientIDMode="Static" /> <asp:DropDownList ID="ddlCorect2" class="form-control colorchg" runat="server" AutoPostBack="False" ClientIDMode="Static" style="color:white" > <asp:ListItem Text= "NU" Value="red"></asp:ListItem> <asp:ListItem Text= "DA" Value="green"></asp:ListItem> </asp:DropDownList> <asp:TextBox ID="txtCorect2" runat="server" Visible="false" ClientIDMode="Static"/> </div> <div class="col-4"> <asp:TextBox ID="txtRaspuns3" class="form-control" runat="server" TextMode="MultiLine" Rows="5" style="resize:none; height:99px;" ClientIDMode="Static" /> <asp:DropDownList ID="ddlCorect3" class="form-control colorchg" runat="server" AutoPostBack="False" ClientIDMode="Static" style="color:white" > <asp:ListItem Text= "NU" Value="red"></asp:ListItem> <asp:ListItem Text= "DA" Value="green"></asp:ListItem> </asp:DropDownList> <asp:TextBox ID="txtCorect3" runat="server" Visible="false" ClientIDMode="Static"/> </div> </div>
My code behind
protected void Adauga_Raspunsuri(object sender, EventArgs e) { int id = Convert.ToInt32(txtParam.Text); DataTable Dt = new DataTable(); Dt.Columns.Add("Raspuns", typeof(string)); Dt.Columns.Add("Corect", typeof(string)); Dt.Columns.Add("IdIntrebare", typeof(int)); for (int i = 1; i <= 3; i++) { string Raspuns = Request.Form["txtRaspuns" + i].ToString(); string Corect = Request.Form["txtCorect" + i].ToString(); int IdIntrebare = id; Dt.Rows.Add(Raspuns, Corect, IdIntrebare); } using (SqlConnection conn = new SqlConnection(connString)) { using (SqlCommand cmd = new SqlCommand("AddRaspunsuri", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DetailInsertion", Dt); try { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true); } catch (Exception es) { throw es; } } } Response.Redirect("/AdminPages/Raspunsuri.aspx"); }
The error I have is that string Raspuns = Request.Form["txtRaspuns" + i].ToString(); is empty object