Appending Quations to a string

[Arun Philip Reynolds]

oops!!! I did miss that one out. After I included the decrement of the length, it is removing all the comma's from the string. I need the comma that is in between the strings but it should not add the comma at the end of the string. It is just like the SQL statement that we write. e.g. Select * from table where name like ('abc','def','ghi') I am trying to send the variable in this format to the stored procedure.

[PIEBALDconsult]

It should be outside the loop, as in the example I posted.

[PIEBALDconsult]

Arun Philip Reynolds wrote:

It is just like the SQL statement that we write.
e.g. Select * from table where name like ('abc','def','ghi')

If you are using SQL Server (and you should), then how about... SQL Server 2008 User Defined Table Types and Table-Valued Parameters[^]

[PIEBALDconsult]

I use it whenever I can -- muaa haa ha ha! :cool:

[Arun Philip Reynolds]

Thanks, but I just tried this,

strHolderString = strServerName.ToString();
strHolderString = strHolderString.TrimEnd(',');
strFinalList = new StringBuilder(strHolderString);

here the strHolderString is a string variable and I am getting the result that I was looking for. Thanks once again to everyone. :-D

[Arun Philip Reynolds]

strHolderString = strServerName.ToString();
strHolderString = strHolderString.TrimEnd(',');
strFinalList = new StringBuilder(strHolderString);

I just tried the above and it works for me. Here the strHolderString is a string variable and I used the TrimEnd function to get rid of the trailing comma. The strFinalList is a StringBuilder variable. Thanks once again to all

[PIEBALDconsult]

:sigh: Just decrement the Length. Why create two Strings and another StringBuilder?

[Subin Mavunkal]

You can use SmartPaster addin for visual studio.Copy the text you needed and paste it as string builder.Here is the code and installer http://www.martinwilley.com/blog/2010/06/06/SmartPasteIn2010.aspx[^]

[BobJanova]

There's pretty much no reason to avoid StringBuilder, it's in the core Framework and the memory footprint of creating a new object is likely to be less than all the wasted strings you make in a concatenation session.

[Pete OHanlon]

An alternative approach is to use a list of strings instead of a StringBuilder to build your list and then concatenate them as you need. Here's one way to do this:

public class FormattedStrings : List<string>()
{
public override string ToString()
{
StringBuilder sb = new StringBuilder();
bool started = false;
foreach (string item in this)
{
if (started)
{
sb.AppendFormat(",\"{0}\"", item);
}
else
{
started = true;
sb.AppendFormat("\"{0}\"", item);
}
}

return sb.ToString();

}
}

I am assuming that you have assigned the @ symbol when you built your StringBuilder.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

[PIEBALDconsult]

Ew, yuck, duplicated code. X| Needless boolean, needless if/else. Stick the comma on the end and decrement it off when you're done.

[Pete OHanlon]

To be fair, this was just knocked up in the CP editor and doesn't reflect what I would push out the door. I did look at doing it your way, but saw that you'd already posted that so it seemed that there wasn't much point to showing something that was already done - this is purely to stimulate the mind into thinking of other ways of solving the problem.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility