Datagridview error

You might want to post the code where you get the error.  (you don't use e.row anywhere I see in your code snippet).

I get error on     For Each rw As DataGridViewRow In DataGridView1.Rows

If con.State = ConnectionState.Closed Then
                    con.Open()
                End If
                com.Connection = con
                DataGridView1.VirtualMode = False
                'Commented out for messsage queue load on the server
                If DataGridView1.Rows.Count > 0 Then
                    'Commented out for messsage queue load on the server
                [b]    For Each rw As DataGridViewRow In DataGridView1.Rows[/b]

                        com.CommandText = ("insert query" )


                        count = com.ExecuteNonQuery()
                        'Commented  for messsage queue load on the server
                        Application.DoEvents()
                        'Commented  for messsage queue load on the server

                        'Objwriter.WriteLine("Total Rows:" + count.ToString)
                        'Objwriter.Flush()

                        com.CommandTimeout = 725
                        com.ExecuteNonQuery()


                        Success = True
                    Next
                End If

Select allOpen in new window

error2 on the same line :

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Is there any check needed on the code?

With the exact error message you show in the question body?

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
 on this
For Each rw As DataGridViewRow In DataGridView1.Rows

>>Index was out of range....

That message doesn't make sense with the line you say is generating the error.

When i check for datagridview1.rows.count it shows zero

>>When i check for datagridview1.rows.count it shows zero

How on earth is it actually reaching the line giving the error then?
   
            If DataGridView1.Rows.Count > 0 Then
                    'Commented out for messsage queue load on the server
                   For Each rw As DataGridViewRow In DataGridView1.Rows

I have no clue Andy,it is what  it is

Hmmmm.
Reboot your PC then check if it is still giving problems

Andy,its a windows service.
The code is written on timer_click event.
When the timer _click is fired ..it leaves the loop and the cursor gets on Timer_Click ...

Please try rebooting the PC.  It is surprising just how many strange errors get cured by such a simple measure.

OK..its a server cant  restart it , will have to wait till weekend

OK.


ps.  I know you have a good reason but why have you got a windows service interacting with a GUI ?

I am debugging

Also I need to know how I can make the timer_click wait till the looping of datagridview completes rather than just jumping on the timer_click event and leaving the loop

I have a horrible feeling you are creating problems which won't exist in the real version.

Why?

I have not added code ,its already there I am debugging it

I've requested that this question be deleted for the following reason:

Neglected question.Please delete it

I haven't neglected this.  You said yourself it would have to wait for the weekend to enable you to try a reboot.