Intersoft Community - WebGrid Enterprise - DataFormatString issue

DataFormatString issue

qq397472251 — Thu, 07 Oct 2010 21:23:30 GMT

thank you anyway!

DataFormatString issue

niven — Wed, 29 Sep 2010 22:14:07 GMT

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

DataFormatString issue

qq397472251 — Wed, 29 Sep 2010 02:30:31 GMT

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

DataFormatString issue

niven — Wed, 29 Sep 2010 00:41:53 GMT

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

DataFormatString issue

qq397472251 — Mon, 27 Sep 2010 22:12:22 GMT

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>

DataFormatString issue

niven — Mon, 27 Sep 2010 03:49:24 GMT

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

DataFormatString issue

qq397472251 — Sat, 25 Sep 2010 23:04:14 GMT

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>