ansaurus

Question

How to write database value in text file on defined format

Answer 1

A:

I'd suggest starting with the string.Format method and check the additional references on the documentation page for help in determining the proper custom format strings.

tvanfosson 2010-07-20 12:03:34

How add string.Format in my C# syntax to save database value in TextFile.

shamim 2010-07-20 12:25:40

@shamim - `string.Format( "{0,-5:00000} | {1,10}|` ... should give you a start.

tvanfosson 2010-07-20 13:29:53

thanks it's really helpful.hope you see my wanted format in above example,one column named INSTRUMENT contain string .How to format string on that way as on above example.

shamim 2010-07-20 18:21:12

Sorry - the second format string should have been `{1,-10}`. I didn't notice it was left aligned as well. Note that if the column value may contain more than 10 characters, you'll need to use `Substring` with a length of the minimum of 10 and the string length: `string.Format( "{0,-10}", s != null ? s.Substring( 0, Math.Min( 10, s.Length )) : s )`

tvanfosson 2010-07-20 19:02:05

thanks it's work well. will you please tell me how to set the column name on header in my C# syntax.i want same work as my above example.thaks again for your help.

shamim 2010-07-21 07:02:59

@shamim - the simplest way is probably to just print strings that have the proper spacing, but you could also do a combination of `PadLeft` (or `PadRight`) and formatting with alignment as with the data.

tvanfosson 2010-07-21 11:31:16

Answer 2

A:

I think you are looking for string.Format(...). This allows you to format many different data types into a defined string format.

Philip Smith 2010-07-20 12:03:55

ansaurus

tags:

views:

answers:

How to write database value in text file on defined format

related questions