使用sqlserver通过gridview删除 [英] delete through gridview using sqlserver

问题描述

我在sqlserver中有表我希望在vb.net thnx中使用sqlserver通过gridview删除行

解决方案

使用以下步骤。



1）将ID'（主键）分配给Gridview

2）使用Gridview行删除事件。（使用命令名称）

3）获取用户点击的行的ID以删除。

4）在删除sql查询中使用ID&执行sql命令。

5）成功删除行后绑定Gridview。



使用以下代码。

  protected   void  gvAcceptanceStatus_RowDeleting（ object  sender，GridViewDeleteEventArgs e）
 {
  string  ObvID = gvAcceptanceStatus.Rows [e.RowIndex] .Cells [ 3 ] Text.ToString（）; 
  //  或 
  string  ObvID = gvAcceptanceStatus.DataKeys [index] .Values [  ObservationID]。ToString（ ）; 
 conn.Open（）; 
 SqlCommand cmd =  new  SqlCommand（  sp_DeleteInfo ，conn）; 
 cmd.CommandType = CommandType.StoredProcedure; 
 cmd.Parameters.AddWithValue（  ID，ObvID）; 
 
 
  try  
 {
 
 cmd.ExecuteNonQuery（）; 
} 
  catch （例外情况）
 {
  throw   new 异常（ 异常添加帐户。 + ex.Message）; 
} 
 最后 
 {
 conn.Close（）; 
} 
 BindgvAcceptanceStatus（）; 
 
} 

在aspx页面中： -

 <   asp：gridview     id   =  gvAcceptanceStatus    runat   =  server    autogeneratecolumns   =  False    datakeynames   =  ObservationID    onrowdeleting   =  gvAcceptanc eStatus_RowDeleting >  
 

将其转换为VB.NET。 />


希望这会有所帮助。 ：）

i have table in sqlserver i want to delete rows through gridview using sqlserver in vb.net thnx in advance

解决方案

Use the following steps.

1) assign ID''s (Primary Key) to Gridview
2) Use Gridview Row Deleting event.(using Command name)
3) Get the ID of row clicked by user to Delete.
4) Use ID in delete sql query & execute sql command.
5) Bind Gridview after successful deletion of row.

Use the following code.

protected void gvAcceptanceStatus_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string ObvID =gvAcceptanceStatus.Rows[e.RowIndex].Cells[3].Text.ToString();
//OR
               string ObvID=gvAcceptanceStatus.DataKeys[index].Values["ObservationID"].ToString();
            conn.Open();
            SqlCommand cmd = new SqlCommand("sp_DeleteInfo", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("ID",ObvID);
        
            
            try
            {

                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw new Exception("Exception adding account. " + ex.Message);
            }
            finally
            {
                conn.Close();
            }
            BindgvAcceptanceStatus();
            
        }

In aspx page:-

<asp:gridview id="gvAcceptanceStatus" runat="server" autogeneratecolumns="False" datakeynames="ObservationID" onrowdeleting="gvAcceptanceStatus_RowDeleting">

Convert it to VB.NET.

Hope this helps. :)

这篇关于使用sqlserver通过gridview删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！