Imports System.Data.SqlClient
Partial Class Register
    Inherits System.Web.UI.Page




    Protected Sub Submit1_Click1(ByVal sender As Object, ByVal e As System.EventArgs) Handles Submit1.Click
        txtName.Text = txtName.Text.Replace("'", "''")
        txtFamily.Text = txtFamily.Text.Replace("'", "''")
        txtUser.Text = txtUser.Text.Replace("'", "''")
        txtPass.Text = txtPass.Text.Replace("'", "''")
        txtEmail.Text = txtEmail.Text.Replace("'", "''")
        txtPhone.Text = txtPhone.Text.Replace("'", "''")

        Dim NonQuery As String

        Dim sqlCon As New SqlConnection(ConfigurationManager.ConnectionStrings("dbConnectionString").ConnectionString)

        NonQuery = "Insert into users(username,password,name,family,emailadress,phone number) values ('" _
        & txtUser.Text.Trim & "','" & txtPass.Text.Trim & "','" & txtName.Text.Trim & "','" _
        & txtFamily.Text.Trim & "','" & txtEmail.Text.Trim & "','" & txtPhone.Text.Trim & "');"

        Dim sqlCmd As New SqlCommand(NonQuery, sqlCon)
        sqlCon.Open()
        sqlCmd.ExecuteNonQuery()
        sqlCon.Close()

        txtName.Text = ""
        txtFamily.Text = ""
        txtUser.Text = ""
        txtPass.Text = ""
        txtEmail.Text = ""
        txtPhone.Text = ""

    End Sub

End Class

"Insert into users(username,password,name,family,emailadress,phonenumber) values ('" _