单击按钮时如何在gridview中更新nvarchar变量？ [英] How can I update nvarchar variable in gridview when click the button?

问题描述

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 = < span class =code-string>  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 = < span class =code-string> 已发送 runat =   server Text =  更新 /> 
 < /   ItemTemplate  >  
 < /   asp：TemplateField   >  
 < /  列 >  
< FooterStyle BackColor =  ＃CCCCCC / > 
< HeaderStyle BackColor =   Black Font-Bold =   True ForeColor =  白色 /> 
< PagerStyle BackColor =  ＃CCCCCC ForeColor =  黑色 Horizo​​ntalAlign =  左 /> 
< 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   >  
 

< pre lang =c＃> 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 = < span class =code-string> 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-------Update
1----------S3--------------5-------------Pending-------Update


This 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变量？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！