pls convert following code C# into vb.net

Question

1.11/5 (5 votes)

See more:

Hi Pls convert this code into vb.net, i am try in on-line convert,i am getting error in delegate,

C#

protected static string SqlEscape(string str)
   {
       return Regex.Replace(str, @"[\x00'""\b\n\r\t\cZ\\%_]",
           delegate(Match match)
           {
               string v = match.Value;
               switch (v)
               {
                   case "\x00":            // ASCII NUL (0x00) character
                       return "\\0";
                   case "\b":              // BACKSPACE character
                       return "\\b";
                   case "\n":              // NEWLINE (linefeed) character
                       return "\\n";
                   case "\r":              // CARRIAGE RETURN character
                       return "\\r";
                   case "\t":              // TAB
                       return "\\t";
                   case "\u001A":          // Ctrl-Z
                       return "\\Z";
                   default:
                       return "\\" + v;
               }
           });
   }

Or change the code without delegate,,,,

Regards
Aravind

Posted 10-May-15 23:32pm

Aravindba

Updated 10-May-15 23:41pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Accepted Answer · 2015-05-11T00:27:00

Solution 1

Use this: http://converter.telerik.com/[^]

VB

Function Compare(match As Match) As String
    Dim v As String = match.Value
    Select Case v
        Case vbNullChar
            ' ASCII NUL (0x00) character
            Return "\0"
        Case vbBack
            ' BACKSPACE character
            Return "\b"
        Case vbLf
            ' NEWLINE (linefeed) character
            Return "\n"
        Case vbCr
            ' CARRIAGE RETURN character
            Return "\r"
        Case vbTab
            ' TAB
            Return "\t"
        Case ChrW(26)
            ' Ctrl-Z
            Return "\Z"
        Case Else
            Return Convert.ToString("\") & v
    End Select
End Function

Protected Shared Function SqlEscape(str As String) As String
    Return Regex.Replace(str, "[\x00'""\b\n\r\t\cZ\\%_]", AddressOf Compare)
End Function

Posted 11-May-15 0:27am

Kornfeld Eliyahu Peter

Updated 11-May-15 2:01am

v2

Comments

Aravindba 11-May-15 7:47am

Thank u for ur reply,i already try with telerik converter and also other online converter,i am getting error near delegate ,in c# word is delegate but in vb.net after convert "sub(match as Match),here i get error ,pls add in sample vb.net application and check,it gives error.

Kornfeld Eliyahu Peter 11-May-15 8:02am

Which means that no-one anymore interested in converting code to VB :-)...
Answer updated...
(You have to learn how to find answers to questions using Google! Also to be able to understand compiler errors!)

Aravindba 11-May-15 8:17am

Thank u for ur update ,still got error ,here i attach screenshot link,http://prntscr.com/73z2g9 i am add ur code in aspx page.And i dont want convert code as it is in c#,is any other way achieve this way in vb.net.

Kornfeld Eliyahu Peter 11-May-15 8:33am

As I told you - you have to learn to read error messages!!!
The actual problem is that 'SqlEscape' is a shared (static) method where 'Compare' is not - fix it...

Aravindba 11-May-15 9:59am

Thank u for ur comments,now work fine,thanx a lot 5+

Kornfeld Eliyahu Peter 11-May-15 10:00am

You are welcome...