首页 > 解决方案 > 无法读取 GridView 中特定列中的数据

问题描述

我有一个带有 mysql 连接的网格视图。我无法在 GridView 中读取更新的列值。 在此处输入图像描述

我尝试使用以下 aspx 代码:

<div class="table-responsive">
    <asp:GridView ID="GridView" HeaderStyle-BackColor="#2A3F54" HeaderStyle-ForeColor="White" DataKeyNames="order_id"                 unat="server" AutoGenerateColumns="false" Width="100%" Height="100%" CellSpacing="30" CellPadding="50"
    OnRowEditing="GridView_RowEditing" OnRowUpdating="GridView_RowUpdating">
    <Columns>                                 
        <asp:BoundField DataField="order_id" HeaderText="SL NO" ItemStyle-Width="80" ItemStyle-Height="40" />                                               
        <asp:BoundField DataField="order_date" HeaderText="ORDER DATE" DataFormatString = "{0:d}" ApplyFormatInEditMode = "true" ItemStyle-Width="80" />
        <asp:BoundField DataField="customer_id" HeaderText="CUSTMORE NAME" ItemStyle-Width="140"  />
         <asp:BoundField DataField="order_amt" HeaderText="AMOUNT" ItemStyle-Width="100" />                                
        <asp:BoundField DataField="updated_on" HeaderText="LAST UPDATED" DataFormatString = "{0:d}" ApplyFormatInEditMode = "true" ItemStyle-Width="130" /> 
        <asp:BoundField DataField="" HeaderText="REMARKS" ItemStyle-Width="130" />         
        <asp:CommandField ShowEditButton="true" />                   
        <asp:TemplateField ShowHeader="True" HeaderText="ACTION" ItemStyle-Width="100">
        <ItemTemplate>
              <asp:LinkButton ID="LinkButton" runat="server" OnClick="onViewClick">View</asp:LinkButton>
        </ItemTemplate>
        </asp:TemplateField>                      
    </Columns>
    </asp:GridView>
</div>

请找到以下 c# 代码:

 protected void GridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
 GridViewRow row = (GridViewRow)GridView.Rows[e.RowIndex];
        Label lblID = (Label)row.FindControl("lblID");

        TextBox oderAmt = (TextBox)row.Cells[3].Controls[0];

        string orderAmount = oderAmt.Text;         
        string Query = @"update app_order_master set order_amt="+ orderAmount+" where order_id=1";

        using (DataTable dt = SMSDBHelperFE.ExecuteReaderDataTable(CommandType.Text, Query, null))
        {               
            GridView.DataSource = dt;
            GridView.DataBind();
        }

          GridView.EditIndex = -1;         
        gvBind();
       }

请参阅上图,我无法读取我现在需要更新的金额值。

标签: c#asp.netaspxgridview

解决方案


推荐阅读