Datagrid:Current DataRow Copy to NextRow(SOLVED)

[Irkiere]

Hi people!I have gotten along in my PDA software development nicely with some help from others.I need some assistance once again.Right now,i have a row of data(in a datagrid) that i wish to copy to a new row right below it.How do i go about it?Pls help if u can.I would appreciate it alot!

[Irkiere]

Pls help if u can,i have been trawling through the net and can't find any suitable answers!

[Strider]

firstly is the datagrid based on a database table or are you just adding data to it using datarow method?
secondly if it is based on table do you want to insert the data to table or just add it to the datagrid

[Irkiere]

Thanks for bothering once more strider.Yah,my datagrid is bound to a dataset.Anyway,i have gotten the solution from a friend of mine(Dennis Oh from Singapore).I'm at home now and will post the solution tomorrow morning to share with you guys just in case someone else needs it.Paying it forward !!

[Irkiere]

Private Sub DuplicateRow(ByRef dt As DataTable, ByRef dg As DataGrid, ByVal iIndex As Integer)
'iIndex is the row to duplicate
Dim dr As DataRow = dt.NewRow
Dim iCol As Integer
For iCol = 0 To 32 'dt.Columns.Count
With dt.Rows(iIndex)
dr.Item(iCol) = .Item(iCol)
End With
Next
dt.Rows.InsertAt(dr, iIndex)
dg.DataSource = dt

End Sub

Private Sub MenuNewUnit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles MenuNewUnit.Click

Call DuplicateRow(ds.Tables("MechanismLifeTest"), DataGrid1, ds.Tables("MechanismLifeTest").Rows.Count - 1)

End Sub