Delete selected value from gridview and database

Question

hi, i am using gridview and how can i delete my selected row of value from the database? i got 4 column of data from database which is code behind

Nilanka Dharmadasa · Answer

Hi, You haven't changed '2' as I asked. It should be 0 as name is the first column in your gird. change your code as follows. Dim row As GridViewRow = GridView1.SelectedRow cmd.CommandText = "DELETE FROM user_profile WHERE name='" & row.Cells( 0 ).Text & "'" If you still getting the error do a null check for row and row.Cells( 0 ).

Soh Kok Ting · Answer

so sry for my mistake and it work thx alot

Soh Kok Ting · Answer

hi, it have new error which is NullReferenceException was unhandled by user code :Object reference not set to and instance of an object. which is from this line cmd.CommandText = "DELETE FROM user_profile WHERE name='" & row.Cells(2).Text & "'"

Nilanka Dharmadasa · Answer

I had a look at your code. Change your code as follows. Dim row As GridViewRow = GridView1.SelectedRow cmd.CommandText = "DELETE FROM user_profile WHERE name='" & row.Cells( 2 ).Text & "'" Here, 2 shuld be changed to the index of your column 'name' in the gridview. (starting from 0)

Soh Kok Ting · Answer

i had my coding on this link : http://forums.asp.net/p/1489166/3495386.aspx#3495386

Soh Kok Ting · Answer

sry i new to this forum i try to paste my code but i seem to not appear from the preview

Nilanka Dharmadasa · Answer

if you can paste your code, i can point out the error.

Soh Kok Ting · Answer

i had try this but my code got error of this "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"

Delete selected value from gridview and database

Answers (8)