Solved

Delete row from gridview

Posted on 2008-10-16
5
894 Views
Last Modified: 2013-11-27
Hi all, I have a gridview that deletes just as it should, but then in the code-behind I have it deleting from other tables, based on what you deleted from the gridview.  This works FINE, BUT you MUST select the row from the gridview and THEN delete because of this line:
Dim BP_ID As String = GridView1.SelectedValue
I need that value, is there a way I can tell it something like DeletingValue or something, instead of the SelectedValue???
VS2005 VB.Net
Protected Sub GridView1_RowDeleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles GridView1.RowDeleting
        Dim BP_ID As String = GridView1.SelectedValue
        Dim BA_ID As String
        Dim sql7 As String = "Select BA_ID from bomAuxEquip where BP_ID = @BP_ID"
        Using conn As New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("HCISDataCARsConnectionString").ConnectionString)
            Dim cmd As New SqlCommand(sql7, conn)
            cmd.Parameters.AddWithValue("@BP_ID", BP_ID)
            Dim reader As SqlClient.SqlDataReader
            cmd.Connection.Open()
            reader = cmd.ExecuteReader
            reader.Read()
            BA_ID = reader("BA_ID")
            cmd.Connection.Close()
        End Using
 
        Dim sql17 As String = "DELETE FROM [bomSecAuxEquip] WHERE [BA_ID] = @BA_ID"
        Using conn As New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("HCISDataCARsConnectionString").ConnectionString)
            Dim cmd As New SqlCommand(sql17, conn)
            cmd.Parameters.Add(New SqlParameter("@BA_ID", BA_ID))
            conn.Open()
            cmd.ExecuteNonQuery()
            cmd.Connection.Close()
        End Using
 
    End Sub

Open in new window

0
Comment
Question by:ratkinso666
  • 4
5 Comments
 
LVL 13

Accepted Solution

by:
TechTiger007 earned 500 total points
ID: 22732774
Check if the value you are looking for is in e.Values array
Otherwise you can get the index of the deleting row as e.RowIndex, so when you say "gv.Rows[e.RowIndex];" you will get the deleting row from the grid view, you can get the value from the row.

Hope that helps
0
 

Author Comment

by:ratkinso666
ID: 22760194
Unfortunately, the only values I can find are for the SelectedValue...  If I Select a row and delete from another row, I am only seeing the the selected row's value.  I'm sure it must know the correct row to delete from somewhere, but I still don't see it???
0
 

Author Comment

by:ratkinso666
ID: 22760968
Does anyone else know how I can get this value??  I MUST have it, as the users are deleting without selecting and when they do that, they delete the children from the selected row, rather from the row they wanted to delete from...
0
 

Author Comment

by:ratkinso666
ID: 22780500
Here was the eventual solution:

Protected Sub GridView1_RowDeleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles GridView1.RowDeleting
        Dim i As Integer = e.RowIndex
        Dim BP_ID As String = GridView1.Rows(i).Cells(10).Text
0
 

Author Closing Comment

by:ratkinso666
ID: 31506807
Thank you very much for your help!!  Definitley got me on the right track.
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem to open text file 11 113
Receiving a string from a WebService Push 21 51
.NET 2008 VB and C# 6 28
Expression Evaluater 3 27
For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question