本文介绍了单击按钮时如何在gridview中更新nvarchar变量？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ ID -------姓名--------数量---------状态--------按钮 - -------------------------------------------------- --------------- 1 ---------- S4 -------------- 3 -------------等待-------更新 1 ---------- S3 -------- ------ 5 -------------待定-------更新 这是我项目中的gridview示例。我想在每次点击更新按钮时从待发送中更新状态。 感谢您的帮助。 < asp：GridView ID = GridView1 runat = server AllowPaging = True AutoGenerateColumns = False BackColor = ＃CCCCCC BorderColor = ＃999999 BorderStyle = Solid BorderWidth = 3px CellPadding = 4 CellSpacing = 2 DataSourceID = SqlDataSource1 EmptyDataText = 没有要显示的数据记录。 ForeColor = 黑色 Width = 724px onrowcommand = GridView1_RowCommand > < Columns> < asp：BoundField DataField = Email_Address HeaderText = Email_Address SortExpression = Email_Address /> < asp：BoundField DataField = Order_Number HeaderText = 订单＃ SortExpression = Order_Number /> < asp：BoundField DataField = Item_Purchased_Number HeaderText = 已购买＃ SortExpression = Item_Purchased_Number /> < asp：BoundField DataField = 分支 HeaderText = 分支 SortExpression = 分支 /> < asp：BoundField DataField = Date_Issued HeaderText = Date_Issued SortExpression = Date_Issued /> < asp：BoundField DataField = 状态 HeaderText = 状态 SortExpression = 状态 /> < asp：BoundField DataField = 备注 HeaderText = 备注 SortExpression = 备注 /> < asp：TemplateField HeaderText = 查看更多 > < ItemTemplate> < asp：按钮ID = btnUpdate CommandArgument = <％＃（（GridViewRow）Container）.RowIndex％> CommandName = 已发送 runat = server Text = 更新 /> < / ItemTemplate > < / asp：TemplateField > < / 列 > < FooterStyle BackColor = ＃CCCCCC / > < HeaderStyle BackColor = Black Font-Bold = True ForeColor = 白色 /> < PagerStyle BackColor = ＃CCCCCC ForeColor = 黑色 HorizontalAlign = 左 /> < RowStyle BackColor = White /> < SelectedRowStyle BackColor = ＃000099 Font-Bold = True ForeColor = 白色 /> < SortedAscendingCellStyle BackColor = ＃F1F1F1 /> < SortedAscendingHeaderStyle BackColor = ＃808080 /> < SortedDescendingCellStyle BackColor = ＃CAC9C9 /> < SortedDescendingHeaderStyle BackColor = ＃383838 /> < / asp：GridView > < asp：SqlDataSource ID = SqlDataSource1 runat = server ConnectionString = <％$ ConnectionStrings：CellzoneDatafilesConnectionString1％> SelectCommand = SELECT * FROM [Customer_Remarks] WHERE（（[Branch] = @Branch）AND（[Status] = @Status）） > < SelectParameters> < asp：参数DefaultValue = SMDasmariñas Name = Branch Type = String /> < asp：参数DefaultValue = 待定名称= 状态类型= 字符串 /> < / SelectParameters > < / asp：SqlDataSource > protected void GridView1_RowCommand（ object sender，GridViewCommandEventArgs e） { if （e.CommandName == 已发送） { int index = Convert.ToInt32（e.CommandArgument.ToString（））; string stat = GridView1.Rows [index] .FindControl（ 状态）的ToString（）; stat = 已交付; } } 解决方案 ConnectionStrings：CellzoneDatafilesConnectionString1％> SelectCommand = SELECT * FROM [Customer_Remarks] WHERE（（[Branch] = @Branch） AND（[Status] = @Status）） > < SelectParameters> < asp：参数DefaultValue = SMDasmariñas Name = Branch Type = String /> ; < asp：参数DefaultValue = 待定名称= 状态类型= String /> < / SelectParameters > < / asp：SqlDataSource > 受保护 void GridView1_RowCommand（ object sender，GridViewCommandEventArgs e） { if （e.CommandName == 已交付） { int index = Convert.ToInt32 （e.CommandArgument.ToString（））; string stat = GridView1.Rows [index] .FindControl（ 状态）的ToString（）; stat = 已交付; } } 在grdview_RowCommand中你可以改变行的状态... 受保护 void grdSearch_RowCommand （ object sender，GridViewCommandEventArgs e） { e.Row.FindControl（ 状态）。文本= 已发送; } 我无法解释整个事情。所以看看这里： http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html [ ^ ]，它将解释如何插入，编辑，更新和使用asp.net删除gridview中的数据。 -KR ID-------Name--------Quantity---------Status--------Button-------------------------------------------------------------------1----------S4--------------3-------------Pending-------Update1----------S3--------------5-------------Pending-------UpdateThis is a sample gridview in my project. I want to update "Status" from "Pending to Delivered" everytime I click the button "Update".Thanks for helping.<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display." ForeColor="Black" Width="724px" onrowcommand="GridView1_RowCommand"> <Columns> <asp:BoundField DataField="Email_Address" HeaderText="Email_Address" SortExpression="Email_Address" /> <asp:BoundField DataField="Order_Number" HeaderText="Order #" SortExpression="Order_Number" /> <asp:BoundField DataField="Item_Purchased_Number" HeaderText="Purchased #" SortExpression="Item_Purchased_Number" /> <asp:BoundField DataField="Branch" HeaderText="Branch" SortExpression="Branch" /> <asp:BoundField DataField="Date_Issued" HeaderText="Date_Issued" SortExpression="Date_Issued" /> <asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" /> <asp:BoundField DataField="Remarks" HeaderText="Remarks" SortExpression="Remarks" /> <asp:TemplateField HeaderText="View More"> <ItemTemplate> <asp:Button ID="btnUpdate" CommandArgument="<%# ((GridViewRow) Container).RowIndex %> " CommandName="Delivered" runat="server" Text="Update" /> </ItemTemplate> </asp:TemplateField> </Columns> <FooterStyle BackColor="#CCCCCC" /> <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" /> <RowStyle BackColor="White" /> <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#F1F1F1" /> <SortedAscendingHeaderStyle BackColor="#808080" /> <SortedDescendingCellStyle BackColor="#CAC9C9" /> <SortedDescendingHeaderStyle BackColor="#383838" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CellzoneDatafilesConnectionString1 %>" SelectCommand="SELECT * FROM [Customer_Remarks] WHERE (([Branch] = @Branch) AND ([Status] = @Status))"> <SelectParameters> <asp:Parameter DefaultValue="SM Dasmariñas" Name="Branch" Type="String" /> <asp:Parameter DefaultValue="Pending" Name="Status" Type="String" /> </SelectParameters> </asp:SqlDataSource>protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e){ if (e.CommandName == "Delivered") { int index = Convert.ToInt32(e.CommandArgument.ToString()); string stat = GridView1.Rows[index].FindControl("Status").ToString(); stat = "Delivered"; }} 解决方案 ConnectionStrings:CellzoneDatafilesConnectionString1 %>" SelectCommand="SELECT * FROM [Customer_Remarks] WHERE (([Branch] = @Branch) AND ([Status] = @Status))"> <SelectParameters> <asp:Parameter DefaultValue="SM Dasmariñas" Name="Branch" Type="String" /> <asp:Parameter DefaultValue="Pending" Name="Status" Type="String" /> </SelectParameters> </asp:SqlDataSource>protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e){ if (e.CommandName == "Delivered") { int index = Convert.ToInt32(e.CommandArgument.ToString()); string stat = GridView1.Rows[index].FindControl("Status").ToString(); stat = "Delivered"; }}In grdview_RowCommand you can change the status of the row...protected void grdSearch_RowCommand(object sender, GridViewCommandEventArgs e) {e.Row.FindControl("Status").Text="Delivered";}Well I can't explain the entire thing. So take a look at here :http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html[^], which will explain how to insert, edit, update and delete data in gridview using asp.net.-KR 这篇关于单击按钮时如何在gridview中更新nvarchar变量？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！
