Using RadGridView to insert data in to MySql

[Mahir]

Hello guys/girls, how are you?

I hope you can help me.

 

I need to use RadGridView to insert / update / delete data from MySql. VB.NET

I've used this code :

-------------------------------------------------------------------------------------------------

statustestera = Me.RadGridView1.SelectedRows.Item(0).ToString
            statuspantograf = Me.RadGridView1.SelectedRows.Item(1).ToString
            statusdispecer = Me.RadGridView1.SelectedRows.Item(2).ToString
            statusproizvodnja = Me.RadGridView1.SelectedRows.Item(3).ToString
            statusdokumentacija = Me.RadGridView1.SelectedRows.Item(4).ToString

            comm.Connection = cn
            comm.CommandText = "INSERT INTO TBL_Priprema_GROB(StatusTeseta, StatusPantograf, StatusDispecer, StatusProizvodnja, StatusDokumentacija) VALUES('" & statustestera & "','" & statuspantograf & "''" & statusdispecer & "','" & statusproizvodnja & "',' " & statusdokumentacija & "')"
            comm.ExecuteNonQuery()

 

------------------------------------------------

but it returns with the Index can not be negative or less..... error. 

 

Can you please help 

 

 

[Mahir]

UPDATE*

Here is the full code

 

  cn.Open()

        Dim statustestera, statuspantograf, statusdispecer, statusproizvodnja, statusdokumentacija
        Dim comm As New SqlCommand
        For i As Integer = 0 To Me.RadGridView1.Rows.Count + 1


            statustestera = Me.RadGridView1.SelectedRows.Item(6).ToString
            statuspantograf = Me.RadGridView1.SelectedRows.Item(5).ToString
            statusdispecer = Me.RadGridView1.SelectedRows.Item(7).ToString
            statusproizvodnja = Me.RadGridView1.SelectedRows.Item(9).ToString
            statusdokumentacija = Me.RadGridView1.SelectedRows.Item(8).ToString

            comm.Connection = cn
            comm.CommandText = "INSERT INTO TBL_Priprema_GROB(StatusTeseta, StatusPantograf, StatusDispecer, StatusProizvodnja, StatusDokumentacija) VALUES('" & statustestera & "','" & statuspantograf & "''" & statusdispecer & "','" & statusproizvodnja & "',' " & statusdokumentacija & "')"
            comm.ExecuteNonQuery()
        Next
        cn.Close()

[Hristo]

Hi Mahir,

Thank you for writing.

In you code snippet I see that you are calling the ToString method on the GridViewRowInfo class. Please note that it will return the type of the row which I am not sure how you would like to use it. 

In case you are trying to access the cells you can iterate the selected rows and their cells respectively:

For i = 0 To Me.RadGridView1.SelectedRows.Count
    Dim row = Me.RadGridView1.SelectedRows(i)
    For j = 0 To row.Cells.Count
        Dim cell = row.Cells(j)
        Dim valueAsString = cell.Value.ToString()
    Next

Next

Please also check the following documentation articles showing how the rows and cells can be iterated:

• http://docs.telerik.com/devtools/winforms/gridview/rows/iterating-rows
• http://docs.telerik.com/devtools/winforms/gridview/cells/iterating-cells
  

I hope this helps. Should you have further questions please do not hesitate to write back.

Regards,
Hristo
Telerik by Progress