C# String manipulation for Dynamic Query

Question

I have a string

it contains can contains either of (1)

 strQuery = "TempTable.Group_No IN ()";

(2)

strQuery = "TempTable.Group_No IN (1,2,3,4,....)";

My task is if it contains "TempTable.Group_No IN ()", (i.e) IN CLAUSE without data

i have to replace the string (IN() with IN (NULL)) with "TempTable.Group_No IN (NULL)"

How to perform it in C#?

James Gaunt · Accepted Answer · 2010-08-18 16:50:56Z

2

How about...

strQuery = strQuery.Replace("()", "(NULL)");

... or is that a bit too simple?

answered Aug 18, 2010 at 16:50

James Gaunt

14.8k2 gold badges42 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

palswim · Accepted Answer · 2010-08-18 16:53:25Z

2

I don't know how much you have to worry about the empty parenthesis in other areas, but you can use this to have greater certainty that you're replacing the right thing.

strQuery = strQuery.Replace("IN ()", "IN (NULL)");

answered Aug 18, 2010 at 16:53

palswim

12.2k8 gold badges57 silver badges79 bronze badges

Comments

Adam Butler · Accepted Answer · 2010-08-18 16:59:31Z

2

I'm assuming the input is an array of integers for the solution below. Try this out as a console app:

static void Main(string[] args)
{
    int[] ids1 = new int[] { 1, 2, 3, 4, 5 };
    int[] ids2 = new int[] {};

    Console.WriteLine(FormatQuery(ids1));
    Console.WriteLine(FormatQuery(ids2));           
}

static string FormatQuery(int[] ids)
{
    return string.Format("TempTable.Group_No IN ({0})", 
        ids.Length > 0 ? string.Join(",", ids) : "NULL");
}

answered Aug 18, 2010 at 16:59

Adam Butler

2,75323 silver badges27 bronze badges

Collectives™ on Stack Overflow

C# String manipulation for Dynamic Query

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related