Dim cmd As New SqlCommand

        If con1.State = ConnectionState.Closed Then
            con1.Open()
        End If
        Dim instr As String
        Dim valstr As String

        instr = "insert into insert_tab (type_service,type,specificatiions,location,price,the_applicant,tel,email,date_of_ap,Notes)"

        valstr = "values (" & DropDownList1.SelectedItem.Text & " '," & TextBox1.Text & "','" & TextBox2.Text & " ','" & TextBox3.Text & " ','" & TextBox4.Text & " ','" & Textbox9.Text & " ','" & TextBox5.Text & " ','" & TextBox6.Text & " ','" & TextBox7.Text & " ','" & TextBox8.Text & " ')"

        cmd.CommandText = instr + valstr
        cmd.Connection = con1
        Try
            cmd.ExecuteNonQuery()
            con1.Close()
        Catch ex As Exception
            Response.Write(ex.Message)
        End Try
        Response.Redirect("WebForm1.aspx")