c# string to sqlstring losing format

Question

I have a SQL CLR function that receives a SQLString, and I am converting the Sql string to a c# string with .ToString(), then after some computing I want to return a sring that contains doubles

   [Microsoft.SqlServer.Server.SqlFunction]
   public static string FuncCS(SqlString SQLstr){
   string CSstr = SQLstr.ToString();

     /*DO SOME STUFF*/
    for (int j = 0; j < S.ColumnCount; j++){
        for (int i = 0; i < S.RowCount; i++){
            CSstr += S[i, j].ToString("F5") + " ,  \t"; 
        }           
    }
  }

Then in SQL I receive a string but the doubles lose their decimal point and is substituted by a misplaced comma:

RESULT:

149,50625 0,00000 0,00000 0,00000 0,00000 69,06880 0,00000 0,00000 0,00000 0,00000 31,61588 0,00000 0,00000 0,00000 0,00000 8,82157

WHAT IS NEEDED:

14.9506245839579,0,0,0,0,6.90687968992126,0,0,0,0,3.16158756810842,0,0,0,0,0.88215732592823

What do I change in the for loop?

FYI, you don't have "a CLR". You have a "CLR user-defined function". — John Saunders
– John Saunders, Commented Aug 6, 2011 at 16:45

Marc Gravell · Accepted Answer · 2011-08-06 15:49:00Z

4

I would imagine "culture"; try using ToString("F5", CultureInfo.InvariantCulture)

Also - look at StringBuilder for building a string in a loop.

answered Aug 6, 2011 at 15:49

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

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

9 Comments

edgarmtze Over a year ago

I am getting incorrect results, After doing what you suggested I get:

149.50625, 0.00000, 0.00000, 0.00000, 0.00000, 69.06880, 0.00000, 0.00000, 0.00000, 0.00000, 31.61588, 0.00000, 0.00000, 0.00000, 0.00000, 8.82157,

instead 14.9506245839579,0,0,0,0,6.90687968992126,0,0,0,0,3.16158756810842,0,0,0,0,0.88215732592823 is like it would be multiplying by ten each double

Marc Gravell Over a year ago

@cMinor well, what are the inputs here? Is the first number 14(ish) or 149(ish)?

Marc Gravell Over a year ago

@cMinor also, if you didn't want fixed precision, why did you choose F5?

edgarmtze Over a year ago

the input would be 14.9506245839579, but getting 149.50625

Marc Gravell Over a year ago

@cMinor probably "R" (round-trip). Alternatively, "G" (general)

|

cudahead · Accepted Answer · 2011-08-06 16:34:48Z

1

What is the result if you just use

CSstr += S[i, j] + " ,  \t";

?

answered Aug 6, 2011 at 16:34

cudahead

1536 bronze badges

2 Comments

edgarmtze Over a year ago

the result is:

149,506245839579 ,   0 ,   0 ,   0 ,   0 ,   69,0687968992126 ,   0 ,   0 ,   0 ,   0 ,   31,6158756810842 ,   0 ,   0 ,   0 ,   0 ,   8,82157325928232 ,

cudahead Over a year ago

try double d = Double.Parse(S[i, j], new CultureInfo("de-DE")); Question: What culture do you have in your db and client? Are you sure the values are stored correctly in the db?

Collectives™ on Stack Overflow

c# string to sqlstring losing format

2 Answers 2

9 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related