請教 GridView 編輯時的資料聯動問題

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:hbposv8ConnectionString %>" DeleteCommand="DELETE FROM [shouhuodan] WHERE [id] = @original_id AND (([item_no] = @original_item_no) OR ([item_no] IS NULL AND @original_item_no IS NULL)) AND (([shuliang] = @original_shuliang) OR ([shuliang] IS NULL AND @original_shuliang IS NULL)) AND (([jinjia] = @original_jinjia) OR ([jinjia] IS NULL AND @original_jinjia IS NULL)) AND (([zengpin] = @original_zengpin) OR ([zengpin] IS NULL AND @original_zengpin IS NULL)) AND (([jine] = @original_jine) OR ([jine] IS NULL AND @original_jine IS NULL))" InsertCommand="INSERT INTO [shouhuodan] ([item_no], [shuliang], [jinjia], [zengpin], [jine]) VALUES (@item_no, @shuliang, @jinjia, @zengpin, @jine)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [id], [item_no], [shuliang], [jinjia], [zengpin], [jine] FROM [shouhuodan]" UpdateCommand="UPDATE [shouhuodan] SET [shuliang] = @shuliang, [jinjia] = @jinjia, [zengpin] = @zengpin, [jine] = @jine WHERE [id] = @original_id AND (([item_no] = @original_item_no) OR ([item_no] IS NULL AND @original_item_no IS NULL)) AND (([shuliang] = @original_shuliang) OR ([shuliang] IS NULL AND @original_shuliang IS NULL)) AND (([jinjia] = @original_jinjia) OR ([jinjia] IS NULL AND @original_jinjia IS NULL)) AND (([zengpin] = @original_zengpin) OR ([zengpin] IS NULL AND @original_zengpin IS NULL)) AND (([jine] = @original_jine) OR ([jine] IS NULL AND @original_jine IS NULL))">

                <DeleteParameters>

                    <asp:Parameter Name="original_id" Type="Decimal" />

                    <asp:Parameter Name="original_item_no" Type="String" />

                    <asp:Parameter Name="original_shuliang" Type="Decimal" />

                    <asp:Parameter Name="original_jinjia" Type="Decimal" />

                    <asp:Parameter Name="original_zengpin" Type="Decimal" />

                    <asp:Parameter Name="original_jine" Type="Decimal" />

                </DeleteParameters>

                <InsertParameters>

                    <asp:Parameter Name="item_no" Type="String" />

                    <asp:Parameter Name="shuliang" Type="Decimal" />

                    <asp:Parameter Name="jinjia" Type="Decimal" />

                    <asp:Parameter Name="zengpin" Type="Decimal" />

                    <asp:Parameter Name="jine" Type="Decimal" />

                </InsertParameters>

                <UpdateParameters>

                    <asp:Parameter Name="item_no" Type="String" />

                    <asp:Parameter Name="shuliang" Type="Decimal" />

                    <asp:Parameter Name="jinjia" Type="Decimal" />

                    <asp:Parameter Name="zengpin" Type="Decimal" />

                    <asp:Parameter Name="jine" Type="Decimal" />

                    <asp:Parameter Name="original_id" Type="Decimal" />

                    <asp:Parameter Name="original_item_no" Type="String" />

                    <asp:Parameter Name="original_shuliang" Type="Decimal" />

                    <asp:Parameter Name="original_jinjia" Type="Decimal" />

                    <asp:Parameter Name="original_zengpin" Type="Decimal" />

                    <asp:Parameter Name="original_jine" Type="Decimal" />

                </UpdateParameters>

            </asp:SqlDataSource>

            <br />

            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="3" DataKeyNames="id" DataSourceID="SqlDataSource1" EnableModelValidation="True" GridLines="Vertical" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" OnRowEditing="GridView1_RowEditing">

                <AlternatingRowStyle BackColor="#DCDCDC" />

                <Columns>

                    <asp:BoundField DataField="item_no" HeaderText="貨號" InsertVisible="False"  ReadOnly="True" SortExpression="item_no" />

                    <asp:BoundField DataField="shuliang" HeaderText="數量" SortExpression="shuliang" />

                    <asp:BoundField DataField="jinjia" HeaderText="單價" SortExpression="jinjia" />

                    <asp:BoundField DataField="zengpin" HeaderText="贈品" SortExpression="zengpin" />

                    <asp:BoundField DataField="jine" HeaderText="金額" SortExpression="jine" />

                    <asp:CommandField ShowEditButton="True" />

                    <asp:CommandField ShowDeleteButton="True" />

                </Columns>

                <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />

                <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />

                <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />

                <RowStyle BackColor="#EEEEEE" ForeColor="Black" />

                <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />

            </asp:GridView>

using System;

using System.Collections.Generic;

using System.Drawing;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;



public partial class testtextboxchange : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        

    }



    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

    {

        GridView1.EditIndex = e.NewEditIndex;

        GridView1.EditRowStyle.BackColor = Color.OrangeRed;

        

        GridViewRow Row = GridView1.Rows[e.NewEditIndex];

        float j1 = 0;

        j1 = Convert.ToSingle(Row.Cells[1].Text.ToString()) * Convert.ToSingle(Row.Cells[2].Text.ToString());



        Row.Cells[4].Text = j1.ToString();

        GridView1.DataBind();



    }

}

uj5u.com熱心網友回復：

uj5u.com熱心網友回復：

uj5u.com熱心網友回復：

uj5u.com熱心網友回復：

標籤：ASP.NET

上一篇：求助！蘋果越獄后能不能用什么軟體修改通話記錄和短信

下一篇：有沒有大佬教下萌新。