Datagrid Problem

[dr223]

Hi,

I am trying to insert data to my sql database from a datagrid, and have the following error as highlighted, how can I change the code to be able to insert the data to the table

Private Sub Exportdata()

        Dim cmd As New SqlCommand
        Dim conn As SqlConnection = GetDbConnection()
        Dim query As String

        Dim irow As Integer

        For irow = 0 To DataGrid1.Item - 1 
            Try
                query = "INSERT INTO dbo.tbltest (Pat_eid, event_date) VALUES (" & _
                            DataGrid1.Item(irow).Cells(0).Value & ", '" & _
                            DataGrid1.Item(irow).Cells(1).Value & ")"


                cmd = New SqlCommand(query, conn)
                cmd.ExecuteNonQuery()

            Catch ex As Exception

                MsgBox(ex.Message, MsgBoxStyle.Information, "VeriSIS")

            End Try

        Next irow

    End Sub

Thanks

[HanneSThEGreaT]

What error do you get??

Also, please, please use [CODE] tags when posting code.

It is explained here :

http://www.codeguru.com/forum/showthread.php?t=403073

[dr223]

The error message are;

1) Overload resolution failed because no accessible 'item' accepts this number of arguments
2) Value of type 'integer' cannot be converted to 'System.Windows.Forms.DataGridCell'


Thank you and next time I'll make sure I enclose the code.

[HanneSThEGreaT]

Ah, it seems as if you have forgotten to specify the column as well, like this :

DataGrid1.Item(irow, COLUMN HERE)

[dr223]

I still have an error here;

For irow = 0 To DataGrid1.Item - 1