in the code below i get the issue if i use an apostrophe, how do i go about fixing it?
Public Sub SaveTextboxes()
'Saving Textboxes
Sqlupdate.SelectCommand = "Select * From LOCATIONS where LOCATIONID = '" & txtlocationid.Text & "'"
Dim savetxtboxes As DataView = CType(Sqlupdate.Select(DataSourceSelectArguments.Empty), DataView)
If savetxtboxes.Count >= "0" Then
'Update
Sqlupdate.UpdateCommand = "UPDATE LOCATIONS Set LOCWNAME = '" & txtlocwname.Text & "', LOCNM = '" & txtlocnw.Text & "', ADDR1 = '" & txtaddr1.Text & "', ADDR2 = '" & txtaddr2.Text & "', ADDR3 = '" & txtaddr3.Text & "', CITY = '" & txtcity.Text & "', ZIP = '" & txtzip.Text & "', COUNTRY = '" & txtcountry.Text & "', PHN = '" & tx ...
Go to the complete details ...