Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
'// I know this will print out the values from each textbox For Each item As RepeaterItem In myRepeater.Items Dim noResonpse As TextBox = TryCast(item.FindControl("questionExplained"), TextBox) Response.Write(noResonpse.Text + "<br>") '// I could use a sp to update each record at a time but I would rather do just one update for the answers Next Here is the db update strConn = ConfigurationManager.ConnectionStrings("SiteConnectionString").ConnectionString Dim conn As New SqlConnection(strConn) Dim insertSurvey As New SqlCommand("spSurvey", conn) insertSurvey.CommandType = CommandType.StoredProcedure insertSurvey.Parameters.AddWithValue("@Name", name.Text) insertSurvey.Parameters.AddWithValue("@date", date.Text) '// I would like to add each textbox insertSurvey.Parameters.AddWithValue("@question1", explained1Txt.Text) insertSurvey.Parameters.AddWithValue("@question2", explained2Txt.Text) conn.Open()
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.