Comments by Newcodervb (Top 3 by date)

Thnk u for the Parameters advise. I did the necessary changes. But I am still unable to insert Multiple values for the checkbox in the database (Sql2016). When I select multiple checkboxlist items only one record gets saved.
Help required.

I have tried the Parameters, it wouldn't work. After clicking the submit button. In my sql table, it would insert the date and time(Get date) the form was submitted.
SQL2016


Con. ConnectionString="DataSouce=.... Security=True"
Con. Open()
Cmd= new SqlCommand("Insert into table values(' " & Text1.Text & " ',' " & Text2.Text &" ', ' " & Text3.Text & " ', ' " & Text4.Text & " ',, ' " & CheckBoxList. Text & " ', Getdate())", con)
Cmd. ExecuteNonQuery()
Con. Close()