c# - 无法读取 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();
}
请参阅上图,我无法读取我现在需要更新的金额值。
解决方案
推荐阅读
- signalr - SignalR Core 缩放/托管
- types - 如何在 graphql 中表示字符串枚举(字符串文字联合)?
- html - SVG图像未在任何浏览器中加载
- regular-language - 正则表达式中设置的歼灭者
- react-native - React Native 更改日历高度
- c++ - 如何使用 MSVC 开发人员命令提示符编译涉及外部库的程序?
- wordpress - 自定义分类法以及当帖子选择了多个术语时如何保留它们?
- java - 替换 EditText 选择
- laravel - HTTP 请求由 apache 处理,但不是由 Laravel 处理?
- encoding - Transformer模型中位置编码的实现细节?