number format

[JFB]

Hi all,
How can I format a fax number as 888-333-444?
The number is coming from database as 8883334444
<ItemTemplate>
<%#container.dataItem("cfax")%>
</ItemTemplate>

Tks

JFB

[Morten Wennevik]

Hi JFB,

I'm sure there is a better method, and using DataBinder.Eval you should be
able to format the number using something like

[C#]
<%# DataBinder.Eval(Container.DataItem, "cfax", "{0:###-###-####}") %>

However, I was unable to properly format the number that way so an
alternative method is to call a method that formats the number.

[C#]
<%# Format(DataBinder.Eval(Container.DataItem, "fax")) %>

Where Format is defined as
public string Format(object value)
{
long n = Convert.ToInt64(value);
return n.ToString("###-###-####");
}

On Tue, 07 Nov 2006 05:58:16 +0100, JFB <he**@jfb.comwrote:

Hi all,
How can I format a fax number as 888-333-444?
The number is coming from database as 8883334444
<ItemTemplate>
<%#container.dataItem("cfax")%>
</ItemTemplate>

Tks

JFB

--
Happy Coding!
Morten Wennevik [C# MVP]

[JFB]

Tks for you reply Morten,
<%# DataBinder.Eval(Container.DataItem, "cfax", "{0:###-###-####}") %>
I try the above code but it's not showing the format in my datagrid and I
don't get any errors...
Any ideas??
Rgds

JFB


"Morten Wennevik" <Mo************@hotmail.comwrote in message
news:op.timwoeyfklbvpo@tr024...
Hi JFB,

I'm sure there is a better method, and using DataBinder.Eval you should be
able to format the number using something like

[C#]
<%# DataBinder.Eval(Container.DataItem, "cfax", "{0:###-###-####}") %>

However, I was unable to properly format the number that way so an
alternative method is to call a method that formats the number.

[C#]
<%# Format(DataBinder.Eval(Container.DataItem, "fax")) %>

Where Format is defined as
public string Format(object value)
{
long n = Convert.ToInt64(value);
return n.ToString("###-###-####");
}

On Tue, 07 Nov 2006 05:58:16 +0100, JFB <he**@jfb.comwrote:

Hi all,
How can I format a fax number as 888-333-444?
The number is coming from database as 8883334444
<ItemTemplate>
<%#container.dataItem("cfax")%>
</ItemTemplate>

Tks

JFB

--
Happy Coding!
Morten Wennevik [C# MVP]

[JFB]

Maybe because phone field is coming as varchar??
Any ideas
tks

JFB

"JFB" <he**@jfb.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

Tks for you reply Morten,
<%# DataBinder.Eval(Container.DataItem, "cfax", "{0:###-###-####}") %>
I try the above code but it's not showing the format in my datagrid and I
don't get any errors...
Any ideas??
Rgds

JFB


"Morten Wennevik" <Mo************@hotmail.comwrote in message
news:op.timwoeyfklbvpo@tr024...
Hi JFB,

I'm sure there is a better method, and using DataBinder.Eval you should be
able to format the number using something like

[C#]
<%# DataBinder.Eval(Container.DataItem, "cfax", "{0:###-###-####}") %>

However, I was unable to properly format the number that way so an
alternative method is to call a method that formats the number.

[C#]
<%# Format(DataBinder.Eval(Container.DataItem, "fax")) %>

Where Format is defined as
public string Format(object value)
{
long n = Convert.ToInt64(value);
return n.ToString("###-###-####");
}

On Tue, 07 Nov 2006 05:58:16 +0100, JFB <he**@jfb.comwrote:

>Hi all,
How can I format a fax number as 888-333-444?
The number is coming from database as 8883334444
<ItemTemplate>
<%#container.dataItem("cfax")%>
</ItemTemplate>

Tks

JFB

--
Happy Coding!
Morten Wennevik [C# MVP]

[Morten Wennevik]

I couldn't get it to work either, and it may be because it is not
identified as a number, but the other method should work.
On Tue, 07 Nov 2006 20:25:57 +0100, JFB <he**@jfb.comwrote:

Maybe because phone field is coming as varchar??
Any ideas
tks

JFB

"JFB" <he**@jfb.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

>Tks for you reply Morten,
<%# DataBinder.Eval(Container.DataItem, "cfax", "{0:###-###-####}") %>
I try the above code but it's not showing the format in my datagrid and
I
don't get any errors...
Any ideas??
Rgds

JFB


"Morten Wennevik" <Mo************@hotmail.comwrote in message
news:op.timwoeyfklbvpo@tr024...
Hi JFB,

I'm sure there is a better method, and using DataBinder.Eval you should
be
able to format the number using something like

[C#]
<%# DataBinder.Eval(Container.DataItem, "cfax", "{0:###-###-####}") %>

However, I was unable to properly format the number that way so an
alternative method is to call a method that formats the number.

[C#]
<%# Format(DataBinder.Eval(Container.DataItem, "fax")) %>

Where Format is defined as
public string Format(object value)
{
long n = Convert.ToInt64(value);
return n.ToString("###-###-####");
}

On Tue, 07 Nov 2006 05:58:16 +0100, JFB <he**@jfb.comwrote:

>>Hi all,
How can I format a fax number as 888-333-444?
The number is coming from database as 8883334444
<ItemTemplate>
<%#container.dataItem("cfax")%>
</ItemTemplate>

Tks

JFB

--
Happy Coding!
Morten Wennevik [C# MVP]

--
Happy Coding!
Morten Wennevik [C# MVP]

[JFB]

Tks for reply Morten,
Either way I couldn't made it to work.
I'm using vb.net function

Function Format(ByVal value As Object)

Dim n As Long = Convert.ToInt64(value)

Return n.ToString("###-###-####")

End Function

ERROR: System.FormatException: Input string was not in a correct format. at
System.Number.ParseInt64(String s, NumberStyles style, NumberFormatInfo
info) at System.String.System.IConvertible.ToInt64(IFormatP rovider provider)
at System.Convert.ToInt64(Object value)

Any Ideas??
Tks

JFB
"Morten Wennevik" <Mo************@hotmail.comwrote in message
news:op***************@tr024.bouvet.no...
I couldn't get it to work either, and it may be because it is not
identified as a number, but the other method should work.
On Tue, 07 Nov 2006 20:25:57 +0100, JFB <he**@jfb.comwrote:

Maybe because phone field is coming as varchar??
Any ideas
tks

JFB

"JFB" <he**@jfb.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

>Tks for you reply Morten,
<%# DataBinder.Eval(Container.DataItem, "cfax", "{0:###-###-####}") %>
I try the above code but it's not showing the format in my datagrid and
I
don't get any errors...
Any ideas??
Rgds

JFB


"Morten Wennevik" <Mo************@hotmail.comwrote in message
news:op.timwoeyfklbvpo@tr024...
Hi JFB,

I'm sure there is a better method, and using DataBinder.Eval you should
be
able to format the number using something like

[C#]
<%# DataBinder.Eval(Container.DataItem, "cfax", "{0:###-###-####}") %>

However, I was unable to properly format the number that way so an
alternative method is to call a method that formats the number.

[C#]
<%# Format(DataBinder.Eval(Container.DataItem, "fax")) %>

Where Format is defined as
public string Format(object value)
{
long n = Convert.ToInt64(value);
return n.ToString("###-###-####");
}

On Tue, 07 Nov 2006 05:58:16 +0100, JFB <he**@jfb.comwrote:

>>Hi all,
How can I format a fax number as 888-333-444?
The number is coming from database as 8883334444
<ItemTemplate>
<%#container.dataItem("cfax")%>
</ItemTemplate>

Tks

JFB

--
Happy Coding!
Morten Wennevik [C# MVP]

--
Happy Coding!
Morten Wennevik [C# MVP]

[JFB]

Never Mine Morten.. it was the empty phone field.
Tks
JFB
"Morten Wennevik" <Mo************@hotmail.comwrote in message
news:op***************@tr024.bouvet.no...
I couldn't get it to work either, and it may be because it is not
identified as a number, but the other method should work.
On Tue, 07 Nov 2006 20:25:57 +0100, JFB <he**@jfb.comwrote:

Maybe because phone field is coming as varchar??
Any ideas
tks

JFB

"JFB" <he**@jfb.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

>Tks for you reply Morten,
<%# DataBinder.Eval(Container.DataItem, "cfax", "{0:###-###-####}") %>
I try the above code but it's not showing the format in my datagrid and
I
don't get any errors...
Any ideas??
Rgds

JFB


"Morten Wennevik" <Mo************@hotmail.comwrote in message
news:op.timwoeyfklbvpo@tr024...
Hi JFB,

I'm sure there is a better method, and using DataBinder.Eval you should
be
able to format the number using something like

[C#]
<%# DataBinder.Eval(Container.DataItem, "cfax", "{0:###-###-####}") %>

However, I was unable to properly format the number that way so an
alternative method is to call a method that formats the number.

[C#]
<%# Format(DataBinder.Eval(Container.DataItem, "fax")) %>

Where Format is defined as
public string Format(object value)
{
long n = Convert.ToInt64(value);
return n.ToString("###-###-####");
}

On Tue, 07 Nov 2006 05:58:16 +0100, JFB <he**@jfb.comwrote:

>>Hi all,
How can I format a fax number as 888-333-444?
The number is coming from database as 8883334444
<ItemTemplate>
<%#container.dataItem("cfax")%>
</ItemTemplate>

Tks

JFB

--
Happy Coding!
Morten Wennevik [C# MVP]

--
Happy Coding!
Morten Wennevik [C# MVP]