How to show monetary values in a DataGrid

[Henrique Berenguel]

Hello folks. I have a DataGrid in a Web Form. I´d like to show numeric
columns in Money format US$ 10,000.98. However, when I fill the DataGrid
from a SqlCommand, it fill in the DataGrid like this: 1000098. How do I do
that?

Thanks

[Vaibhav]

FormatNumber()

"Henrique Berenguel" <hberenguel@coimex.com.br> wrote in message
news:%23rh$4fAQDHA.704@tk2msftngp13.phx.gbl...

> Hello folks. I have a DataGrid in a Web Form. I´d like to show numeric
> columns in Money format US$ 10,000.98. However, when I fill the DataGrid
> from a SqlCommand, it fill in the DataGrid like this: 1000098. How do I do
> that?
>
> Thanks
>
>

[Henrique Berenguel]

But do you have a sample to show to me?


"Vaibhav" <consultvaibhav@yahoo.com> escreveu na mensagem
news:OduVp6BQDHA.2676@TK2MSFTNGP10.phx.gbl...

> FormatNumber()
>
> "Henrique Berenguel" <hberenguel@coimex.com.br> wrote in message
> news:%23rh$4fAQDHA.704@tk2msftngp13.phx.gbl...

> > Hello folks. I have a DataGrid in a Web Form. I´d like to show numeric
> > columns in Money format US$ 10,000.98. However, when I fill the DataGrid
> > from a SqlCommand, it fill in the DataGrid like this: 1000098. How do I

do

> > that?
> >
> > Thanks
> >
> >

>
>

[Naveen K Kohli]

Specify the DataFormatString for your bound column..

<asp:BoundColumn HeaderText="MoneyMoney" DataField="Price" DataFormatString
= {0:c} />

--
Naveen K Kohli
[url]http://www.netomatix.com[/url]
"Henrique Berenguel" <hberenguel@coimex.com.br> wrote in message
news:%23rh$4fAQDHA.704@tk2msftngp13.phx.gbl...

> Hello folks. I have a DataGrid in a Web Form. I´d like to show numeric
> columns in Money format US$ 10,000.98. However, when I fill the DataGrid
> from a SqlCommand, it fill in the DataGrid like this: 1000098. How do I do
> that?
>
> Thanks
>
>

[Henrique Berenguel]

The problem is that I´m using the option:

'Create columns automatically at run time' in the Property Builder of my
DataGrid.

Then I don´t have bound columns in the html, that´s the problem...

Look the code:

<asp:datagrid id="DataGrid1" runat="server" BackColor="White"
Width="692px" BorderColor="#999999" PageSize="3" AllowPaging="True"
BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical"
Height="94px">
<SelectedItemStyle Font-Bold="True" ForeColor="White"
BackColor="#008A8C"></SelectedItemStyle>
<AlternatingItemStyle BackColor="Gainsboro"></AlternatingItemStyle>
<ItemStyle ForeColor="Black" BackColor="#EEEEEE"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="White"
BackColor="#000084"></HeaderStyle>
<FooterStyle ForeColor="Black" BackColor="#CCCCCC"></FooterStyle>
<Columns><asp:ButtonColumn Text="Selecionar"
CommandName="Select"></asp:ButtonColumn></Columns>
<PagerStyle HorizontalAlign="Center" ForeColor="Black" BackColor="#999999"
Mode="NumericPages"></PagerStyle>
</asp:datagrid>

Is there an other way to do that?

Or will I have to reprogram everything to recreate the browser with bounds
columns?

Thanks in advance



"Henrique Berenguel" <hberenguel@coimex.com.br> escreveu na mensagem
news:uzn7FICQDHA.1584@TK2MSFTNGP11.phx.gbl...

> But do you have a sample to show to me?
>
>
> "Vaibhav" <consultvaibhav@yahoo.com> escreveu na mensagem
> news:OduVp6BQDHA.2676@TK2MSFTNGP10.phx.gbl...

> > FormatNumber()
> >
> > "Henrique Berenguel" <hberenguel@coimex.com.br> wrote in message
> > news:%23rh$4fAQDHA.704@tk2msftngp13.phx.gbl...

> > > Hello folks. I have a DataGrid in a Web Form. I´d like to show numeric
> > > columns in Money format US$ 10,000.98. However, when I fill the

DataGrid

> > > from a SqlCommand, it fill in the DataGrid like this: 1000098. How do

I

> do

> > > that?
> > >
> > > Thanks
> > >
> > >

> >
> >

>
>