i have a problem in deleting a row from datagridview in vb.net

Question

0.00/5 (No votes)

See more:

hello everybody,
in my program,i have a grid view that show some selected rows from a table in my database.in my form i have a gridview and two button.deletebutton and modifybutton.when i select a row in my gridview and then click delete button , iwant the program to delete that selected row and apply it to its source in my data base.but an error occure while debugging it.here is my code:

VB

Private Sub ButtonX4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonX4.Click
        For Each rows As DataGridViewRow In DataGridView2.SelectedRows
            DataGridView2.Rows.Remove(rows)
        Next
    End Sub

and the error that is occured is:
Unable to cast object of type 'System.Windows.Forms.MouseEventArgs' to type 'System.Windows.Forms.DataGridViewCellEventArgs'.
please help me.
does this code apply the changes to database?
Thanks in Advanced,

Posted 10-Jun-11 3:26am

nafiseh.s

Updated 10-Jun-11 3:31am

v2

Add a Solution

Comments

Wayne Gaylard 10-Jun-11 9:46am

Where do you get the error. This sounds like you are trying to use a mouse event handler to handle a gridview's event, and that the delegate is the wrong type.

Dave Kreskowiak 10-Jun-11 9:50am

It's impossible for that error to show up in the code snippet you posted.

nafiseh.s 10-Jun-11 9:55am

i just select row from gridview and then click delbutton.the error exactly show infront of "Private Sub ButtonX4_Click".why????

nafiseh.s 10-Jun-11 9:56am

but this error shows up!!!!

nafiseh.s 10-Jun-11 9:59am

i solve my problem.but ihave another question.this code does not apply the changes to database.how can i apply the changes to database?

nafiseh.s 10-Jun-11 10:13am

is there any one to help me???

DaveAuld 11-Jun-11 9:36am

Never try to delete anything using For Each in a forward direction, it screws the enumerator up as your index will change after the first item is deleted. Do the operation backwards.
After making the delete, you will also need to perform the commit. (Update).

strogg 12-Jun-11 14:46pm

There's no error in your code shown. I guess the error is occurring in another event handler of your datagridview. Comment out other events handled by the datagridview. That'll help you to narrow down to the mistake.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kschuler · Answer 1 · 2011-06-16T05:55:00

Solution 1

It sounds like you need a more general overview of how DataGridViews work and how to connect to databases. Try reading some CP articles[^] and research the concepts of data binding[^].

Hope this helps.

Posted 16-Jun-11 5:55am

Kschuler