删除用户在网格中选择的行 [英] Deleting a Row which is selected by the user in the Grid

问题描述

我正在尝试从用户选择的数据库中删除一行。



删除功能的方法如下我调用的地方SP。

I am trying to delete a row from the database which has been selected by the user.

The method for the delete functionality is as below where i am calling a SP.

public static void DeleteSupplierDetails(String R1, String R2, String R3, String R4,out String message)
{  
   message = String.Empty;
   Database db =Helper.CreateDatabase();
   
   DbCommand cmd = db.GetStoredProcCommand("PDSS_STAGING_DEV.Delete_SupplierDetails");
   cmd.CommandType = CommandType.StoredProcedure;
  
   db.AddInParameter(cmd, "P_SOURCE_ENTITY", DbType.String, R1);
   db.AddInParameter(cmd, "P_PLANT_CODE", DbType.String, R2);
   db.AddInParameter(cmd, "P_SUPPLIER_NUMBER", DbType.String, R3);
   db.AddInParameter(cmd, "P_SUPPLIER_GROUP_NUMBER", DbType.String, R4);
   db.AddOutParameter(cmd,"P_RETURN_MSG", DbType.String,10);
   db.ExecuteNonQuery(cmd);
   message = cmd.Parameters["P_RETURN_MSG"].Value.ToString().Trim();
}

我该如何处理这个。



R1，R2 ......主键。

how can i proceed with this.

R1,R2... are the primary keys.

推荐答案

我已经回答了这个问题。见下面的网址：



如何在gridview中添加删除按钮？实体框架 [ ^ ]

I already have answered for this question. See below url :

How to add delete button in gridview ? Entity Framework[^]

ASPX代码

ASPX Code

<asp:GridView ID="grdShow" runat="server"

               AutoGenerateColumns="True">
               <Columns>
                   <asp:TemplateField>
                       <ItemTemplate>
                           <asp:Button runat="server" ID="buttonDelete" OnClick="buttonDelete_Click" Text="Delete" CommandArgument='<%#Eval("Id") %>'/>
                       </ItemTemplate>
                   </asp:TemplateField>
               </Columns>
           </asp:GridView>

注意：删除onrowdeleting =gdvData_RowDeleting





ASPX.cs代码

Note : Remove onrowdeleting="gdvData_RowDeleting"


ASPX.cs code

protected void buttonDelete_Click(object sender, EventArgs e)
{
    var buttonDelete = (Button)sender;
    var id = buttonDelete.CommandArgument;

}

这篇关于删除用户在网格中选择的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！