"(')+|(;)+|(--)+|(/\*)+|(\*/)+|(xp_)+"
Function f_replace_char(ByRef test_string As String) As String Dim pattern As String Dim m As Match pattern = "(')+|(;)+|(--)+|(/\*)+|(\*/)+|(xp_)+" m = Regex.Match(test_string, pattern) test_string = Regex.Replace(test_string, pattern, "''") Return test_string End Function
Je débutedit il.
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionImports System.Data.Linq.SqlClient ... Dim context As classe_linqDataContext = New classe_linqDataContext Dim t_person As Linq.Table(Of linq_application.Person) = context.Person Dim s_search As String = "kim" Dim s_start As String = "ki" Dim s_end As String = "im" Dim s_joker As String = "%" Dim s_char As String = "_" Dim q_like_start_1 = From q In t_person Where SqlMethods.Like(q.FirstName, s_start + s_joker) Select q.FirstName Dim q_like_start_2 = From q In t_person Where SqlMethods.Like(q.FirstName, s_start + s_char) Select q.FirstName Dim q_like_end_1 = From q In t_person Where SqlMethods.Like(q.FirstName, s_joker + s_end) Select q.FirstName Dim q_like_end_2 = From q In t_person Where SqlMethods.Like(q.FirstName, s_char + s_end) Select q.FirstName Dim q_like_search = From q In t_person Where SqlMethods.Like(q.FirstName, s_joker + s_search + s_joker) Select q.FirstName
Dim q_like_exact = From q In t_person Where q.FirstName Like s_search