Display format of character columns in a gridview like Access?

  • Thread starter Thread starter Savvoulidis Iordanis
  • Start date Start date
S

Savvoulidis Iordanis

I have a character(15) column filled with numbers, in my SQL database. I need
it to display like it does in Access when I set a format for the column, like
"000-000-000-000-000". How do I display the values the same way in a gridview
column? I can't manage to set the DataformatString properly.

TIA
 
I tried the following for DataFormatString:

{0:00000-00000-00000}
{0:"00000-00000-00000"}
{0:00000\-00000\-00000}
{0:99999-99999-99999}

What I want is to display the character data 123451234512345 as
12345-12345-12345
 
Back
Top