Intersoft Solutions - Community - WebGrid Enterprise

Create New

New Discussion
New Question
New Product Feedback

Post Reply

Frank BruceMember

Posted: September 25, 2010 11:04 PM

I use DataFormatString="$##,###.00", when the cell into EditState ,I can not see the oldvalue, but the other cells have not this problem,how to fix it???

<ISWebGrid:WebGridColumn Caption="FoodPrice" DataFormatString="$##,###.00" DataType="System.Decimal"  DataMember="price" Name="price"  Width="100px" >
</ISWebGrid:WebGridColumn>

2 attachments

oldValue.jpg

intoEditState.jpg

Quick Reply

Quote

All Replies

Niven PrasetyaMember

Posted: September 27, 2010 3:49 AM in response to Frank Bruce

Hi Frank,

I am not able to replicate your issue here.

May I know your WebGrid and Framework version?

I have attach a version of mine with your scenario.

Best regards,

Niven Prasetya

2 attachments

Frank BruceMember

Posted: September 27, 2010 10:12 PM in response to Niven Prasetya

I think that I find the problem.
Because I use $,not ＄,it cause wrong.
Anyway,webgrid does not support '$'.

WebGrid version:V7.0.7200
Framework version:3.0.5000.755
my OS: winserver2003+VS2008

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="dataFormatDemo.aspx.cs" Inherits="dataFormatDemo" %>

<%@ Register Assembly="ISNet.WebUI.WebGrid" Namespace="ISNet.WebUI.WebGrid" TagPrefix="ISWebGrid" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<html>
<head runat="server">
    <title>dataFormatDemo </title>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <ISWebGrid:WebGrid ID="WebGrid1" runat="server" Height="280px" DefaultStyleMode="Win7" UseDefaultStyle="True"
                Width="800px" DataSourceID="AccessDataSource1">
                <LayoutSettings AllowAddNew="Yes" AllowDelete="Yes" AllowEdit="Yes" NewRowLostFocusAction="AlwaysUpdate">
                </LayoutSettings>
                <RootTable DataKeyField="vouid">
                    <Columns>
                        <ISWebGrid:WebGridColumn Caption="商品名称" DataMember="商品名称" Name="商品名称">
                        </ISWebGrid:WebGridColumn>
                      <%-- anyway,if Use DataFormatString="＄",it has no problem!--%>
                       <ISWebGrid:WebGridColumn Caption="价格范围" DataType="System.Decimal" DataFormatString="$##,###.00"  DataMember="价格范围" Name="价格范围" 
                            >
                        </ISWebGrid:WebGridColumn>
                        <ISWebGrid:WebGridColumn Caption="vouid" DataMember="vouid" Name="vouid" 
                            DataType="System.Int32">
                        </ISWebGrid:WebGridColumn>              
                        </Columns>
                </RootTable>
            </ISWebGrid:WebGrid>
            <asp:AccessDataSource ID="AccessDataSource1" runat="server" 
                DataFile="~/App_Data/Product.mdb" 
                DeleteCommand="DELETE FROM [ProductInfo] WHERE [vouid] = ?" 
                InsertCommand="INSERT INTO [ProductInfo] ([商品名称], [价格范围], [vouid]) VALUES (?, ?, ?)" 
                SelectCommand="SELECT [商品名称], [价格范围], [vouid] FROM [ProductInfo]" 
                
                UpdateCommand="UPDATE [ProductInfo] SET [商品名称] = ?, [价格范围] = ? WHERE [vouid] = ?">
                <DeleteParameters>
                    <asp:Parameter Name="vouid" Type="Int32" />
                </DeleteParameters>
                <UpdateParameters>
                    <asp:Parameter Name="商品名称" Type="String" />
                    <asp:Parameter Name="价格范围" Type="Decimal" />
                    <asp:Parameter Name="vouid" Type="Int32" />
                </UpdateParameters>
                <InsertParameters>
                    <asp:Parameter Name="商品名称" Type="String" />
                    <asp:Parameter Name="价格范围" Type="Decimal" />
                    <asp:Parameter Name="vouid" Type="Int32" />
                </InsertParameters>
            </asp:AccessDataSource>
        </div>
    </form>
</body>
</html>

Quick Reply

Quote

Niven PrasetyaMember

Posted: September 29, 2010 12:41 AM in response to Frank Bruce

Hi Frank,

Everything looks fine with my sample, I have attach a video by using＄and $. Both of them works fine.

Please tell me the WebGrid build version v7.0.7200.xxx, xxx indicating the build version.

Best regards,

Niven Prasetya

2 attachments

Frank BruceMember

Posted: September 29, 2010 2:30 AM in response to Niven Prasetya

WebGrid version:V7.0.7200
Framework version:3.0.5000.755
my OS: winserver2003+VS2008
I down load latest version (2010-08-13)

Quick Reply

Quote

Niven PrasetyaMember

Posted: September 29, 2010 10:14 PM in response to Frank Bruce

Good Morning Frank,

Please go to C:\Program Files\Intersoft Solutions\WebUI Studio for ASP.NET\WebGrid.NET 7.0\Bin, right click on the ISNet.WebUI.WebGrid.dll then click on Properties. Go to Details tab and let me know what is your File Version.

You can get the latest HotFix at http://www.intersoftpt.com/Community/WebGrid/Update-Bug/ thread. Just to make sure to always use the latest hotFix to get a better results. Please refer to http://intersoftpt.com/build/ApplyHotfix on how to install the HotFixes.

I'm using WebGrid 7.0.7200.404 and Framework 3.0.5000.755. As the videos I have given to you, I could not find any problem within the＄and $.

Thank you. and have a nice day.

Best regards,

Niven Prasetya

Quick Reply

Quote

Frank BruceMember

Posted: October 7, 2010 9:23 PM in response to Niven Prasetya

thank you anyway!

Quick Reply

Quote